Upgrading to Access 2007

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

Hi,

have you tried to save the new converted database in a new folder and a new
name?
--
Kind regards
Noëlla


"Scott" wrote:

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

I tried this, with the same result...

"Noëlla Gabriël" wrote:

Hi,

have you tried to save the new converted database in a new folder and a new
name?
--
Kind regards
Noëlla


"Scott" wrote:

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

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

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


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

That worked! Thanks!

"Tom van Stiphout" wrote:

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

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


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