D
dkhtx
Problem: When a user opens my Frontend.mdb, but is not joined to the
workgroup, the splashscreen opens, and the database hangs. An .idb file is
created for both the Frontend.mdb and the linked Backend.mdb. The user is
forced to use CTRL-ALT-DEL and End Program, which leaves the .idb files
intact - meaning I can no longer open either one exclusively to edit them.
Setup: Office XP. ACCESS 2002. Multiuser environment. Security workgroup for
both frontend and backend.
Question: How do I programmatically block users who are not joined to the
workgroup from getting far enough into the database opening sequence to cause
the creation of the record-locking file? Or how do I identify that the user
attempting to open the database is not joined to the workgroup (in the code
of the startup form or module) so that I can force them back out gracefully?
Thanks
workgroup, the splashscreen opens, and the database hangs. An .idb file is
created for both the Frontend.mdb and the linked Backend.mdb. The user is
forced to use CTRL-ALT-DEL and End Program, which leaves the .idb files
intact - meaning I can no longer open either one exclusively to edit them.
Setup: Office XP. ACCESS 2002. Multiuser environment. Security workgroup for
both frontend and backend.
Question: How do I programmatically block users who are not joined to the
workgroup from getting far enough into the database opening sequence to cause
the creation of the record-locking file? Or how do I identify that the user
attempting to open the database is not joined to the workgroup (in the code
of the startup form or module) so that I can force them back out gracefully?
Thanks