Input of new rows in a table

[Gary]

I have created a table with an autoincremented key. The
table contains about 10,000 rows. I have created an
unbound form. Using this form I need to be able to input,
update and delete records in my table. I will be using a
recordset to do this, by displaying the field values on
the form. My Access application will be multiuser and the
Access tables will be on a server. The question I have
is: If I open a recordset (Dynaset) with the source being
my table, so I can use the .AddNew method to add new
rows, based on the values entered on the form, does
access return all 10,000 rows from the server to the
local users machine? If it does, how can I enter new rows
into the table using a recordset without returning all
these rows to the local users machine? I realize I could
also use the table as the datasource for the form, but
would this also return all rows to the user's local
machine? Thanks.

 

[Allen Browne]

Simplest solution would be a bound form with its Data Entry property set to
Yes.

If you have a reason to use a recordset, open it for append only:
Set rs = db.OpenRecordset("MyTable", dbOpenDynaset, dbAppendOnly)

 

[Allen Browne]

Will dbAppendOnly give an empty recordset that I can use to add new rows

to, and then use to insert new records in my table? Thanks

Give it a try.

Open the recordset, and examine its RecordCount.