My application Front-end and Attached Back-end are both on the server to be used by 25 users. My problem here is adding data through an unbound form takes about 35 seconds that used to be 10 seconds on a standalone PC (single user). I can still compromise with that but when it comes to deleting the data, it takes forever and Ctrl-Alt-Del to Endtask corrupts the db.
I am using
openrecordset("tablename" , db_open_dynaset)
and searching through the table for the particular record based on a key value provided through a small form and the button on the form executes the above code. How can I speed
the Addnew method I have used on adding records (35 secs) and on myset.delete (infinity) described above.