Form Locking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

It would be great help if you advise me that how can I check on Form load OR
activiate event that from is not using by someone else??

I just need one user one time - thanks for help in advance
 
If you're worried about a form already being in use, that implies that
you're sharing the database.

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). Only the back-end should be on the server: each
user should have his/her own copy of the front-end, preferably on his/her
hard drive.

With that setup, no one else can possibly be using the form.
 
Thanks for reply

Actually I am using history server on SQL having 20 mil records as a back
end using Passthrough queries and also creat some temp tables on Access for
report writing finally I am using logical locking (which is working)- thanks
for help and reply

AA
 
Thanks for reply

Actually I am using history server on SQL having 20 mil records as a back
end using Passthrough queries and also creat some temp tables on Access for
report writing finally I creat table to control logical locking (which is
working)- thanks for help and reply

AA
 
Back
Top