Prev: More efficient code for multiple If...End If statements
Next: Dlookup related records
From: Luciano on 31 May 2010 14:32
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?
From: ruralguy via AccessMonster.com on 31 May 2010 17:33
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.

Luciano wrote:
>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?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: More efficient code for multiple If...End If statements
Next: Dlookup related records