Opening External Table

[the_utmost]

Hi:

I want to query a table on a network drive. The path, for instance would be S:\Common\Users\ARTest.mdb. I cannot change the CurrentDB since this is a read-only property. Do I need to link the tables to my current db or what?

 

[sfreeman@co.mer]

Linking should work.

 

[the_utmost]

Just About

I tried this and it threw an error:

Dim tdf As DAO.TableDef
Dim strPath As String

strPath = ";DATABASE=" & strfilepath

tdf.Connect = strPath
tdf.RefreshLink
What am I doing wrong?