CptPicard
asked on
Disable Database Window?
Hi,
Is there any-way to disable the database window from ever appearing...... I know you can hide it on start-up by going to >>tools >>startup and unchecking display database window.
Basically I have a logon form which appears when the database starts which users have to enter their logon id and Password which verifies there user_level and logs them into the database...... however more experienced users can get around this by checking the display window on startup :(
Is this possible or am I doomed..
Cappytator :)
Is there any-way to disable the database window from ever appearing...... I know you can hide it on start-up by going to >>tools >>startup and unchecking display database window.
Basically I have a logon form which appears when the database starts which users have to enter their logon id and Password which verifies there user_level and logs them into the database...... however more experienced users can get around this by checking the display window on startup :(
Is this possible or am I doomed..
Cappytator :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi jadedata :)
So there's no way around it :( the database window will always appear if users want to see it :( :(
I don't have any-problems with security as I have converted my db to MDE and have disabled the shift function with a module.
It's not really a big problem, the logon form is only used to verify users_level, which the main form uses to see who's connected, and these individuals can easily be kicked by an administrator as long as they've logged on correctly...
If users don't logon correctly and access the main form, when they try loggin of they will get an error message becuase its trying to take a tick out of a field in tbl_Users when in actual fact the user isn't logged in :( so these are the only problems i can see with that.
Cappytator
So there's no way around it :( the database window will always appear if users want to see it :( :(
I don't have any-problems with security as I have converted my db to MDE and have disabled the shift function with a module.
It's not really a big problem, the logon form is only used to verify users_level, which the main form uses to see who's connected, and these individuals can easily be kicked by an administrator as long as they've logged on correctly...
If users don't logon correctly and access the main form, when they try loggin of they will get an error message becuase its trying to take a tick out of a field in tbl_Users when in actual fact the user isn't logged in :( so these are the only problems i can see with that.
Cappytator
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BTW
It appears that your biggest problem is the fact that your users can get to the menu options that make the db window properties available.
This line:
ChangeProperty "AllowFullMenus", dbBoolean, False
will fix that too. I highly recommend custom menus if you need the functionality
It appears that your biggest problem is the fact that your users can get to the menu options that make the db window properties available.
This line:
ChangeProperty "AllowFullMenus", dbBoolean, False
will fix that too. I highly recommend custom menus if you need the functionality
ASKER
Thx guys, gunna test :)
ASKER
dds110, maybe it's just me, but I can't get this to work :(
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Where are you having problems? Remember to post the code into a new module. Place the cursor somewhere in the Sub procedure and hit F5. Let me know.
ASKER
thx guys for all your help, finally got it to work.....
dds110.. what does pressing f5 do exactly?
When i previosly pasted the code in a new module i didn't press f5 i just saved it... and nothing happend..... but by pressing F5 it works ?
dds110.. what does pressing f5 do exactly?
When i previosly pasted the code in a new module i didn't press f5 i just saved it... and nothing happend..... but by pressing F5 it works ?
Let's remember that Access is NOT SQL Server.
If you've already secured your database, hiding the DB window is as good as it gets.
The next step would be converting to mde and password protecting the DB.
regards
Jack