[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!

[Pat Phelan]

Microsoft Access uses the Microsoft Jet database engine, which is where the "intersting" SQL syntax originates. I don't know of any way to get Microsoft SQL to use the Jet dialect directly (from within MS-SQL), but you can get there another way.

You can leave the data in Microsoft SQL, but create an ADP file so that you get a Jet "front end" that can use the Jet syntax to access data from a Microsoft SQL Server.

I'm trying to remember to visit here more often, but I'm not always good about remembering especially when under deadlines (like I am right now). If you have questions about this process, you can post them here or you can visit DBForums which is another iNet site that deals specifically with database issues. You can visit the DBForums Microsoft Access Forum or DBForums Microsoft SQL Forum for more information.

-PatP