Avatar billede fimo Seniormester
07. november 2003 - 14:12 Der er 7 kommentarer og
1 løsning

Password tabel

Jeg har en access database som der er flere
der printer ud fra(en FORM side med macro knapper).
Det er den eneste side de skal kunne åbne, ikke
nogen tabeller,forespøglser,rapport mv.
Men hvis jeg bruger den funktion der hedder
"beskyt database" i access 97, så låser den hele databasen, så man ikke kan få adgang til
"FORM siden".
Er der en der kan hjælpe mig med dette problem ?
Avatar billede terry Ekspert
07. november 2003 - 18:00 #1
not quite sure what the problem is but in the Tools+startup menu you can choose a form which is to be opened when the database starts.
Avatar billede fimo Seniormester
07. november 2003 - 18:28 #2
i have already made access start up with my form but if somebody
else close that "window" they would be able to change my data in my tabel's which i DON't want them to do.
They should only be able to view/print from my "form page"
(if that's possible ?)
Avatar billede terry Ekspert
07. november 2003 - 19:01 #3
You will need to implement Access security to do this 100%
You can also hide the database window from the startup-menu butthat doesnt stop people from hold shift down when the dB gets opened
Avatar billede fimo Seniormester
08. november 2003 - 09:57 #4
..."implement Access security to do this 100%"...
How do i do that, is that an easy task or ???
.."hide the database window from the startup-menu"
How do i do that ?
Avatar billede terry Ekspert
08. november 2003 - 10:20 #5
Implementing Access security is easy if you know how, but then thats the case for most things isnt it? :o)
It can be a bit of a mouth full understanding it, but once implemented is very effective and flexible. You should be able to read about it in Access help, it would take me far too long if I were to explain it to you.

You can hide the database window form the Tools+Start-up menu, the same place as where you choose which form is to open on startup! (Checkbox = Display DataBase Window)
Avatar billede fimo Seniormester
08. november 2003 - 10:34 #6
is there a way to hide the line with "file-edit-insert......"
if i use your answer 2 ?
(i tried to remove all the "flueben" in the start up menu)
Avatar billede fimo Seniormester
08. november 2003 - 10:37 #7
hi again terry,

Forget my last question, because it works fine for me now...

Thanks for your help :o)
Avatar billede terry Ekspert
08. november 2003 - 10:38 #8
selv thanks :o)
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester