stored procedure reading from other database

[jamert]

Hi i'm using sql 2k. I would like to write a storedProcedure in 2k db, that will read data from a table in an access database based on a mutual id. Is this possible and if so, how would one go about it, thanks!

 

[pbaldy]

You can add the Access database as a Linked Server (under Security in Enterprise Manager). That will enable you to include it in an SQL statement, using the 4 part reference.

Paul
MS Access MVP 2007/2008