acess form: how can I have more than 2 people modify it?

L

leona

someone told me about the bcm v2 - what is that? I've only found it for
outlook... it should make 5 people open and modify the form I've created in
Access, is this right?

I'd like to know how I can have a shared folder with an Access Form be used
by several people at the same time, not just one. Is this possible?

If someone could help me on this I'd greatly appreciate it.
 
K

Klatuu

Never heard of bcm v2, but the rest of your question is fairly common.
With an Access application you want to be available for multiple users, here
is the correct way to deploy it. First, let me say DO NOT SHARE ONE COPY
AMONG MULTIPE USERS. Sorry, just need to emphasis the point.

First, split your database. Use Tools, Database Utilities, Database
Splitter from the main menu. It will create another mdb that has the name of
your current mdb appended with _be.mdb. So if your app name is
CoolStuff.mdb, you will end up with two mdbs. CoolStuff.mdb will have all
the forms, reports, queries, and macros. CoolStuff_be.mdb will contain only
tables. CoolStuff.mdb will show the tables as Linked tables, that is tables
in another mdb.

Now, put the _be.mdb on the shared folder so users can share the data.

Once you have moved the backend (_be.mdb) and you open the front end, it
will throw an error if you try to open the table, because the _be.mdb is not
where it was when you split the database. You will need to go into Database
Utilities again and choose the Linked Table manager. Check the box that says
Always prompt for new location. That will cause it the ask for a new path
for each table. Next, you enter the path to the _be.mdb. Now, here is a
very helpful tip. Do not use drive letter paths:

M:\SomeFolder\CoolStuff_be.mdb

Instead, use UNC paths:
\\TheServerName\SomeFolder\CoolStuff_be.mdb

The reason is, you can't be sure that all users will be using the same drive
mapping to the shared folder.

The other things you need too set in the front end:

Under Tools, Options, Advanced tab
Set Defaultopen mode to Shared
Set Default record locking to No locks
check Open databases using record-level locking

That is pretty much it.
 
K

Klatuu

I forgot something. That is where to put the front end. Each user should
have their own copy on their own computer. It should NOT be on a network
folder.

This may seem a bit overkill, but deploying your app as I have described
will give the best performance and minimize network traffic.

Best of Luck
 
Top