Multiuser application

[ykhamitkar]

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

[hyperpau]

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.

[ykhamitkar]

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

[Lysander]

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

[hyperpau]

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. :)