JCJG
asked on
Access 2007: How to incorporate Compact & Repair DB in a macro?
Hi, I have macro that execute a series of queries (make-table and append queries). The queries are straightforward with no criteria. When I execute the macro I received the following error message. However, the macro works after I compact and repair the database.
First, do you know what triggers the error message? Second, I'd like to incorporate compact and repair in the first step of my macro. How do I do that? Thanks.
Error Message:
"You cannot record your changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum).
First, do you know what triggers the error message? Second, I'd like to incorporate compact and repair in the first step of my macro. How do I do that? Thanks.
Error Message:
"You cannot record your changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.