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.
"TS Lim" wrote:
> 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
>
>
> "Daniel Pineault" wrote:
>
> > 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/ac...865661033.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" wrote:
> >
> > > 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.
> > > --
> > > TS Lim
Similar Threads
