Access locking up

[Bill Pugh]

Hi:

I have a form command button that runs a make table query and then brings up a report in print preview that is populated from the table. If I forget to close the report window and click the command button again Access will bring up a Halt window and then display.

The database engine could not lock table 'mytable' because it is already in use by another person or process.

When you click OK Access will lockup and the only function that will work is the good old X.

Any ideas?

Thanks in advance

 

[Tekime]

Apparently Access is trying to lock the new table that is being generated but the open report is using it.

Will opening two of these reports at the same time be a requirement of the project?

Maybe you should share the code being used to generate the table.

 

[Bill Pugh]

Apparently Access is trying to lock the new table that is being generated but the open report is using it.

Will opening two of these reports at the same time be a requirement of the project?

Maybe you should share the code being used to generate the table.

How do you share the code to fix this locking up problem?

Thanks