How to link table from code

[Domac]

Hi,

I need to link tables from code (autoexec macro that runs function)
depending of company department.
All departments use same database structure but from different location.

How to link tables from code???



Thanx

 

[Brendan Reynolds]

There is code to relink Access tables at the following URL ...

http://www.mvps.org/access/tables/tbl0009.htm

 

[Domac]

Thanx a lot!

 

[Guest]

Hi. I tried this sample code, but it only works to access tables.
I have the same problem with Oracle OBDC Tables.

How can I refresh this kind of linked tables from Oracle ODBC tables?

thanks

 

[Guest]

Hi. I tried this sample code, but it only works to access tables.
I have the same problem with Oracle OBDC Tables.

How can I refresh this kind of linked tables from Oracle ODBC tables?

thanks

 

[Brendan Reynolds]

It's the next one in the list, Nuno!

http://www.mvps.org/access/tables/tbl0010.htm

 

[Brendan Reynolds]

It's the next one in the list, Nuno!

http://www.mvps.org/access/tables/tbl0010.htm

 

[Guest]

You are right, however, i'm having some dificulties to put this code working.
I'm not sure witch part of the code should be in a module, or directly in a
object event.
can you help me?

I build the table tblReconnectODBC and I want now to test it in a click
event button.
How can I test it?

 

[Guest]

You are right, however, i'm having some dificulties to put this code working.
I'm not sure witch part of the code should be in a module, or directly in a
object event.
can you help me?

I build the table tblReconnectODBC and I want now to test it in a click
event button.
How can I test it?

 

[Brendan Reynolds]

I'm afraid I would not be the best person to assist you, Nuno, as I have
never used that code. Perhaps someone who has used it might like to join in
here?