J
John
Hi everyone,
I encountered some problems and confusions while following the step by step
proccess using the "force a user out" to incorporate into my Access XP
database.
Just to give a little light on how my database is designed: I don't have any
front end and back end options for the users. They simply share the database
thru a shared network drive (no splits yet).
There are 4 steps to follow to complete the process.
1. Place the table "tblUserPreferences" in your back end and link to it
from your front end.
Ok, I imported "tbleUserPreferences" table into my database. However, how
do I link it?? do I ignore it, since I don't have front end??
2. Part instructs to import the three forms: "frmDatabaseAdministration",
"frmForceUserOut" and "frmNotifyUser" into my front end.
I think I did this part fine by simply importing them.
3. In the On_Open Event of your Switchboard place the following Code.
Dim stDocName As String
stDocName = "frmNotifyUser"
DoCmd.OpenForm stDocName,,,,, acHidden
Here again I got stuck. I have a switchboard, and I click the design button
to click the on_open event. I did select the [Event Procedure] and clicked
the ... build button to type the above code. I don't know where and if I
should type all exactly the same as it appears??
After this I should be able to make this run correct? Can you please also
tell me how I can test it on a shared network?? Thank you for your time.
John
I encountered some problems and confusions while following the step by step
proccess using the "force a user out" to incorporate into my Access XP
database.
Just to give a little light on how my database is designed: I don't have any
front end and back end options for the users. They simply share the database
thru a shared network drive (no splits yet).
There are 4 steps to follow to complete the process.
1. Place the table "tblUserPreferences" in your back end and link to it
from your front end.
Ok, I imported "tbleUserPreferences" table into my database. However, how
do I link it?? do I ignore it, since I don't have front end??
2. Part instructs to import the three forms: "frmDatabaseAdministration",
"frmForceUserOut" and "frmNotifyUser" into my front end.
I think I did this part fine by simply importing them.
3. In the On_Open Event of your Switchboard place the following Code.
Dim stDocName As String
stDocName = "frmNotifyUser"
DoCmd.OpenForm stDocName,,,,, acHidden
Here again I got stuck. I have a switchboard, and I click the design button
to click the on_open event. I did select the [Event Procedure] and clicked
the ... build button to type the above code. I don't know where and if I
should type all exactly the same as it appears??
After this I should be able to make this run correct? Can you please also
tell me how I can test it on a shared network?? Thank you for your time.
John