Access.mdb to SQL Server BE - Linked

[ericchajmovic]

I have a database that was created in Access 2002, and will be moved up to SQL Server 2000. I used the Upsizing Wizard, which gave me an Access Front End (mdb) and a SQL Server backend.

Is is ok that the Front End in Access is mdb, and if so, what's the difference between an .adp and mdb?

Thanks,

Eric Chajmovic

 

[tlbroadbent]

Check the following articles about upsizing and Access projects.

http://msdn.microsoft.com/library/en-us/off2000/html/acconchoosehowtoupsizeapplication.asp

http://msdn.microsoft.com/library/en-us/off2000/html/acconaboutmicrosoftaccessproject.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.