how to .mbd able to accept mupltiple users and concurrent ..

External Since: Jun 22, 2006 Posts: 140

I created an Access database but i need to be able to have multiple peeps
getting into it at the same time and adding tasks. How do I set it up that
way. Right now the only way that anyone else can do it is if i exit out of
it and then they can get into it on their computer.

External Since: Oct 07, 2003 Posts: 10796

What permissions do you and all of the users have on the folder where the
database exists? You all need at least Read and Write on the folder (and
should probably have Delete as well).

As well, make sure your application is split into a front-end (containing
the queries, forms, reports, macros and modules), linked to back-end
(containing the tables and relationships). Only the back-end should be on
the server. Each user should have his/her own copy of the front-end,
preferably on his/her hard drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Michelle" <Michelle.RemoveThis@discussions.microsoft.com> wrote in message
news:35F728CD-3104-4F0F-BC0C-6C27AEF7255F@microsoft.com...
>I created an Access database but i need to be able to have multiple peeps
> getting into it at the same time and adding tasks. How do I set it up
> that
> way. Right now the only way that anyone else can do it is if i exit out
> of
> it and then they can get into it on their computer.