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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to connect...

Author  Topic 

cidr
Posting Yak Master

207 Posts

Posted - 2008-09-02 : 10:13:34
This seems like a silly question but I have developed a SQL Server db which has an Access frontend. I developed it using SQL Server installed on my PC.

The Backend is finished and it's been put on the Server Database engine.

My question is, How do I connect to it. Do I use Management studio? Another side question is, Can I set up an ODBC connection with my PC so that I can link the tables to the Access Frontend and will the ODBC connection work only for my machine?

Thanks for any help in advance.

Paul

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-02 : 12:40:24
Yes use managment studio.

Yes you can connect your access frontend to it. But there are better ways about it. If you explain what you are trying to do ?
Go to Top of Page
   

- Advertisement -