multiple users with access

  • Thread starter Thread starter salmonella
  • Start date Start date
S

salmonella

I think I am missing something simple,

I would like to put a single copy of an access program on a network drive
where multiple users can use it. This way if I need to update the program
then I can just change the one copy. However, when I tried this the program
locked itself and would not let someone else open it after the first user.

Is there a way to set up an access program on a network drive such that
multiple users can use it at the same time on their own PCs?
 
I think I am missing something simple,

I would like to put a single copy of an access program on a network drive
where multiple users can use it. This way if I need to update the program
then I can just change the one copy. However, when I tried this the program
locked itself and would not let someone else open it after the first user..

Is there a way to set up an access program on a network drive such that
multiple users can use it at the same time on their own PCs?
Click to expand...

You should split your database into 2 files. A frontend with your
forms, reports, queries, etc and a backend with your tables. Link the
tables into the frontend. Put the backend on the shared network
location and send a copy of the frontend to each of your users. Yes,
it is more difficult to do updates and fixes, but this is the optimal
method for utilizing Access in a network environment.

Keven Denen
 
You will need to split your database to Front end/Back end format. This
means that the data (all of your tables as a .mdb file) will exist on your
server and each workstation will have a copy of the front end .mdb (queries,
forms, reports, etc).

Under Tools - Database Splitter you can step through the wizard to split
your database. There are plenty of articles on this subject. I have
included one link.

http://www.fmsinc.com/MicrosoftAccess/DatabaseSplitter/Index.html

Jackie
 
It is split, etc. however i don't want a copy on each computer. I want one
copy on a network drive so that to update the FE I don't have to switch it
out on 100 computers
have you ever done this?

then problem i have is that once the first person accesses the FE on the
network drive, it locks other out.

any ideas?
 
It is split, etc. however i don't want a copy on each computer. I want one
copy on a network drive so that to update the FE I don't have to switch it
out on 100 computers
have you ever done this?

then problem i have is that once the first person accesses the FE on the
network drive, it locks other out.

any ideas?






- Show quoted text -
Click to expand...

I understand your lack of interest in sending out the front end to all
your users, but this is the solution. Check Ken's post on options for
updating your frontends.

Keven Denen
 
it is split, working etc with the FE on each computer. However, i really need
to know if it is possible to have multiple users access one copy of the FE on
a network drive- is this even possible?

thanks,
 
it is split, working etc with the FE on each computer. However, i really need
to know if it is possible to have multiple users access one copy of the FE on
a network drive- is this even possible?
Click to expand...

Unfortunately it *is* possible... just.

It's a guaranteed route to bad performance, contention between users,
inability to do any design changes if anyone else is logged on, rapid bloating
of the size of the database, and very high risk of corruption.

If those costs are acceptable... well, they aren't for me!
 
Back
Top