A
Abay
Hello ... I have a new job and all of the procedures are performed through
Access 2007 Databases. Each pc has access installed locally and the files
are in shared folders on a server. The problem I am finding is that we keep
getting a conflict message when more than one person wants to update a data
base .. doesn't matter what table(s) are being accessed.
My guess (uneducated) is that Access is not installed properly for the
ability to share data without conflicts. I have been reading up on sharing
an Access database on Microsoft's site. I seems that the best way to share
would be to have a database server installed.
To share data do we need to lock/unlock records or tables in our vba code?
We are a small organization with about 40 people using Access. Any help/
information on this situation would be most appreciated.
Abay
Access 2007 Databases. Each pc has access installed locally and the files
are in shared folders on a server. The problem I am finding is that we keep
getting a conflict message when more than one person wants to update a data
base .. doesn't matter what table(s) are being accessed.
My guess (uneducated) is that Access is not installed properly for the
ability to share data without conflicts. I have been reading up on sharing
an Access database on Microsoft's site. I seems that the best way to share
would be to have a database server installed.
To share data do we need to lock/unlock records or tables in our vba code?
We are a small organization with about 40 people using Access. Any help/
information on this situation would be most appreciated.
Abay