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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Katie B - 19 Oct 2004 20:15 GMT

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?

Reply to this Message

Douglas J. Steele - 19 Oct 2004 21:51 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

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

Reply to this Message

Amos Sobel - 16 Jan 2005 08:01 GMT

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

> Access won't allow you to link to another database using ODBC.
>
> > 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?

Reply to this Message

Douglas J. Steele - 16 Jan 2005 12:08 GMT

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?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Is there ant way around it?
>
[quoted text clipped - 17 lines]
>> > other
>> > drivers. Am I missing something?

Reply to this Message

Amos Sobel - 18 Jan 2005 12:23 GMT

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

> 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
[quoted text clipped - 24 lines]
> >> > other
> >> > drivers. Am I missing something?

Reply to this Message