Error on close

[Tony Williams]

Every time I close my database (Access 2007) I get an error message to say
that Access has encountered an error and needs to send an error report. I've
compacted and repaired the database but it still happens. Anyone any ideas
where I can start looking for the error that's creating this?
Thanks
Tony

 

[Pete D.]

Try creating a simple database with a few items in it like table, form.
Open it and close it a few times. If it closes without the error you now
know it is your datafile. Next in your datafile with the error check and
see if before you close it all forms are closed and no code is running. Do
you have any objects running code that runs when it closes. Do you have
compact on close turned on, if so turn it off. Do you have Name Autocorrect
options turned on under access options current database? If so turn it off
and try again.

 

[Tony Williams]

Thanks Pete I'll try those.
Tony

Try creating a simple database with a few items in it like table, form.
Open it and close it a few times. If it closes without the error you now
know it is your datafile. Next in your datafile with the error check and
see if before you close it all forms are closed and no code is running.
Do you have any objects running code that runs when it closes. Do you
have compact on close turned on, if so turn it off. Do you have Name
Autocorrect options turned on under access options current database? If
so turn it off and try again.

 

[Tony Williams]

Tried all those things Pete but still the same. Also just opened it in
Access 2003 and then closed it with no problems. So there must be something
that Access 2007 doesn't like. the database was created originally in 2003.
Odd?
Thanks
Tony

 

[RoyVidar]

Every time I close my database (Access 2007) I get an error message
to say that Access has encountered an error and needs to send an
error report. I've compacted and repaired the database but it still
happens. Anyone any ideas where I can start looking for the error
that's creating this?
Thanks
Tony

I'm thinking some kind of corruption, which I also have !some fun
with using that version.

You might want to try the /decompiel switch. If you're unfamiliar
with it, follow the steps in the following link

http://www.granite.ab.ca/access/decompile.htm

note - between step 2 and 3, close Access again, and reopen the file
again - without running any code (holding Shift key).

If that doesn't work, then try the SaveAsText and LoadFromText methods
that you will probably find samples of through a search in some of
these groups.

 

[Tony Williams]

Thanks Roy that sounds a bit scary for a novice but I'll have a go.
Cheers
Tony

 

[Pete D.]

Do you have SR1 installed?

Tried all those things Pete but still the same. Also just opened it in
Access 2003 and then closed it with no problems. So there must be
something that Access 2007 doesn't like. the database was created
originally in 2003. Odd?
Thanks
Tony

 

[a a r o n . k e m p f]

wow dude, that sounds to me like Jet is screwing up your data.

I'd reccomend moving to SQL Server.
If Jet bluescreens once in a hundreds years; it's just not worth it.

Use a reliable database.

SQL Server is the worlds most popular database.
And you can still use the same forms and reports-- using Access Data
Projects.

-Aaron
MCITP: DBA SQL 2005

 

[Tony Toews [MVP]]

Thanks Roy that sounds a bit scary for a novice but I'll have a go.

So long as you make a copy of the FE first decompile is quite safe to
use.

Please ignore anything Aaron Kempf has to say as he is a monomaniacal
on various subjects which are usually utterly irrelevant to the
question or problem at hand.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Williams]

Thanks Tony

So long as you make a copy of the FE first decompile is quite safe to
use.

Please ignore anything Aaron Kempf has to say as he is a monomaniacal
on various subjects which are usually utterly irrelevant to the
question or problem at hand.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Williams]

yes updates are up-to-date
Cheers
Tony

Do you have SR1 installed?