Access 2.0 Macro Problem

[norrisl1]

We are using Access 2.0 for collection of time input on the form used for resource timesheets (our software cannot be upgraded at this time, so we are stuck with 2.0).  Currently we are experiencing the error message "Data has changed; operation stopped" when the AutoExec macro runs.  The macro itself has not changed - we use it from week to week and it is the same as previous weeks.  Has anyone seen this error message before and, if so, does anyone know how to correct the problem?

 

[jimmythegeek]

What is in the AutoExec Macro? <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[norrisl1]

The action is &quot;OpenForm&quot;.<br>The form name is &quot;Timesheet&quot; which is the form the resources use to enter time.<br>The view is &quot;Form&quot;.<br>There is no filter name.<br>The Where Condition is [Forms]![Timesheet]![rindex]=0<br>The data mode is &quot;Edit&quot;.<br>The window mode is &quot;Normal&quot;.<br><br>I have checked older copies of the database and these arguments are identical in every copy of the database.&nbsp;&nbsp;We are unsure why we are getting error messages today.&nbsp;&nbsp;After I posted this message we later got an error message that said the database was corrupt.......

 

[Guest_imported]

Are you certain that another version of the program is not up and running?&nbsp;&nbsp;That particular error occurs mostly when two persons are trying to modify the same record.<br>

 

[norrisl1]

Actually we have about 100 users of the form who input their time concurrently.&nbsp;&nbsp;We usually do not have any problems with these users working with the form at the same time.&nbsp;&nbsp;Our database was built by an Access programmer who took this into consideration when the database was built.&nbsp;&nbsp;Are there any other reasons why this error may occur?&nbsp;&nbsp;If not, we may need to revisit the concurrent-user issue.