ADP - Can I Connect (2) SQL Server Database?

[smedvid]

I am attempting to convert an MDB with Linked tables to (2) SQL Server Databases on the same server to an ADP. On the surface, it appears you can only connect to (1) database via the UDL Connection Dialog. Is this correct?

I really need to mimic the same functionality of having linked tables from (2) databases.

tia,


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[belovedcej]

To my knowledge, you can only connect to one database.

However, you can use stored procedures to pull data from and update data to another database. If you are writing an sql proc (or view or function) and you want to reference an object in a different database, simply do the following:

instead of select * from table
write: select * from databasename.databaseowner.table

And your access database can of course run those stored procedures.

Hope that helps.