By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,082 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,082 IT Pros & Developers. It's quick & easy.

open ADO connection to different mdb

P: n/a
Can someone shed some light on how to open an ADO connection to a
recordset in a different Access database.

Dim cnCurrent As ADODB.Connection
Dim cnOther As ADODB.Connection

Set cnCurrent = CurrentProject.Connection
Set cnTables.Open = "c:\mydb.mdb"
The code to open cnCurrent works but the code to open cnTables does
not work.

Please help!!!! I can't find any relevant examples.

Oct 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mon, 15 Oct 2007 13:53:04 -0700, lyle <ly************@gmail.com>
wrote:

That's a nice touch. You're probably writing this because of a bad
experience? Otherwise you would just write:
..Open
debug.assert ((.State And adStateOpen) = adStateOpen)

Can you elaborate?

-Tom.

.Open
While (.State And adStateOpen) <adStateOpen
Wend
Oct 16 '07 #2

P: n/a
Hi Lyle,

You have an interesting approach to handling this. Have you done
similar with Oracle or SAP?

Cheers

The Frog

Oct 17 '07 #3

P: n/a
On Oct 17, 4:57 am, The Frog <Mr.Frog.to....@googlemail.comwrote:
Hi Lyle,

You have an interesting approach to handling this. Have you done
similar with Oracle or SAP?

Cheers

The Frog
No, sorry.

Oct 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.