Move Access application to SQL2000

[sguslan]

Hi

I have an application written in Access 2000 and uses access database to store data. For better performance and security, I need to move the data to SQL 2000 but maintain the same Access interface and forms. Is it easy to do so and what do I have to do....

Thanx

 

[tlbroadbent]

Check these articles. They discuss converting to Access to SQL Server.

http://msdn.microsoft.com/library/en-us/dnsqlsm/html/upsize00.asp

http://support.microsoft.com/support/kb/articles/Q237/9/80.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[sguslan]

Thanx Terry ..

With your presence at tek-tips, it is worth while to have tek-tips part of my daily reading routine !