Access 
Author Message
 Access
Hi,
I created a table in an Access DB to keep track of data and pictures.
When I insert pictures in the table the file size increases which is normal.
But when I delete the pictures or even if I delete the table the file size
does  not decresses.
How can I fix this?

Thanks.



Tue, 06 Nov 2001 03:00:00 GMT
 Access

Rob,

You must compact the MDB to get the space back.

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.

Regards,

Klaus H. Probst, MCP

       ICQ: 22454937
      The VB Box: http://members.xoom.com/kprobst/
~~~~~~~~~~~~~~~~~~~~~~~~~~~

Quote:
> Hi,
> I created a table in an Access DB to keep track of data and pictures.
> When I insert pictures in the table the file size increases which is
normal.
> But when I delete the pictures or even if I delete the table the file size
> does  not decresses.
> How can I fix this?

> Thanks.




Tue, 06 Nov 2001 03:00:00 GMT
 Access

Can I compact the MSD from VB6? How?

Thanks.



Tue, 06 Nov 2001 03:00:00 GMT
 Access
Find the DAO CompactDatabase method in the VB help file.

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.

Regards,

Klaus H. Probst, MCP

       ICQ: 22454937
      The VB Box: http://members.xoom.com/kprobst/
~~~~~~~~~~~~~~~~~~~~~~~~~~~

Quote:

> Can I compact the MSD from VB6? How?

> Thanks.




Tue, 06 Nov 2001 03:00:00 GMT
 Access
If you are using ado you should use the JetEngine.compactdatabase object
(dont forguet the reference!)

Klaus H. Probst escribi en mensaje

Quote:
>Find the DAO CompactDatabase method in the VB help file.

>~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Please post/reply to the newsgroup(s) so
>that everyone can benefit from the discussion.

>Regards,

>Klaus H. Probst, MCP

>       ICQ: 22454937
>      The VB Box: http://members.xoom.com/kprobst/
>~~~~~~~~~~~~~~~~~~~~~~~~~~~


>> Can I compact the MSD from VB6? How?

>> Thanks.




Mon, 12 Nov 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Access to access 2000 mdb by access 97 program via VB6 and ADO

2. Pasar consultas a proyectos access / Convert access queries to access projects

3. SQL data access by Access 97 and Access 2000

4. DrWatson when jdbc access - Access violation (access to address 0x00005)

5. Access 97 upgrade to Access 2000 or Access 2002

6. Access accessing a Remote Server

7. Error trying to access sqlserver from ms access

8. Accessing a Stored Procedure from an Access Module

9. access to SqlServer 7.0 from Access 97

10. Accessing SQL-Server via Access 7

11. Access DTS Error with Access Replication

12. JDBC Beta Program for multi database data access ( CONNX Access all your enterprise data using JDBC)


 
Powered by phpBB® Forum Software