MS Access Multiuser - share the access database on the network

Author

share the access database on the network

2005-04-06, 8:06 pm

Hi,

I created an access program on a network drive. I don't know if it can be
shared by 20 users on the network at the same time without splitting it into
FE/BE, I like to make this as simple as it can.
I tried 2 users, it seems to work. But I like to confirm this.

Thanks in advance,
Sarah

Douglas J. Steele

2005-04-06, 8:06 pm

Go to the trouble of splitting it. You won't regret it!

Having multiple people opening the same database significantly increases the
risk of corruption.

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

"SG" <sguo@coopervision.ca> wrote in message
news:uRN7xKLMFHA.2420@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I created an access program on a network drive. I don't know if it can be
> shared by 20 users on the network at the same time without splitting it
> into FE/BE, I like to make this as simple as it can.
> I tried 2 users, it seems to work. But I like to confirm this.
>
> Thanks in advance,
> Sarah
>
>
>

Tony Toews

2005-04-06, 8:06 pm

"SG" <sguo@coopervision.ca> wrote:

>I created an access program on a network drive. I don't know if it can be
>shared by 20 users on the network at the same time without splitting it into
>FE/BE, I like to make this as simple as it can.
>I tried 2 users, it seems to work. But I like to confirm this.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

2005-04-06, 8:06 pm

Appreciate both Douglas and Tony's response. I guess I have to split our
database. Just don't quite follow update the data from FE instead of BE, I
will read some notes and if I have a question I will come back to you.

Thanks,
Sarah
"SG" <sguo@coopervision.ca> wrote in message
news:uRN7xKLMFHA.2420@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I created an access program on a network drive. I don't know if it can be
> shared by 20 users on the network at the same time without splitting it
> into FE/BE, I like to make this as simple as it can.
> I tried 2 users, it seems to work. But I like to confirm this.
>
> Thanks in advance,
> Sarah
>
>
>

Klatuu

2005-04-06, 8:06 pm

There should be no data in the front end and nothing but data in the back
end. Use the database splitter to do the split, and it will do exactly this.
If your mdb is xyz.mdb, it will create xyz_be.mdb.

Put xyz_be.mdb on the server and a copy of xyz.mdb on each user's computer.
DO NOT RUN THE FRONT END FROM A SERVER AND DO NOT ALLOW USERS TO SHARE A
FRONT END.

There are some other issues regarding record locking, but they are too
involved to go into here.

"SG" wrote:

> Appreciate both Douglas and Tony's response. I guess I have to split our
> database. Just don't quite follow update the data from FE instead of BE, I
> will read some notes and if I have a question I will come back to you.
>
> Thanks,
> Sarah
> "SG" <sguo@coopervision.ca> wrote in message
> news:uRN7xKLMFHA.2420@TK2MSFTNGP12.phx.gbl...
>
>
>

Rod @ CLA

2005-04-21, 8:25 pm

SG,

There is a simple way to distribute an updated MDE after you split the DB.
We use a simple batch file:
(everyone gets a mapped drive to Q: where the FE and BE are)
********************

if not exist " %userprofile%\paperf
low" md " %userprofile%\paperf
low"
q:
copy /b /y CLAlocal.mds " %userprofile%\paperf
low"
c:
cd " %userprofile%\paperf
low"
del clalocal.ldb
start CLALocal.mde
exit
********************
*

This way when we make updates to the FE, it gets automatically distributed
to the user the next time they launch the app.

Rod

"SG" wrote:

> Appreciate both Douglas and Tony's response. I guess I have to split our
> database. Just don't quite follow update the data from FE instead of BE, I
> will read some notes and if I have a question I will come back to you.
>
> Thanks,
> Sarah
> "SG" <sguo@coopervision.ca> wrote in message
> news:uRN7xKLMFHA.2420@TK2MSFTNGP12.phx.gbl...
>
>
>

Sponsored Links