#Delete Mark in Bound Memo filed

[TS Lim]

I have form that has bound memo field, sometime, no sure how it happen, the
memo filed is filled with #Delete. My application is a stand alone program.
Kindly advise what can cause this and how to avoid it from happening.

 

[Daniel Pineault]

When was the last time you performed a compact and repair?
Is you db split? Does each user have their own copy of the front-end?

Please checkout
http://www.granite.ab.ca/access/corruptmdbs.htm
http://www.granite.ab.ca/access/corruption/symptoms.htm
http://office.microsoft.com/en-ca/access/HA011865661033.aspx - No very
helpful but directly from MS if you wanted their perspective on the matter.
But do look over the links at the bottom they may be of help.

Before doing, make yourself a backup copy of your database!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[TS Lim]

Mr Daniel,

My db is split. The backend data is linked only to one front end database.
No compact and repair was done. Will compact and repair solve the problem ?

The front end is a accdr file while the backend is accdb file. Can I put up
a sub procedure in the froint end to run the compact and repair for the
split db ?

Thank you for your advise

 

[TS Lim]

Dear Daniel,

I'm writing a program for my user to do the repair and compact of the backend.

I found two vba comands from the help file:
1. expression.CompactRepair(SourceFile, DestinationFile, LogFile)
2. expression.CompactDatabase(SrcName, DstName, DstLocale, Options, password)

It seem that I can only use No 2. because my backend is password protected.
My quesiton is: it command No 2 doing only compact and not repair, or it
perform the same as No 1, doing both compact and repair.

Thank you.

Regards.