SQL Server from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I posted this in the access.queries section...probably the wrong place. Here
is my question:

I have an MSDE database on my MS Server 2003 next to my desk (192.168.2.201).
It authenticates by SQL or NT, either one. It has a DB called PMDB. In it is
a table called "usession". I want to use an Access form to do a simple
operation on that table. I've never linked to a SQL Server database before.
Guidance? (Access 2007.)
 
Jim -

Open the Access front end and go to File>Get External Data>Link Tables...
This will start a wizard that should walk you through the process
 
Back
Top