Multiple Users adding records 1

[dbero]

I am intending to have a backend database updated with new records by individual databases for each user. I am using the abbreviated code below to add a new record.

Is there a more efficient way to add records and prevent two users from being on the same record than using the select * statement? I know I could use a where statement, but thought there may be an even better way to prevent any chance of error.

Addtransaction.Open "Select * from TaskTable", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Addtransaction.AddNew
Addtransaction!User_ID = SystemID
etc.
etc.

Thank you

 

[lupins46]

Why can't you just use a ordinary append query?

 

[dbero]

Don't know how. I've used an append query from a query, but never from a form. Could you explain?

 

[lupins46]

I think you are going to have to describe again what you are trying to do.

The way I read your Q i thought you were entering data to a local table and then wanted to to transfer that data to a different database.

 

[dbero]

No, I'm not transfering data between tables.
In this case, a user has a form open. They click a cmd button which gathers values from fields on the form. After the values are gathered, I am opening a linked recordset and adding a new record with the values. Thus creating a new record with the gathered values.
Thanks!

 

[lupins46]

So if users are entering data into an unbound form, your code is fine. Can two users be entering the same new record? If so, you need to add error handling to detect a duplicate record when you rs.update.

 

[SeeThru]

I cant remember how off the top of my head, but opening the table for additions only will speed entry....