freightguy
Registered User.
- Local time
- Yesterday, 20:26
- Joined
- Mar 1, 2016
- Messages
- 36
Hi everyone, I've been using this MS Access program for the last 16+ years and decided to convert it to Access 2013. After using it for several months I decided to split the database and distribute the front end. Problem: It works well if only one person has the program opened. If a second front end is opened they get an error 2105 "You can't go to specified record".I can't tell if the problem is with the CLIENT settings or my recordset code which has worked all these years as single user.
My CLIENT settings are as follows:
Hope someone can point me in the right direction
Here's the code I have for my form:
thank you
My CLIENT settings are as follows:
- Open Mode - SHARED
- Record Locking - EDITED RECORD
- Open Databases by using record-level locking - UNCHECKED
Hope someone can point me in the right direction
Here's the code I have for my form:
Private Sub Form_AfterInsert()
Records.MoveLast
TotalRecords = Records.RecordCount
End Sub
Private Sub Form_BeforeInsert(Cancel As Integer)
Me![RecNum].Caption = TotalRecords + 1 & " pending ......"
End Sub
Private Sub Form_Current()
If Not Me.NewRecord Then
Records.Bookmark = Me.Bookmark
Me![RecNum].Caption = "Record " & Records.AbsolutePosition + 1 & " of " & TotalRecords
Else
Me![RecNum].Caption = "New Record"
End If
End Sub
Private Sub Form_Load()
Set Records = Me.RecordsetClone
Records.AddNew
TotalRecords = Records.RecordCount
DoCmd.GoToRecord , , acLast
End Sub
thank you
Last edited: