Multiple users

[Guest]

Is it possible to set up an Access database for multiple users. I have not
had a chance to split a database and give different users there own front
end, so is it possible for more than one user access the file on the network

 

[doug]

Yep.

 

[John Gray]

If you mean put the unsplit database on the network, then *don't*.
You are pretty much guaranteed a corrupted database (you do
have a backup scheme in place, don't you?).

If you mean split the database, and put the backend on the
network, then yes, certainly.

See Albert Kallal's pages for explanation, and how to split:
http://www.members.shaw.ca/AlbertKallal


John

 

[Dirk Goldgar]

Is it possible to set up an Access database for multiple users. I
have not had a chance to split a database and give different users
there own front end, so is it possible for more than one user access
the file on the network

You can do it, but it's a bad idea. Such an arrangement is prone to
corruption and user lockouts.

 

[Pieter Wijnen]

'97 handled it pretty good (2 a level I admit)
Pieter

 

[Smartin]

'97 handled it pretty good (2 a level I admit)
Pieter

I dunno... we have a pseudo A97 FE/BE at work. The record data is in a
shared BE, but the FE is also shared, and the combo boxes get their
values from tables in the shared FE. About 8 of us use this all day long.

We had frequent problems with record locking, I suspect because someone
would start to create a record, get distracted and leave their
workstation for hours with an uncommitted record sitting on the screen.
I jammed some code in the FE to automatically save the record when
certain fields were tabbed through. This has helped quite a bit with the
locking issue, but it still happens.

 

[Dirk Goldgar]

"Pieter Wijnen"
<it.isi.llegal.to.send.unsollicited.mail.wijnen.nospam.please@online.rep
lace.with.norway>
wrote in message news:%[email protected]

'97 handled it pretty good (2 a level I admit)

True, 97 was much better than the subsequent versions in this regard.
That's because the monolithic VB project was introduced with 2000,
forcing a lot more to be sent over the network with every save.