I ran into problems in an app in which I received a msg of "cannot lock the
table, it is in use by another user".  It turns out that I had opened a
recordset with a command like set rstmyrecs = openrecordset("Tablename") to
get a record count and I was trying to run a query to ...

Hello.  For the following, I would appreciate if anyone could tell me:
if it can be done, how it might done, and/or what search terms I could
use to find the solution myself.
I would like to create a database in which _adding a new record

I've got a situation where I am developing an Access 97 app for a client,
and am in the "beta testing" stage.
I have split the app up, using the DB splitter, into front-end  /back-end
for the usual reason ... so I can mess with form/report revisions. Since

Hello Listland,
I am new to Microsoft Access, although I am an experienced programmer.
Thanks in advance.  Please email your hints to gvsi@bigfoot.com
Please give me a recipe for how to achieve the following in Access 97.