Access crashes

[Blobbles]

Hi all,

Just wondering if everyone elses MS Access crashes as often as mine. I am
running it on Vista Home Preminum, using an ADP in Access 2000 file format,
connecting to a SQL Server Express DB in the back end. I get a crash maybe
once every 2 hours on average... not exactly stable!

The things that seem to cause most of the problems are: Copying forms
(allows the copy but crashes when trying to create the new form), changing
the name of a form (probably a related error) and adding/changing/deleting
text boxes in a sub form.

I have installed the most recent service pack for vista which hasn't made
any difference and as far as I can tell all updates to Access have been
applied.

Does anyone else have the same problem or should I reinstall?

Thanks,

 

[Allen Browne]

There's a range of suggestions here:
http://allenbrowne.com/ser-25.html

Follow each one of them through, and it should help.

That page was not written from a SQL Server Express perspective, but the
problems you describe sound like they are happening in the front end, not
the back end.

 

[Tony Toews [MVP]]

I have installed the most recent service pack for vista which hasn't made
any difference and as far as I can tell all updates to Access have been
applied.

What version of Access? If A2003 then has SP3 been installed? If so
what about the Access 2003 SP3 hotfix - Description of the Access 2003
post-Service Pack 3 hotfix package: December 18,
2007.http://support.microsoft.com/kb/945674/en-us Unlike previous
hotfixes you can download this one right from that KB article.

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/