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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |