Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server database with MS Access forms

Author  Topic 

santana
Yak Posting Veteran

72 Posts

Posted - 2010-01-12 : 07:18:32
Hi,

I have forms in MS Access, and I would like to link those to SQL Server 2005 (database).

Can I do this? How?

Thanks for all!

Regards,

santana

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2010-01-12 : 07:26:41
In Access 2003, go to File->Get External Data->Link Tables, select File Type as ODBC databases and then depending on what kind of DSN you want to use, follow through the instructions in the wizard.
Go to Top of Page
   

- Advertisement -