Member Avatar for vbmade2000

Hello All


I have problem in database management in vb6 using access database.

I have created small code library to store code snippets.

When i add new code to database then size of database is increased.This is normal.

But whenever i remove some code from my database then size of database is not decreased.Whay this problem occurs.If this situation will stay for long time then the time will come when the size of my access database will me very large.

So pls help me in this problem .

I m 18 years old beginner vb6 programmer from India.

You can also mail me personally at : vbmade2000@gmail.com

  • 3 Contributors
  • 2 Replies
  • 68 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by maheshsayani
Member Avatar for Comatose

Hmn, are you emptying the record (setting all the fields to "") or are you actually calling the ADO's delete method?

Member Avatar for maheshsayani

Hi
I Think your access database is not in compact mode if not goto options menu and check on
compact on close option
This may solve your problem

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.