Problem converting a VB6 program to use an Access 2000 db instead of an Access 97 db

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I've an old VB6 program design to use a Access 97 database. We've
recently decided to convert the program so it would use an Access 2000
database instead.

So I converted our database to the access 2000 format, changed the
connection string, ... and of course it didn't work.

It looks like part of the program works, but it crashes when we try to
read data from a record set. Were getting this error:

Run-time error '3704'
Operation is not allowed when the object is closed.

Any ideas on what might be causing this?

.

Relevant Pages

  • Re: Runtime error message --- only one user
    ... Approximately 5-10 people access the database simultaneously, using the runtime version of Access, via a local front end that is linked to the back end on a server. ... Everything was working fine for about a month after deployment until this week, when one user started getting a runtime error anytime he would try to run a report from the database. ... "Execution of this application has stopped due to a run-time error. ... Is there any additional information I can provide that might give a clue as to what is causing it? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Run-time error 3045
    ... I have READ ONLY access to the database which the linked table is ... Count of the records I specify in the criteria parameter of the DCount ... Dim myCounter as integer ... better solution to solving Run-time error '3045'? ...
    (microsoft.public.access.formscoding)
  • Re: Run-time error 3045
    ... I have READ ONLY access to the database which the linked table is linked ... machine, and when the line of code that uses the DCount function executes, I ... Dim myCounter as integer ... better solution to solving Run-time error '3045'? ...
    (microsoft.public.access.formscoding)
  • Re: Reset Page Numer & Total Page Count for each Report Group
    ... Dim GrpPages As DAO.Recordset ... I get 'Run-time error 13. ... database, which worked perfectly. ... Private Sub GroupHeader0_Format ...
    (microsoft.public.access.reports)
  • Re: Error drving me insane
    ... Run-time error '-2147467259 ... The database has been placed in a state by user 'Admin' on machine 'XXXXX' ... reason as for your message? ...
    (comp.databases.ms-access)