Hi,
I have a design problem.
I have an application that uses VBA and ADO to connect an Excel front end to a JET back end. It's far from ideal, but it's the best solution I can come up with given the circumstances.
The back end consists of a number of permanent tables, but also 3 temporary tables that have all records deleted and repopulated daily.
This is bloating the back end. I'm compacting frequently, but I'd like to work around this issue.
I've thought about splitting the back end, but I need to run queries that involve both the permanent and temporary tables.
Any help would be appreciated.
I have a design problem.
I have an application that uses VBA and ADO to connect an Excel front end to a JET back end. It's far from ideal, but it's the best solution I can come up with given the circumstances.
The back end consists of a number of permanent tables, but also 3 temporary tables that have all records deleted and repopulated daily.
This is bloating the back end. I'm compacting frequently, but I'd like to work around this issue.
I've thought about splitting the back end, but I need to run queries that involve both the permanent and temporary tables.
Any help would be appreciated.