Re: Network
From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 05/27/04
- Next message: Cheryl Fischer: "Re: Network"
- Previous message: FJ: "Network"
- In reply to: FJ: "Network"
- Next in thread: Cheryl Fischer: "Re: Network"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 May 2004 08:24:00 -0500
"FJ" <anonymous@discussions.microsoft.com> wrote in message
news:0345EF0A-E266-4FFC-86CD-C40D6319CDEE@microsoft.com...
> I'm new to access but I pick up things fast. We currently have
individual PC's and the only way we transfer or update our database on each
machine is to copy and upload. Needless to say we are looking to go to a
network. I was planning to load the database on to the server and have
every one ACCESS the database that way ( excuse the pun). I was told
however that access does not allow multiple users to access the same info
at the same time or allow records to be added or update while someone else
is using the database. Is this true.
>
> P.S.
> I am not a programer so if there is a way to do this I would appreciate a
layman's response.
That is not true. Access is multi-user capable "right out of the box".
However; it is not *recommended* to have multiple users in the same
application file simultaneously as it can often lead to file corruption
problems.
The "best practice" is to split the application into a data file (tables
only) and a front end file (everything else) that has links to the tables
in the data file. With this setup you put the data file on a network share
and give each user their own separate local copy of the front end file.
Access 97 did a much better job of handling the "everyone using the same
monolithic file" scenario than newer versions so if you have a small number
of users and more reading than writing going on you might get away with
just putting the file on a server and having everyone use it, but I would
not recommend that if the data is mission critical and I would certainly
make sure you are making frequent backups.
-- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
- Next message: Cheryl Fischer: "Re: Network"
- Previous message: FJ: "Network"
- In reply to: FJ: "Network"
- Next in thread: Cheryl Fischer: "Re: Network"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
