Hi,
I have a problem. I'm using VB6.0 and MS-Access as database. The project is based on work flow automation system. So, for each workflow chart I create a new Access database and give the name same as workflow name using different file extension then .mdb. My problem is, when I execute any process, the size of the database expands like anything. e.g. - if my original workflow database is of 60KB, it will turn into some 70-80 MB. because of this expansion, the performence of the system goes down like hell. Though I'm compacting the database before and after the process gets executed but I'm not able to do it during the process execution as I lose the record pointer which tells me about the current step and next step to be executed. Can any of my forum mate help me out of this problem.