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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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?
 
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
 
Back
Top