Sql problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hershy
Spammer :|
Posts: 10
Joined: Thu Aug 09, 2007 5:25 am

Sql problem

Post 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?
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Post by califdon »

I believe you can just link to the MS SQL server from Get External Data in the Access File menu.
josa
Forum Commoner
Posts: 75
Joined: Mon Jun 24, 2002 4:58 am
Location: Sweden

Post 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
Post Reply