M
Mollytm
I have set up an Access 2002 FE/BE database for multiple remote users
mostly using runtime. I have a form that filters a record directly out
of a table, and when the form tries to save, if anyone else has the
form open, it says it can't save and shuts down the database. Would it
help to create a query that pulls the filtered record instead of
filtering for the record in code directly from the table? Is this
locking the table for other users, or could this be a connection
problem with the remote users? It doesn't give a specific error number
or anything, so i am trying to figure out what is going on- does
runtime give error numbers? This is the first time I have worked with
runtime.
mostly using runtime. I have a form that filters a record directly out
of a table, and when the form tries to save, if anyone else has the
form open, it says it can't save and shuts down the database. Would it
help to create a query that pulls the filtered record instead of
filtering for the record in code directly from the table? Is this
locking the table for other users, or could this be a connection
problem with the remote users? It doesn't give a specific error number
or anything, so i am trying to figure out what is going on- does
runtime give error numbers? This is the first time I have worked with
runtime.