Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

Runtime Error 3219 - Invalid Operation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rena - 06 Nov 2006 22:22 GMT
I have an Access 2002 database that was converted from Access 97. It appeared
to be operating okay until I split the database (front-end and back-end). Now
I am getting a runtime error message 3219 Invalid Operation.  When I run the
debug, it points to a module that was converted from 97 to 2002.

The error pointed to the second set statement:
  Set Adult_Information_Input =
ICMS95.OpenRecordset("Adult_Information_Input", dbOpenTable) 'Replaced by
OfficeConverter 8.1.3 on line 29 ' original =     Set Adult_Information_Input
= ICMS95.OpenRecordset("Adult_Information_Input", DB_OPEN_TABLE)

Thank you in advance for any help or suggestions.

Below is the module in its entirety:

Private Sub Member_ID_Exit(Cancel As Integer)

' Checks if index key Member ID exists and if yes, displays message box.
' It will not allow user to enter a duplicate key.

  Dim ICMS95 As DAO.Database 'Replaced by OfficeConverter 8.1.3 on line 25
' original =     Dim ICMS95 As Database
  Dim Adult_Information_Input As DAO.Recordset 'Replaced by OfficeConverter
8.1.3 on line 26 ' original =     Dim Adult_Information_Input As Recordset

   
  Set ICMS95 = CurrentDb() 'Replaced by OfficeConverter 8.1.3 on line 28 '
original =     Set ICMS95 = DBEngine.Workspaces(0).Databases(0)
  Set Adult_Information_Input =
ICMS95.OpenRecordset("Adult_Information_Input", dbOpenTable) 'Replaced by
OfficeConverter 8.1.3 on line 29 ' original =     Set Adult_Information_Input
= ICMS95.OpenRecordset("Adult_Information_Input", DB_OPEN_TABLE)
 
   
   Adult_Information_Input.Index = "Member ID"
   Adult_Information_Input.Seek "=", Forms![Adult Member MIF]![Member ID]
   If Adult_Information_Input.NoMatch Then
       Adult_Information_Input.Close
   Else
       MsgBox "This is a DUPLICATE QUEST number."
   End If

End Sub
Crazyhorse - 06 Nov 2006 22:29 GMT
In the Debug Window. First Stop the Module. Go to Tools > References > Make
sure that the Microsoft DAO 3.6 Object Library is added.

> I have an Access 2002 database that was converted from Access 97. It appeared
> to be operating okay until I split the database (front-end and back-end). Now
[quoted text clipped - 39 lines]
>
> End Sub
Douglas J. Steele - 06 Nov 2006 22:31 GMT
You can't use dbOpenTable with linked tables. Either drop that parameter, or
replace it with dbOpenDynaset.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have an Access 2002 database that was converted from Access 97. It
>appeared
[quoted text clipped - 43 lines]
>
> End Sub
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.