Hi Everyone,
This is my first post on this forum.
I have a question regarding a DB conversion project I am in the middle of. I'm migrating a site from a MS-Acess DB to MS-SQL. I can convert the DB without trouble, but my problem lies in the queries that were written to query the Access DB.
There are a few things different about the syntax between Access SQL and MS-SQL's SQL. Do any of you know if there is a switch within MS-SQL that will render MS-SQL compatible with SQL written for Access?
I have found nothing on this so far so I am hoping some person on this forum smarter than myself might know.
Thanks in advance!
