Computer Identification - Security

[razaqad]

In my Frontend, i use parameters like:

1) computer name
2) a certain file's existance

So i'm sure that the front end is being run on an autherized computer.

i have hardcoded these values in the vb code and password protected the project so that no one knows about it.


what other parameters can i use to stop the front end being run from any other computer else than thoses allowed.

 

[Len Boorman]

If you are using across a network how about capturing the User logon ID. Compare this to the contents of a table.
If exists then
do nothing
else Application.quit
end if

This way you do not care which computer or indeed about the existance of a file. Youi just check the User ID.

You could stamp all new records with this value as well along with data and time. You could write the uer id , date and time to a table so you have a log of who used the application and when. Could couple this with capturing the date and time that user exit the application as well

Or you could use Access Security and control that way

L

 

[razaqad]

computers are shared by some other users too with the same logon info.

I just want that no one to copy the front end and BE and take it out of the organization.

I want that the software only be accessed from within the computers of the organization.

 

[pbaldy]

You can use this to make sure it's on the correct domain:

http://www.mvps.org/access/api/api0040.htm

 

[razaqad]

my workstations are not even on a domain.

its a workgroup

 

[Len Boorman]

computers are shared by some other users too with the same logon info.

I just want that no one to copy the front end and BE and take it out of the organization.

I want that the software only be accessed from within the computers of the organization.

How do you stop a person copying any file and emailing it to themselves at an external email address ?.
Copying a file to cd ?

If somebody knows enough the life gets difficult if not impossible.

Maybe Full Access Security but that is not totally bombproof

Len

 

[razaqad]

How do you stop a person copying any file and emailing it to themselves at an external email address ?.
Copying a file to cd ?

that is what i want to stop. I use checks like computername , existance of a particular file on the computer. So if these conditions are not met the software closes by itself.

These people dont have any knowledge about databases and programming, so they cant bypass the logon process on the startup form. Or they cant access the tables etc.

I am in search of some more checks that i can perform at start up. So if even someone copies the DB and take it to their place they won't be able to open the application.

Currently i'm using these checks

Public Function CompChk()
   Comp = GetComputerName()
   If Comp = Autherized computerThen
   CompChk = True
   Else
   WarnMsg= MsgBox("This computer is not autherized to run this software.", vbCritical, "Access Denied")
   CompChk = False
   Application.Quit
   End If
End Function

Public Function FileChk()
   Set fs = CreateObject("Scripting.FileSystemObject")
   
   If (fs.FileExists("MyFile")) Then
   Else
   WarnMsg= MsgBox("This computer is not autherized to run this software.", vbCritical, "Access Denied")
   Application.Quit
   End If
End Function

Public Sub LoadFrmChk()
CompChk
FileChk
End Sub

I need some more checks like the ones i have mentioned above.

Thanks