SQL Server from Access

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.)
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conneting to SQL server, Need advice 3
Outer Join SQL Server table with Access table, How ? 2
CONNECT MICROSOFT ACCESS TO MICROSOFT SQL SERVER 2008 1
Linking a table on Access 2007 4
Stored Procedure in SQL Server vs MSDE 2005 SQL Server 2
Move Access Table to SQL Server 1
Append data to linked SQL Server 2008 table 0
Linked tables to SQL 1

Top