Form using append query ERROR

[scharp1n2]

Let me start by saying I am very novice at Access 2003. I have created a
database that is using forms based on queries that append to tables. For a
lack of a better way to explain it. Anyway my problem - it can append becaue
my table "is already opened exclusively by another user, or it is already
open through the user interface and cannot be manipulated programmatically."
I am the only one the office with this database (work in progress) so anyway
how can I get past this error.
Sorry for the lack of knowledge - any help would be greatly appreciated.
Thanks in advance.

 

[Allen Browne]

I think you are saying you created unbound forms (i.e. the form's
RecordSource property is blank), and you command buttons to fetch and write
records to and from your tables?

If so, I strongly suggest you experiment with bound forms. Just set the
form's RecordSource to the name of the table (or query), and then set the
Control Source of your controls to the relevant fields. This opens up the
real power of Access, as it fires events for you to manipulate (e.g.
Form_BeforeUpdate for record validation.)

The particular error you describe suggests that there is some unclosed
process that is preventing you from completing what you are attempting to
do. Perhaps you even have a bound form, and are also attempting to execute
SQL statements on the same data. Or perhaps you have opened a recordset
without closing it and setting it to Nothing. Or, it could be several other
issues.