I have a set of tables that are linked to a SQL backend. These tables and their underlying structure stay the same for all companies.

I found some code that will, based on what the user selects from the database combobox, refresh those linked tables.

Here is my question. Say person A logs into the MDE and chooses company 1234. The login works and the tables are refreshed.

Person B logs in, while person A is in, and they log into the company 45678. Will the tables keep their appropriate links for both users? Or will the MDE only keep the most current users DSN path and overwrite User A's table links.

If it only logs the most recent user, how to people get around this?

The code was from Microsofts website. http://support.microsoft.com/default.aspx?...kb;EN-US;159691

I should also add that the database MDE consists of 1 file that everyone has a shortcut to. There is no local copy stored on their computer, everyone uses the same file.

Thanks
David

I don't think using only one copy of the MDE front end is a great idea and workable when the back end will be different for each user.
What is the reason for having only one copy for all users?

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)

All the users log into a server (Terminal Server). It isn't an option to have a localized copy on each workstation mapped to a network drive (speed issue). Unless there is another creative way of doing this? It has been working like a charm for over a year now without any issues, I am just looking for a way to incorporate the other companies into using this database wihtout mapping a bunch of unnessary tables.

I have to admit that I have not done this before but I doubt it when it comes to different databases for concurrent users.
What about moving to OLE DB provide and ADO? Then you don't need to do the network mapping.
Compare the work you have to revise your project to ADO with what you have to make copies one for each database source.
Or someone may have a better idea that needs less input than mine.

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)