Results 1 to 3 of 3

Thread: OpenDatabase not working in Access 2000

  1. Oct 3rd, 2003, 04:00 AM #1
    Nucleus
    Nucleus is offline

    Thread Starter
    Registered User Nucleus's Avatar
    Join Date
    Apr 2001
    Location
    So that's what you are up to ;)
    Posts
    2,530

    OpenDatabase not working in Access 2000

    Ok well the problem is that the following code used to work for an Access 97 database, but it doesn't want to work for me now that I have moved to Access 2000.

    Set db = wrkJet.OpenDatabase(Me.TxtPath, True, False)

    The error message that I get is unrecognised database format. I can open the db manually without a problem. Anyone come across this before?
    Reply With Quote Reply With Quote
  2. Oct 4th, 2003, 11:26 PM #2
    WorkHorse
    WorkHorse is offline
    Fanatic Member WorkHorse's Avatar
    Join Date
    Jul 2002
    Location
    Where you live.
    Posts
    591
    Using DAO? You have to change the refernce from the DAO 3.5 library to DAO 3.6. I believe same goes for ADO. Just upgrade the reference to the newer library
    Reply With Quote Reply With Quote
  3. Oct 19th, 2003, 10:12 PM #3
    Nucleus
    Nucleus is offline

    Thread Starter
    Registered User Nucleus's Avatar
    Join Date
    Apr 2001
    Location
    So that's what you are up to ;)
    Posts
    2,530
    Ta WH, that was it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width