Random Database Generation

[Sharkbyte]

I have created a split db. The front-end resides on the user's desktop, with
the backend on a server share.

What we are seeing, at least on 1 machine (though I have been told it occurs
on others), is the generation of copies of the front-end db. These copies
are labeled Db1, Db2, Db3, etc.

The db is 2000, and runs a Compact/Repair on close.

Has anyone seen this before? I checked the archives, and couldn't find
anything.

Thanks, in advance.

Sharkbyte

 

[Jerry Whittle]

Yes. It's Compact on Close and your users aren't letting it finish. Do
yourself a big favor and turn off Compact on Close on all the user machines.
If it's a FE, you shouldn't need it anyway as tables are in the BE. There
might be a little bloat on the FE but don't worry about it.

 

[Tony Toews]

Yes. It's Compact on Close and your users aren't letting it finish.

Or it may be failing due to another case such as possibly permissions
errors.

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