Running Access 2000 from corporate shared drive

[HoneyBee]

I have an Access Data base that requires multi-site access from a shared drive. Users are required to add, edit and query data. I have been told by my internal Help Desk that Microsoft do not support Access 2000 across shared drives as there is a risk of corruption. Can anyone confirm / reject this statement?? Can anyone suggest any alternatives that I could use?

 

[LittleSmudge]

We I regularly do it.

Back End data store on the shared drive.
Front End interface on local C: drives.
Some users on the end of 56k modem dial up lines or ISDN lines.

I have even had a set up with a single central database where multiple users opened the same access .mdb file across a distributed network.

If the size gets too large you'll have to consider network bandwidth issues.
A FrontEnd form bound to a large BackEnd table will take up a lot of bandwidth bacause the entire table will be transfered down the wire as the form opens. To combat this you'll need to consider ADO interfacing rather than binding - or even running replication version of the BackEnd at the remote sites and then synchronisation on a preplanned schedule.


'ope-that-'elps.

G LS