SQL Server 2k VS Access

Results 1 to 2 of 2

Thread: SQL Server 2k VS Access

  1. #1
    Join Date
    Dec 1969

    Default SQL Server 2k VS Access

    Ok...I think I might have made a blunder. I&#039;m developing on SQL Server, but production has to be made to Access. What I&#039;m wondering is this:<BR><BR>If I&#039;m using views through the VS.NET Server Explorer&#039;s Data Connections to generate my SQL statements, am I going to need to make any changes to the statement syntax so that it will work with Access, or are they copacetic?

  2. #2
    Join Date
    Dec 1969

    Default Access doesn't have VIEWs...

    ...but you might be able to convert each VIEW to a stored access query and then use it. But you can&#039;t create a stored query from ADO; you have to use ADOX to do so. If that matters.<BR><BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adocreateq.asp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts