By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Multi User System

P: 1
I have a program in MS-ACCESS but can run only on my system I want to make it to useful for my office all in all computers at lease 6 systems. I tried to get a shortcuts on their systems but cannot run, how I can approach ? can anybody give me detailed information on this?

maxpro
Feb 15 '07 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I have a program in MS-ACCESS but can run only on my system I want to make it to useful for my office all in all computers at lease 6 systems. I tried to get a shortcuts on their systems but cannot run, how I can approach ? can anybody give me detailed information on this?

maxpro
Normally with a multi user database you would separate out the data tables into a separate database. This is known as the backend. This would sit on a network somewhere that is accessible to all the users. The frontend of the database would just have links to these tables. You can now copy the frontend to all the users.

Mary
Feb 15 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
You could even have the Front-end on the network then only one copy would be required.
Feb 15 '07 #3

MitchR
P: 63
I would also make sure that before deploying your front end that you make sure your record locks are set to none
Feb 16 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
I would also make sure that before deploying your front end that you make sure your record locks are set to none
No not None. Set to Edited record, otherwise you risk corrupt data.

Mary
Feb 16 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
I would also make sure that before deploying your front end that you make sure your record locks are set to none
I think you may need to consider before doing that. Setting the locking correctly can be complicated but turning it off in a mult-user environment may not be the best approach.
Feb 16 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.