forme baseret på adgangskontrol

Er det et system med flere adgangskoder til den ene form, så brug in inputbox, jeg vil gerne lave en demo db.
Vh Henrik13

det må du meget gerne. du kan sende den til : administrator@business-call.dk

without having to program your user access permissions the best solution is to use Access's own security. You can read about this in Access HELP. Once it is implemented then it is by far easier then doing it all in code.

ok... i'll give it a shot!

http://support.microsoft.com/default.aspx?scid=kb;en-us;165009

Er sendt. Inputboxene ligger i modul1. Sammen med metoden til åbning af form Med/Uden skrivebeskyttelse.

terry-> hvordan er det det virker? er det sådan at man opsætter brugere for hver computer, eller for hver bruger? jeg kan ikke helt få det til at spille.

Følger med :)

I'll getback tomorrow ratherlate now :o)

Have you read the Security FAQ document there was a link to? http://support.microsoft.com/support/access/content/secfaq.asp
In Access there is a "User-Level security Wizard" its found in the tools+security menu. But it would be best to read a little about how it works before jumping in!
Basically you give permissions to Groups, each group can have different permissions to the dB. Then the users who each has their own password gets assigned to one or more of these groups. So moving a  user to another group gives him/her the permissions for that group.
Access uses a file named system.mdw for security and this file MUST follow the application so that all users have access to the same .mdw file. Actually security is always ON and there is a file being used named system.mdw. So if you dont tell Access which .mdw to use then it uses the default.

If you search after a file on your PC named WRKGADM.EXE then double click to start the application, you will see the default security file (system.mdw). You can create a new one hwich you should use for your application. Dont use the default.

hvordan skifter man bruger? Når jeg kører min applikation kom der i starten en boks frem hvor man kunne indtaste sit brugernavn, og adgangskode... denne er væk! hvordan får man den frem igen, eller skifter bruger på anden måde???

jeg har fundet ud af det, jeg ændrede bare password på admin'en, så promptede den mig...