Help!

Multiple users accessing single database

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup/Configuration RSS
Next:  Love Taboo Forum Now Open to the Public! 5% Off -..  
Author Message
Sean
External


Since: Mar 22, 2006
Posts: 46



PostPosted: Mon Jul 30, 2007 4:12 pm    Post subject: Multiple users accessing single database
Archived from groups: microsoft>public>access>setupconfig (more info?)

I have about ten users who need to access a single Access 2k3 database at the
same time. Is this possible? if so, what needs to happen in order for it to
work?
Any help will be appriciated!

Sean
Back to top
Jerry Whittle
External


Since: Mar 03, 2006
Posts: 1278



PostPosted: Mon Jul 30, 2007 5:10 pm    Post subject: RE: Multiple users accessing single database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

First and foremost, the database needs to be split. There is a tool to do
this at Tools, Database Utilities, Database Splitter. It will put all the
tables in one mdb file called the Back End (BE) and the forms, reports,
queries, etc., in another mdb file called the Front End (FE).

Put the original database file out on a network folder where all users can
get to it. Do the splitting there. For this to work, all users need to have
the same drive mapping. For example if the BE is out on
P:\Databases\Database_BE.mdb, all users need to have the P drive mapped the
same way.

Ideally all user will have a copy of the FE on their PC. Failure to give
each user a copy can cause performance problems plus locking problems.

All users of the database must have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.

Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Sean" wrote:

> I have about ten users who need to access a single Access 2k3 database at the
> same time. Is this possible? if so, what needs to happen in order for it to
> work?
> Any help will be appriciated!
>
> Sean
Back to top
Stevesold



Joined: Aug 01, 2007
Posts: 13



PostPosted: Thu Aug 02, 2007 7:37 am    Post subject: Re: Multiple users accessing single database [Login to view extended thread Info.]

I have 5 users on my database. I have it running on a server. I didnt do anything else to it.
Back to top
sabariab



Joined: Apr 27, 2008
Posts: 1



PostPosted: Mon Apr 28, 2008 3:55 am    Post subject: Re: Multiple users accessing single database [Login to view extended thread Info.]

I have an Access database saved on a server and shared it to our group. The problem is only one user can open it at one time. That user has to close the Access database before other users can open it. Why is that?

But when It is saved on my computer and shared it, everybody can open and use it at the same time without any problem.

Why is it that when I put it on the server, it becomes single user while putting it on my computer it is multi user?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup/Configuration All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum