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

Multiuser application

P: 64
Hi Everyone!!

Need your help.

I have created a ms access database with tables and forms in it. It is a single .mdb file.

Now I want to make it to be used by multiple users. means 10 people can open same form at the same time and do the data entry. What steps do i need to follow to make it multiuser application.

Please help.

Thanks,
Yogesh
Jun 12 '07 #1
Share this Question
Share on Google+
4 Replies

hyperpau
Expert 100+
P: 184
Hi Everyone!!

Need your help.

I have created a ms access database with tables and forms in it. It is a single .mdb file.

Now I want to make it to be used by multiple users. means 10 people can open same form at the same time and do the data entry. What steps do i need to follow to make it multiuser application.

Please help.

Thanks,
Yogesh
You must have a network for the computers that users would be used.

Then paste the database you created on the shared network folder.
That means all users from different computers open this database
from the same location (folder). So changes made on both computers are saved
on the same file.
Jun 13 '07 #2

P: 64
You must have a network for the computers that users would be used.

Then paste the database you created on the shared network folder.
That means all users from different computers open this database
from the same location (folder). So changes made on both computers are saved
on the same file.
Thanks for your inputs!!

I need to create a client server application where the user has a front end and a common database is stored in a shared drive.

Could please tell me what are the steps to create a client server application

Thanks,
Yogesh
Jun 13 '07 #3

Expert 100+
P: 344
Thanks for your inputs!!

I need to create a client server application where the user has a front end and a common database is stored in a shared drive.

Could please tell me what are the steps to create a client server application

Thanks,
Yogesh
You need a mapped drive and folder on the server, that is the same on every PC. For example, I use Z:\Bissau

Assuming your database is called mydb.mdb, copy it onto the server and rename it mydbdata.mdb. Put another copy on the server, call it mydbcode.mdb. Now on mydbdata and delete all querys, forms, reports, macros and modules, i.e. just leave the tables.

Now go into mydbcode and delete all the tables. Then go into the File menu option, Import, and select Link Tables. You are presented with a browse button, select mydbdata and select all tables.

You now have a code db that you can copy onto each of your pcs, which links to the data db on the server. Each PC must map to Z:\bissau (or your own folder and drive)

The code db can go anywhere, but the data db must stay in the drive and folder you used to link it with, on all PCs

oh yes, I forgot, take a backup before you start this, just in case
Jun 13 '07 #4

hyperpau
Expert 100+
P: 184
You need a mapped drive and folder on the server, that is the same on every PC. For example, I use Z:\Bissau

Assuming your database is called mydb.mdb, copy it onto the server and rename it mydbdata.mdb. Put another copy on the server, call it mydbcode.mdb. Now on mydbdata and delete all querys, forms, reports, macros and modules, i.e. just leave the tables.

Now go into mydbcode and delete all the tables. Then go into the File menu option, Import, and select Link Tables. You are presented with a browse button, select mydbdata and select all tables.

You now have a code db that you can copy onto each of your pcs, which links to the data db on the server. Each PC must map to Z:\bissau (or your own folder and drive)

The code db can go anywhere, but the data db must stay in the drive and folder you used to link it with, on all PCs

oh yes, I forgot, take a backup before you start this, just in case
There's no better way to say it than how you did. :)
Jun 13 '07 #5

Post your reply

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