What command condenses or compresses a data base file in Microsof.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What command condenses or compresses a data base file in Microsoft access?
 
thatgurl115 said:
What command condenses or compresses a data base file in Microsoft
access?
Click to expand...

If you want to compact the current database file manually, you can click
Tools -> Database Utilities -> Compact and Repair Database...

If you want to compact a different database, not the one currently open,
with VBA code, you can use the CompactDatabase method of the DBEngine
object. For that method, you must specify both the source database (the
one you want to compact) and the target database (the name of a new file
that the source database will be compacted into).
 
You must log in or register to reply here.

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

Similar Threads

Advantages and disadvantages of individual file based compression and inter-file compression 1
Data Base Size 1
condensing files 1
Data Base Size 3
Create a Condensed List from Imported Data 3
Using the Me.RecordSource Command 1
Excel Moving data from one line to another 0
Compress Database 6

Back
Top