Locking/conflicting INSERT/VIEW

[Guest]

I have a back-end sitting on a web server. The web form does INSERTS to a
table in the back end. This works fine.
I also have a front end that links to the same table in the back-end (on the
web server). The front end has a view-only datasheet on the table. Whenever
this datasheet is open, all inserts to the table via the web form fail. If
the front end is open but not accessing the table, the inserts work fine. Is
there any way to set up the locking such that the table data can be viewed
and yet not prevent the inserts from working? Any ideas?

 

[Guest]

Hi

Try going to the Data tab on the form property sheet and set Record Locks to
No Locks.

You may also want to set the Records Set Type to Snapshot (which is read only)

Regards

Andy Hull