Upgrading to Access 2007

[Scott]

I'm trying to update my flight logbook database to Access 2007. However,
when I try, it says that the database is open by the Admin and can't be
updated until it is closed by the admin (or words to that effect).

All the help that I google says to erase the .ldb file, which is present
when the database is open. When the database is open, I can't delete the
file, because it is being used. When I close Access, the file disappears.

I've also tried to import to a blank Access 2007 database, but it flags a
missing procedure. (I'm trying to reaquaint myself with Access, since I
wrote these routines a few years ago...yikes) In any case, I was hoping to
update using the above mentioned method.

Any suggestions?

Thanks,
Scott

 

[Noëlla Gabriël]

Hi,

have you tried to save the new converted database in a new folder and a new
name?

 

[Scott]

I tried this, with the same result...

Hi,

have you tried to save the new converted database in a new folder and a new
name?

 

[Tom van Stiphout]

On Fri, 10 Apr 2009 23:29:01 -0700, Scott

Try this:
Open Access > Office Button, Open, and go find your file > Open it
WHILE HOLDING DOWN THE SHIFT KEY > Alt+F11 to open a code window >
Debug > Compile > Fix any errors.
Also Tools > References and resolve any broken references.

-Tom.
Microsoft Access MVP

 

[Scott]

That worked! Thanks!

On Fri, 10 Apr 2009 23:29:01 -0700, Scott

Try this:
Open Access > Office Button, Open, and go find your file > Open it
WHILE HOLDING DOWN THE SHIFT KEY > Alt+F11 to open a code window >
Debug > Compile > Fix any errors.
Also Tools > References and resolve any broken references.

-Tom.
Microsoft Access MVP