RE: Move to next record causes application error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



It could be that the form is corrupt. Another possibility is that you have a
memo field in the table that's the record source for the form and it's data
is corrupt.

The operative word here is "corrupt". At times like this, nothing beats a
good backup. In fact make a complete backup of your database now and put it
away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"LeslieJ via AccessMonster.com" wrote:

Good morning,

I work in a database with another person. Unfortunately, when it was
originally created, it was not split into a front and back end. Now every
once in a while (this being one of those times) when I go into the database,
after the other person already has it open, and I try to go to the next
record in the database...the dialogue box that tells me Access has
encountered an error and the application must be closed immediately and do I
want to send my error to Microsoft and repair my database pops up. I can run
queries, reports, and open other forms within the same database - it's just
when I try to move to the next record in the main form!

Does anyone have any insight as to why this happens and how I might be able
to fix it?

Any help would be greatly appreciated!

--
Message posted via http://www.accessmonster.com


.



Relevant Pages

  • Re: Restore of DB Backup gave some errors
    ... With many messages I would recommend checking the entire database using: ... A column nullability inconsistency was detected in the ... The index may be corrupt. ... Run DBCC CHECKTABLE to verify consistency. ...
    (microsoft.public.sqlserver.programming)
  • Re: Form does no longer bind to table
    ... The symptoms you describe indicate that the form has become corrupt, ... Then compact the database to get completely rid of this stuff. ... > I'm only using VBA code and no macros. ... > The form does not bind without filter either. ...
    (microsoft.public.access.forms)
  • Re: There isnt enough memory? -- cannot open form
    ... When you tried the SaveAsText where were you? ... Try this - close the database then reopen it and open the VB Editor. ... > I've now tried "decompile" with no success. ... >> and keep a backup of the corrupt database. ...
    (microsoft.public.access.forms)
  • Re: Cant save form as..error msg
    ... It's a common way to recover a corrupt form or database to copy the code out ... compile it empty and then paste it back in and re-compile. ... Of course it could be that the database is corrupt or mis-compiled. ...
    (microsoft.public.access.forms)
  • RE: File Lock Sharing Violation
    ... programs are on a 20 Gig C:drive on the same 800mz machine. ... Data in an Access Database because of a total Computer Hard Drive Crash. ... This is why I like Access 2000 and Windows 2000 Pro. ... With a table you might get corrupt data or corrupt indexes. ...
    (microsoft.public.access.tablesdbdesign)