2 sql server connection database ms access project

I

inarobis

Hello guys,

I have a problem with a ms access. I would like to open 2 databases in
the same project. I would be able to do query between this two database
and also update the tables.

I tried already with the ms access project : So, I connect to one
database and linked table to another one, and works file but I cannot
updated the database that I linked tables.

how can I have two connection at the same.... is that possible?

obj1 = "Driver={SQL Server};Server={};Database=pubs;Uid=sa;Pwd={};"
obj2 = "Driver={SQL Server};Server={};Database=test;Uid=sa;Pwd={};"

any suggestion will be appreciate?

Ina
 

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

Access 2007 - DoCmd.TransferDatabase not saving UID and PW 2
MS Project Center-Autolink column fields 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Connection string problems 2
Trusted Connection in Pass-trough query... 4
Keeping Access Running Between SQL Server Reboots 3
Unable to update/add records in connected SQL Server tables 4
Connecting to SQL Server DB in Windows 7 1

Top