Compact Backend Database

D

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.
 
G

Granny Spitz via AccessMonster.com

Dvanwig said:
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
 
D

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.
 
G

Granny Spitz via AccessMonster.com

Dvanwig said:
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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top