DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: Some old VB6 software of mine will no longer open MDB database  (Read 6,027 times)

kyrathaba

  • N.A.N.Y. Organizer
  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 3,200
    • Participated in NANY Challenge Eight Times
    • Programming School - Deluxe Bonus Medal
    • Programming School - Stage 1 Medal
    • Coding Snacks
    • Military Service Badge - US Army
    • Writer
Back in 2003 I wrote a VB6 app that opened a database in MDB format.  It was a homemade project that showed a few generations of my family tree in a hierarchical treeview -- the info (pictures, birthdates, histories, etc.) all pulled from the MDB database.

Trouble is, now the program won't open the database.  I get a 5031 error message: Jet database unable to open database.  make sure it is not exclusive or already opened by another program.

I have the whole project on a CD (not with me at this moment, but I can provide it if it would be helpful).  But, anyone have any idea why it won't open the database anymore?  I reinstalled VB6, thinking that might help, but no dice.
Win 10 Pro running on a 3.2 GHz CPU and 12 Gb RAM
__________________________________________

Proofreading Service: http://williammillerservices.com/proofreading

kyrathaba

  • N.A.N.Y. Organizer
  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 3,200
    • Participated in NANY Challenge Eight Times
    • Programming School - Deluxe Bonus Medal
    • Programming School - Stage 1 Medal
    • Coding Snacks
    • Military Service Badge - US Army
    • Writer
Re: Some old VB6 software of mine will no longer open MDB database
« Reply #1 on: February 19, 2009, 01:20 AM »
Weirdly, the problem seems to have been solved by copying the archived project into the newly installed VB6's "Projects" folder.  Go figure.
Win 10 Pro running on a 3.2 GHz CPU and 12 Gb RAM
__________________________________________

Proofreading Service: http://williammillerservices.com/proofreading

Veign

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 993
    • Gathering Badge
    • Participated in NANY Challenge Twice
Re: Some old VB6 software of mine will no longer open MDB database
« Reply #2 on: February 19, 2009, 01:33 AM »
Its because the database on the CD can't have its lock file created.  This is why moving it to a writable folder solved the issue.

kyrathaba

  • N.A.N.Y. Organizer
  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 3,200
    • Participated in NANY Challenge Eight Times
    • Programming School - Deluxe Bonus Medal
    • Programming School - Stage 1 Medal
    • Coding Snacks
    • Military Service Badge - US Army
    • Writer
Re: Some old VB6 software of mine will no longer open MDB database
« Reply #3 on: February 19, 2009, 01:59 AM »
Geesh.  I am astounded at my own denseness.  Makes me wonder how I ever manage to do any programming at all!

Thanks, Veign!
Win 10 Pro running on a 3.2 GHz CPU and 12 Gb RAM
__________________________________________

Proofreading Service: http://williammillerservices.com/proofreading

Original address: https://www.donationcoder.com/forum/index.php?topic=17100.0