Question Database Error During "Save" After Edit

[shieriel]

Hello,
I don't understand why my database keeps showing an error everytime i tried to save my form. Previously i can save my forms without any trouble and then all of a sudden an error message keeps showing when i hit the save command on my project. Please see attached png files...



By the way, my database is located on a network drive. I don't know if this becomes a problem. And it was previously converted from access2000 to access2003.
Many thanks in advance..

 

[PNGBill]

Have you tried to save any other type of file to the same drive? maybe your have lost privileges to the network drive?

 

[shieriel]

Have you tried to save any other type of file to the same drive? maybe your have lost privileges to the network drive?

Yes Sir I can save anything on the drive, I can even create a backup files and other things.

 

[ghudson]

My bet is the db has some corruption somewhere. You mentioned it was recently converted. Try importing all of the db objects into a new 2003 database.

 

[shieriel]

My bet is the db has some corruption somewhere. You mentioned it was recently converted. Try importing all of the db objects into a new 2003 database.

Actually after converting to access2003 I can still use and edit without any troubles but only since yesterday that an error occured. Now i tried to create a new database then importing all data from my previous database. I just noticed that the error occurs only on the forms for inputting data. But all the other forms such as viewing summaries, etc. have no error. I tried to transfer the database on my local computer and remove from the network drive but still the error keeps occurring only when i edit and save the forms for data input. I just can't understand why and how is that happenned.

 

[PNGBill]

Have you tried opening a module and debugging.

This should pickup any error on your codes.

One of your vba codes may have become corrupt and you may find it is on or both of the forms you refer to.

 

[SOS]

If you have corruption in the data, that could explain why it is the input forms that have a problem.

 

[shieriel]

If you have corruption in the data, that could explain why it is the input forms that have a problem.

I tried to compile the codes but nothing happens. I also tried to transfer the database to other computer to make sure the access has no problem but still i cannot edit and save the forms for data entry

 

[SOS]

I tried to compile the codes but nothing happens. I also tried to transfer the database to other computer to make sure the access has no problem but still i cannot edit and save the forms for data entry

If the corruption is in the data, then compiling or decompiling won't help and neither will transferring the database.

You might go through this page here:

http://www.granite.ab.ca/access/corruption/symptoms.htm

and see if it helps at all.

 

[shieriel]

If the corruption is in the data, then compiling or decompiling won't help and neither will transferring the database.

You might go through this page here:

http://www.granite.ab.ca/access/corruption/symptoms.htm

and see if it helps at all.

Sorry but no help for me from that site.
I have no choice but to create new database so i can create new forms although it will give me another long hours for this database revision.
I just cannot understand why and how is that happening.
All my forms for data entry is giving an error.
I am still looking forward for the solution for this.
I am attaching some of the errors for my database, upon application crash access show up a dialog "Do you want to send information about the problem (windows error reporting)?" and 1 attachment that might help explain the problem is this xml. The error is all about "NTDLL.DLL"

xml>>>>:
http://www.access-programmers.co.uk/forums/#
- <ProblemSignatures>
<EventType>APPCRASH</EventType>

<Parameter0>MSACCESS.EXE</Parameter0>

<Parameter1>11.0.8166.0</Parameter1>

<Parameter2>46437912</Parameter2>

<Parameter3>ntdll.dll</Parameter3>

<Parameter4>6.1.7600.16559</Parameter4>

<Parameter5>4ba9b21e</Parameter5>

<Parameter6>c0000005</Parameter6>

<Parameter7>00051fbd</Parameter7>

</ProblemSignatures>