[HammondEgger]

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!