Using MDE files in a multi-user environment (Access2003)

You would need Access on the server and have an mdb in a shared folder
(security issues with this method). Or SQL Server would be better.

"Malcolm Wilson" wrote:

I have successfully created several ‘single user’ applications as MDE files
to run on systems without Access installed. However I have several users who
want to use them over their networks in a multi-user environment, is it
possible to install an MDE file, containing the tables, on a server (as a
‘back end’), and install the forms and code etc, as an MDE ‘front end’ on the
various client computers on a network. Again I am assuming Access is not
installed on the server or the clients.
Malcolm W.

confumbled wrote:
You would need Access on the server and have an mdb in a shared folder
(security issues with this method). Or SQL Server would be better.

Sorry, but this is incorrect. When a split Access app is using Jet (mdb file)
to hold its data then the only place Access needs to be installed is on the
client PC. The server is "serving a file", nothing more.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com