MS Access ODBC link to another Access database outside of my netwo

[Katie B]

I believe I've seen a method for linking to another Access database using
domain and port (not browsing on the network) on the Access driver
configuration. I can't seem to find it now. This can be done with other
drivers. Am I missing something?

 

[Douglas J. Steele]

Access won't allow you to link to another database using ODBC.

 

[Amos Sobel]

Is there ant way around it?

I have a large MSAccess project called FX using an MSSQL database called DB2
and connected via ODBC. I did create a modified database called DB20 on MSSQL
and did try to redirect FX to use DB20 by ODBC. ODBC does show it works
with DB20 but the FX continues to use DB2. There is also no way to rename
DB20 to DB2 in MSSQL so the only way is to delete DB2 and reuild it from
DB20. Is there a better way arround it?

Amos Sobel

 

[Douglas J. Steele]

Since this question has nothing to do with Katie's question, you really
should have posted it as a new question, rather than attaching it to her
question.

How did you "try to redirect FX"? Assuming you're using a DSN, do you have a
new DSN defined to point to DB20?

 

[Amos Sobel]

I did create a User DSN entry named DB2 which is pointing at a default
database DB20. My MSAccess project does not allow changing the database to
DB20 without destroying the relationships between the tables. Do you see
another way of doing it?

Amos