Access and SQL server

  • Thread starter Thread starter FatMan
  • Start date Start date
F

FatMan

Can anyone tell me how I link a table from SQL Server 2008 Exspress to a
Access 2000 database?

Any help is greatly appreciated.

Thanks,
FatMan
 
First, create a DSN that points to the SQL-Server db.

Open your Access database.

Use File|Get External...| Link..., find your DSN, select your tables.

NOTE: you will have to have permissions to see/use the SQL-Server tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff:
Thank you for your info. I am totaly new to SQL server. Can you explain
how/where I go to add a user to enssure I have the proper permissions.

Thanks,
FatMan
 
You might have better luck asking your SQL-Server questions at a SQL-Server
newsgroup...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top