Re: Bloody obvious question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

As long as they have at least Read, Write, eXecute and Delete permissions on
the folder where the MDB file exists, they shouldn't have any problem. This
is because Access creates a locking file (.LDB file) in that folder when the
first user accesses the database, updates it as subsequent users access the
database, and deletes it when the last user closes the database.

BTW, make sure you split the database into a front-end (containining the
queries, forms, reports, macros and modules), linked to a back-end
(containing just the tables). Only the back-end should be on the server:
each user should have his/her own copy of the front-end, preferably on their
hard drive. This will improve performance, and significantly reduce the risk
of database corruption.

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



"Michael Calwell" <fac@fac> wrote in message
news:436be054$0$346$da0feed9@xxxxxxxxxxxxxxxxx
> Hello,
>
> I'm new to access, coming from MySQL and more server orientated databases.
>
> Can somebody confirm that I can have an access database file sitting on a
> fileserver, and two different people on different computers can access
> that file at the same time and update the database without "File in use"
> errors?
>
> We are thinking of migrating our excel spreadsheets, and that's the
> primary driver.
>
> TIA
>
> Michael


.

Quantcast