One application and work with different database!!

[Fekri]

Hi,

I need a good idea because I confused which way is easy and fast?

I have an application which have many linked tables to a database.
And also there is several office which they are using the same application and linked database.

Now, I need to control all their data in my application.
I want to have a one application which can easy and fast change my location of linked tables to another database with different location.

Thanks for any idea
Ali

 

[danvlas]

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

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Fekri]

Thanks Daniel,

I used this code but in case of connect to another file which have password this code make error:
"Not a Valid Password"

All the mdb files which I have to connect to them have a same password which to change the connection from one to another should not request the password!!

Thanks for any advise to solve the problem
ALi