A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old November 21st, 2005, 05:40 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Using MDE files in a multi-user environment (Access2003)

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.


First off an MDE cannot be run without Access installed. What making an MDE
does is lock down all code based objects so their design can neither be viewed
nor altered. It does not create a stand-alone executable.

Otherwise what you are proposing is fine. The file with the tables need not be
an MDE since an MDE does nothing to tables and queries.


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


  #2  
Old November 21st, 2005, 07:22 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Using MDE files in a multi-user environment (Access2003)

Thanks for all the answers.
I am sorry I have not made myself totally clear on this.
I want to create a multi-user distributable Access run-time application,
(the MDE file type was incidental). I have done this successfully for single
users, and have also created multi-user solutions on networks with Access
running on all the client PCs, but I really want to be able to supply a
backend server with front-ends on the clients, with neither the server or the
clients running full Access. Is this possible?
I have Access 2003 Developer Extensions
Hope this explains matters a little better
--
Malcolm W.


"Rick Brandt" wrote:

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.


First off an MDE cannot be run without Access installed. What making an MDE
does is lock down all code based objects so their design can neither be viewed
nor altered. It does not create a stand-alone executable.

Otherwise what you are proposing is fine. The file with the tables need not be
an MDE since an MDE does nothing to tables and queries.


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



  #3  
Old November 21st, 2005, 07:49 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Using MDE files in a multi-user environment (Access2003)

Malcolm Wilson wrote:
Thanks for all the answers.
I am sorry I have not made myself totally clear on this.
I want to create a multi-user distributable Access run-time
application, (the MDE file type was incidental). I have done this
successfully for single users, and have also created multi-user
solutions on networks with Access running on all the client PCs, but
I really want to be able to supply a backend server with front-ends
on the clients, with neither the server or the clients running full
Access. Is this possible?
I have Access 2003 Developer Extensions
Hope this explains matters a little better


Again; a multi-user split app can have the back end sitting on any network
resource that all users have access to. That box is only serving the file. It
is in fact the equivalent of a shared remote hard drive. There will never be a
requirement that the server box have Access installed on it.

When you install a runtime app on a PC you ARE installing Access. The only
difference is hundreds of registry entries that prohibit using the Access
executable to create new files as you can in the licensed version. Once
installed a multi-user runtime app with a shared back end operates in exactly
the same manner as if all users had full-blown Access installed.


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


  #4  
Old November 21st, 2005, 08:02 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Using MDE files in a multi-user environment (Access2003)

Thanks Rick - thats a lot clearer now!
--
Malcolm W.


"Rick Brandt" wrote:

Malcolm Wilson wrote:
Thanks for all the answers.
I am sorry I have not made myself totally clear on this.
I want to create a multi-user distributable Access run-time
application, (the MDE file type was incidental). I have done this
successfully for single users, and have also created multi-user
solutions on networks with Access running on all the client PCs, but
I really want to be able to supply a backend server with front-ends
on the clients, with neither the server or the clients running full
Access. Is this possible?
I have Access 2003 Developer Extensions
Hope this explains matters a little better


Again; a multi-user split app can have the back end sitting on any network
resource that all users have access to. That box is only serving the file. It
is in fact the equivalent of a shared remote hard drive. There will never be a
requirement that the server box have Access installed on it.

When you install a runtime app on a PC you ARE installing Access. The only
difference is hundreds of registry entries that prohibit using the Access
executable to create new files as you can in the licensed version. Once
installed a multi-user runtime app with a shared back end operates in exactly
the same manner as if all users had full-blown Access installed.


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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Copy Database, Limit form to 1 user Sharon Using Forms 3 September 12th, 2005 03:44 PM
Can excel files be opened in fixed screen size preset by user? vabraham General Discussion 1 August 28th, 2005 03:08 PM
Columns and layout problems Phil Setting Up & Running Reports 4 August 18th, 2004 01:34 PM
Environment Variables for user last name Paul Installation & Setup 1 July 13th, 2004 12:24 AM
Office XP Ed Lester Setup, Installing & Configuration 1 May 27th, 2004 09:30 AM


All times are GMT +1. The time now is 09:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.