Access 2010 Runtime Advance Access Level

[Charles CL]

Dear All,

Is it possible for runtime acts to limit certain laptop or desktop to access particular object?
I have an access file that i'm going to put in the web server,
I wish to limit laptop 1 to access only to [purchase order] in MS Access file's name of [Company ABC]

I wish to do so because the laptop 1 will only be available in office and not else place, therefore only procurement person can access to [purchase order] for laptop 1.

If it is possible, please advice the direction as i found only the introduction of access runtime.
Else, please suggest what to do.

Attempt for "else" choice,
I run VBA code to limit user to access to particular object.
They will be guided to particular form which contain all the object that they can access after they successfully key in the correct username and passwords.
So, different group of users will have different forms.

Limitation for "else" choice,
Security is low as if other people get to know the username id and passwords, they can log in to access the object.

##Therefore, i'm looking into laptop base accessible limit.




Regards,
Charles

[ranman256]

youd have to program users list and their rights and what forms they can open.

[CJ_London]

in addition to Ranman's comment, also look at using the environ function to get the computer name - environ("ComputerName") to limit access to a specific PC - this can get round the problem of passwords becoming common knowledge