record Locking multi user

L

Luciano

Hi
I have a multi-user Access 2003/2007 database. In mono user mode everything
works fine, but in multi user mode there seems to be occasionally a Conflict
message giving the users to either Save Record, Copy to Clipboard or Drop
Changes.

I open my tables something like:

Public Function OpenTable(strTableName As String) As DAO.Recordset
On Error GoTo FoutOpenTable
Set ws = DBEngine.Workspaces(0)
Set db = DBEngine.Workspaces(0).Databases(0)
Set OpenTable = db.OpenRecordset(strTableName, dbOpenTable)
ExitFoutOpenTable:
Set db = Nothing
Exit Function
FoutOpenTable:
MsgBox "FoutOpenTable"
Resume ExitFoutOpenTable
End Function

Can sombody help me?
 
R

ruralguy via AccessMonster.com

Depending on the type of system, there could always be write conflicts but
you can miminize these conflicts by using queries of tables rather that the
tables directly.
 
Top