ODBC Linking to Mutiple ODBC Datases

[Dart4861]

I created an Access mde that has a logon routine which re-creates ODBC links
to five different databases depending on the database chosen. The routine
works when I have one user running the mde however when multiple users start
running and logging on to different databases they don't always get the data
for the database they are logged into. When they first log in they get the
correct data but a couple minutes later they may get data from a diifferent
database.

It appears I am going to have to create five different versions of the mde
each linked to a specific database. If there is a better approach so I don't
have to maintain five databases, please advise.

 

[Douglas J. Steele]

It sounds as though your users are all sharing the same mde. Each user
should have his/her own copy.