How to verify database connection in MS Access using Immediate Window

[makeitwork09]

I have MS Access 2002 SP3.

In Excel I can use

?sheet1.QueryTables(1).Connection

to get the information I want.

Is there something similiar for MS Access?

Thanks in advance.

 

[makeitwork09]

I finally found something on the web:

?ConnectionProject.Connection:

 

[PHV]

You meant CurrentProject.Connection don't you ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[makeitwork09]

Yes I did. Thank you