By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,507 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Compact the access-DB

P: n/a
Hello,

I have Access 2000 database.

For some reasons, sometimes I add records to the DB and sometimes I delete
records.
When deleting records, I see that the "DB" keep the space on the db,
and suppose it was 100M, it is not reduced after deleting records.

How can I compact the access-DB (after deleting the record).
This I need by some sql statement,
because I want that the user will have some options to compact the DB in
external program (i.e VB 6).

Thanks :)
May 31 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
....
The compress could be automatic, or manually,
but with no need to open the access environment
(should be manually-external or automatic).

Thanks :)
May 31 '06 #2

P: n/a

Ayon kay Eitan M:
...
The compress could be automatic, or manually,
but with no need to open the access environment
(should be manually-external or automatic).

Thanks :)


have a look at this site.
http://visualbasic.ittoolbox.com/doc...ual-basic-2903

May 31 '06 #3

P: n/a
Where is JRO ?

Thanks :)
May 31 '06 #4

P: n/a
Found.
Microsof Jet and replication ...

Seems a great example, just what I need for VB 6.0

I'll try it.

Thanks :)
May 31 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.