Greying out the 'Name' on the logon box

[andrewf10]

Hi all,

Has anyone ever found a way (or a reason) to lock the 'Name' part of the Access 2000 logon box using a command line or batch file? I want to prevent users from logging onto the database from different machines.

Thanks for reading this

 

[ghudson]

I doubt that is possible. Why does it matter which PC the users log into your db?

You could test for the users "computer name" and close the db if the users "computer name" if it is not found within your list

. You of course would have to have all of your users "computer names" stored in a table. Does this sound like something that you want to do? Search this forum for "computer name" and you will find some code to have your db grab the users "computer name".

HTH

 

[andrewf10]

Thanks ghudson I'll do as you suggested. Getting the computer names will be straightforward as they follow a simple naming convention.

The reason I'm asking the question is because some users have a habit of logging onto the database from sub-standard PCs which when (and not if) they crash, bring the database down with it.

 

[ghudson]

I know what you mean about poor quality hardware that can bring down a db and also corrupt it if the db is locked up and the user has to Ctrl Alt Delete it.