Compact Backend Database

[Dvanwig]

I have a single-user Access 2000 database where the frontend user interface
is split from the backend database of tables. It's only a single user
program so record locking is not an issue. I set the program to compact and
repair on close but it does not seem to have any effect on the back end
database which grows a little with each use. Was wondering if someone could
provide the code that I could put in an "On Click" procedure for a button on
a form that would compact and repair the backend database.

 

[Granny Spitz via AccessMonster.com]

I have a single-user Access 2000 database where the frontend user interface
is split from the backend database of tables. It's only a single user
program so record locking is not an issue. I set the program to compact and
repair on close but it does not seem to have any effect on the back end
database which grows a little with each use. Was wondering if someone could
provide the code that I could put in an "On Click" procedure for a button on
a form that would compact and repair the backend database.

Hon, please don't multipost. Your question has already been answered. It
doesn't matter if it's a single user or multiuser database when the database
is split. The issues are the same, except you don't have to kick other users
out of a single user database. The recommended solution is here:
http://www.accessmonster.com/Uwe/Fo...vba/22554/Compacting-Backend-Access-Databases

 

[Dvanwig]

Greetings Granny...
Sorry about the double post. I checked for comments using a different
computer hooked up to a generic "MS Office" assistance web page and didn't
see my earlier post had taken effect in this group. Thanks for your response
though.

 

[Granny Spitz via AccessMonster.com]

Greetings Granny...
Sorry about the double post. I checked for comments using a different
computer hooked up to a generic "MS Office" assistance web page and didn't
see my earlier post had taken effect in this group. Thanks for your response
though.

You're welcome hon, and we forgive you. <g>