Prev: Access crashes when importing dbf file
Next: From a Form subtract issue from bound QtyOnHand in a new record
From: Torchwood on 19 Mar 2010 13:04
Hello,

We have just converted an Access 97 db to Access 2007 and now no one can
open the db in either 97 (.mdb) or 2007 (.accdb) Unfirntunately we do not
have any Access guru to trouble shoot this. Any ideas on where to find help.

One thing I did notice is that when the 97 db was first opened in 2007 the
Database Enhancement Dialog box never appeared.

Thanks for any help you can supply!!
From: Paul Shapiro on 19 Mar 2010 16:31
"Torchwood" <Torchwood(a)discussions.microsoft.com> wrote in message
news:E4D2C9CC-72C6-4FFA-8E00-6F725424A9FF(a)microsoft.com...
> Hello,
>
> We have just converted an Access 97 db to Access 2007 and now no one can
> open the db in either 97 (.mdb) or 2007 (.accdb) Unfortunately we do not
> have any Access guru to trouble shoot this. Any ideas on where to find
> help.
>
> One thing I did notice is that when the 97 db was first opened in 2007 the
> Database Enhancement Dialog box never appeared.

Hopefully you have a clean backup of your original Access 97 db. If not,
make a few copies of what you have now, and if you have any older backups
with the forms, reports, code, etc., make some copies of those too.
IMPORTANT: Do all further work on a copy of your db, and keep the best
original version you have somewhere it can't be touched. I'd copy it to a
thumb drive or something else that can be removed from the computer.

What happens when you try to open the db in Access 2007? Is there an error
message, does it lock up, etc? When you went from Access 97 to 2007 did you
also change computers? If so, what OS was the original computer and what OS
is the new one?

Try holding down the Shift key while you open the db, which disables any
startup forms. If the db opens, you can open the VBA editor and see if there
are any missing references. Within the VBA editor, dropdown the Tools menu
and choose the References item.

You can also check the Access options to see if you have specified the
folder containing your db as a trusted location. You can do this by opening
Access, without opening your db. Within the Access Options dialog, choose
Trust Center in the left pane. Then click the Trust Center Settings button.
In the Trust Center dialog, choose Trusted Locations in the left pane. Make
sure the folder containing your db is listed in the trusted locations in the
right pane.

You may want to consider having a consultant look at your db if this doesn't
help and no one there knows anything about Access.

 | 
Pages: 1
Prev: Access crashes when importing dbf file
Next: From a Form subtract issue from bound QtyOnHand in a new record