Compact in VBA

[Sardamil]

HI,

it's been a while since I last visited tek-tips, but when you don't know what to do, visit tek-tips.
I'm a tester and supervisor of software for a pension fund. To help make our life a little easier I started rebuilding a tool in access. I did it before, but after a few years without update, I felt it was better to start fresh and try to do a better job this time. As you may expect I ran into some problems. This is how it works so far. I unload tables (or parts of tables) from our mainframe and import these data in my database. This leads to the problems I would like to ask some help about.
* To prevent my database from getting to big, I'd like to compact and repair it every time I delete the old data and import the new data. Can that be done in vba? I already converted my macro to vba and would like to add this code.
* My other problem is with the relations. I can add the relations between all my major tables, but that leads to extremely slow loading and deleting. I was wondering if there is any trick to speed this up while still being able to add relations to my database.

Hopefully you can help me. You usually do.

 

[PHV]

Have a look here:

http://www.mvps.org/access/general/gen0041.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Sardamil]

Thanks, this may help. As I'm new to vba (not to access) I may need to find a good guide or website that answers my questions. Don't want to spam tek-tips with needless questions.
I did find another option on mvps.org though that may help as well. Compact on close should help a lot, but closing will take a while now.

Can you help me on my second problem as well?