473,326 Members | 2,680 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Multiuser application

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
4 2001
hyperpau
184 Expert 100+
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
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
Lysander
344 Expert 100+
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
184 Expert 100+
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

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

Similar topics

4
by: Pablo | last post by:
At my current job I've been tasked with maintaining a very old C++ application written largely in ANSI c++ in what I believe to be with an old DOS based Borland compiler. I'm trying to add a...
0
by: Durai | last post by:
Hello All, How to test the "Multiuser testing" in PostgreSQL?. I used the apache bench "ab" tool for this one. The following command execute the "test.php" 50 times concurrently. $ ab -c 1...
2
by: marifusman | last post by:
Acees 2.0 application when user run application it give following error. The database is opened by user "Admin" on machine "abc". you can not open this database exclusively. Please help me...
1
by: r.raj | last post by:
I have a database application with Jet Engine accessing msaccess,though in a machine.How can I make multiuser out of minimum effort. try giving some tips and tricks.
0
by: s | last post by:
I need to develop a multiuser database application to be used by four people(The number of users are not likely to increase). It is for storing records of different versions of particular papers. I...
2
by: =?Utf-8?B?VmFuZXNzYQ==?= | last post by:
Hi! I started working with .NET and I have some doubts about how to work with multiuser database. I am using VS2008 with MySQL through ODBC for Windows Form. 1. Is it correct to create a...
6
by: lukethegooner | last post by:
I would appreciate any comment. I want MS Access to act as a reporting tool accessing Oracle tables. The Oracle database is populated by another database application, but this application...
6
by: annamalainagarajan | last post by:
Hi Genius, vanakam i developed a application with msaccess as a backend and vb6 as a frontend tool, it can work in a stand alone machine. now i want to convert as multiuser application, at...
0
by: raamay | last post by:
I am new to VB.Net but since i have a good experience in VB6(having developed 2 to 3 desktop applications), i find no problem coping with the new environment at this stage. Well, i am planning to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.