List Box causing "The database engine could not lock table..."

[kspabo]

I've added a list box to my form that displays a table. This table is completely independent and gains it's data from an Append query. There is also a Delete query, which clears the table for a new set of data, and an Alter query which resets an AutoNumber column in the table (so that new data sets always start numbered at 1).



Here's the problem: Since I've added the listbox and set the RowSource to the table, whenever I run the Append query I receive the error: "The database engine could not lock table 'tblLineSheet' because it is already in use by another person or process." I've made sure to close the table, but to no avail I still get this error. Without the List Box I don't encounter this error.

[orange]

It might be easier for readers if you would give a 3-4 line desceiption of what exactly you are trying to accomplish in plain English.
We know nothing of your database nor business problem. Without some context readers can only guess at what you are doing/expecting.

As a start it seems you are mis-using the autonumber. It also seems you are using the same table for the Forms recordSource and the listbox's Rowsource????

For clarity:

Data is stored in tables.
Forms act like a window on to the data stored in the table. You can rearrange, format, ignore the data (stored in a table) that you choose to associate with a form.

[kspabo]

Sorry about the lack of clarity, I'll try to do a better job of identifying what my goal is.

I'm trying to create a form that has buttons that: 1. Adds a row of data to a table 2. Resets the autonumber column and deletes all the data on that table 3. Exports this table to a .csv
These 3 buttons reside on this form, with a combobox that selects the data I want to be recorded to the table, and a list box which displays the data I've recorded to this table. The reason I want the AutoNumber column to be reset is because each set of data needs to be numbered, starting at 1 always.