Database closes it self

N

nicole

I have a problem.
In two cases the access database is closing completely (but leaves the .ldb
file behind.).
I just added a new form and now when I switch from the design view to the
preview via the icon button it closes the whole database. It does not always
happen, but repeatingly. The second occasion is when I am in the Viasual
Basic code and want to save something and compile it, then it is closely
itself completely, too.
I check my code, there is no closing command for once in a procedure or
function in the specific form. And after it does not close ony that form but
the whole database - could it be a bug? Or what did I make wrong or forgot
to consider.
If anybody can help me, I would really appreciate it.
 
T

Tom Collins\(Home\)

You may have a corrupted database. The easiest solutions are first to
try to compact/repair the database under tools on the menu.
If that doesn't work, create a new blank database. Then do an import
of all your tables, forms, reports... from the old database.

Once you have it working again, I suggest you look into splitting the
database. This will greatly reduce any corruption in the future. Do a
search on the internet for examples.

Tom Collins


| I have a problem.
| In two cases the access database is closing completely (but leaves
the .ldb
| file behind.).
| I just added a new form and now when I switch from the design view
to the
| preview via the icon button it closes the whole database. It does
not always
| happen, but repeatingly. The second occasion is when I am in the
Viasual
| Basic code and want to save something and compile it, then it is
closely
| itself completely, too.
| I check my code, there is no closing command for once in a procedure
or
| function in the specific form. And after it does not close ony that
form but
| the whole database - could it be a bug? Or what did I make wrong or
forgot
| to consider.
| If anybody can help me, I would really appreciate it.
|
|
 
Top