Access and SQL server

[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

 

[Jeff Boyce]

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

 

[FatMan]

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

 

[Jeff Boyce]

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

Regards

Jeff Boyce
Microsoft Office/Access MVP