Evening All
Apologies for the noobie question here, but I would like to know if an Access database (Office 365) can be accessed by multiple users simultaenously? I've written some code in VBA (AutoCAD) that opens an accdb file, records some data from a user (drawing issue information) then closes. Previously, this accdb file was stored in a shared dropbox folder, and although it works just fine for each user, becuase of the nature of syncing the file on each PC, occassionally we get 'conflicted copies' of the accdb file when multiple users access the file at the same time and it resyncs back to the central location then down to all other PC's.
I did code a lame error trap to check for the lock file (.laccdb) and stops the database being opened by somebody else when it's present, but again, because of the nature of Dropbox syncing up and down, this trap is not foolproof.
So now I'm working on keeping the database in a central cloud based location, so only one live copy in existance and no syncing. So, back to the beginning, can multiple user access and record data in the database at the same time?????
Thanks very much in advance for and and all input.
Graham