Page 1 of 1

Sql problem

Posted: Sat Aug 18, 2007 6:40 am
by hershy
I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA.
Can someone tell me how to do this or tell me about some tutorial for this?

Posted: Sun Aug 19, 2007 11:02 pm
by califdon
I believe you can just link to the MS SQL server from Get External Data in the Access File menu.

Posted: Mon Aug 20, 2007 10:40 am
by josa
If you are just using Access as a front end to MSSQL i would recommend creating an Access Project (adp). In Access you select new from the file menu and chose "Project using existing data...".

/josa