Multi User Setup

[Bryan Brassell]

I have a database I wish to have updated (via a form) by
multiple users on a lan. My book tells me I must set up
a .MDW file and to split the database, but little more tha
I understand.

I wish to simply place the database in a network folder
and have multiple users (who all have access 2K installed)
open a form and update it. Can someone give me a step-by
step?

Do I need the .mdw file for this? Do I set that up and do
the split on my local drive and then move to the network
folder, or move to the network first?

Thanks,

Bryan Brassell

 

[Joan Wild]

You do not need to set up a separate mdw file. The workgroup file is used
to authenticate users when you wish to secure an Access mdb. You do not
have to secure your database in order for multiple users to access it.

Access always uses a workgroup (mdw) file. By default, it uses the
system.mdw that is installed with Access. Every time access is started it
uses this workgroup file and silently logs you in as a user named 'Admin'.

To setup your database for multiuser, split the database. There is a wizard
in the Tools menu you can use. It will prompt you for a location for the
backend (this will contain just the tables/relationships) - choose a
location on your server that all users have access to.

Then you can copy the frontend to each user's workstation. The frontend is
linked to the tables in the backend.

 

[TC]

This sounds like a programming error in the form's code module. It does not
sound like anything to do with multiple users or split databases.

Get the person who wrote the code, to check & debug it?

HTH,
TC

 

[Joan Wild]

Do you mean you are getting this error when attempting to run the database
splitter wizard?

If so, you can split it without the wizard.

Copy your database, and put the copy on the server (give it a different
name). Open the server copy and delete all objects *except* the tables,
then compact it. Open the frontend (the original database on your
workstation), and delete the tables and relationships. Then go to File, Get
External Data, Link Tables, and navigate to the backend on the server and
link all the tables. Then compact it. Then all you need to do is copy the
frontend to each workstation.

 

[TC]

Well, you need to scatter some msgbox's throughout your code, to see which
line(s) are causing the error(s). Then post those lines, & errors.

TC