Database diskretion

(kigger lige med, for min løsning er ikke så lidt kompliceret....)

All that I suggest is that tables which are to have discrete data has a column containing a user ID. Then the forms and reports etc. only select those where the USER ID is that logged on!

det var samme løsning jeg ville have foreslået, tvivler på at der findes en nemmere måde at gøre det på...

I dont think so either!

Good to see you're still "around", terry

Det lyder jo meget godt...! Men i et forståeligt sprog; hvordan får jeg de til at virke ? Jeg kender intet til programmering, og bruger kun de indbyggede wizards.

Yes, but in a couple of weeks I'm off on my summer holidays :o) what about you puppetmaster?

I'll let terry take care of this one...... ;)
(Well, already spent 1 week of my vacation doing NOTHING.......I think I might just have to take another week off, sorta to get on top of the pile of GARBAGE that's building up at home!) ;)
catch ya later, terry

semperfi>Dont get me wrong, but if you have no idea about SQL and programming then you have a problem on your hands!
First you have to create your tables and make sure one is for th euser ID.

Then you need some logon routine, to get hol do fthe user ID and thenI suggest that you use query builder to make queries which you use for your
forms.
Then in each query you have a criteria for the USER ID column which could call a function which gets the user ID.

First you have to create your tables and make sure one is for th euser ID.

=
First you have to create your tables and make sure one COLUMN is for the user ID.

Jeg har lavet en database, hvor fælles data, der må ses af andre ligger på et fællesdrev, og de private data ligger på medarbejderens personlige drev...

well that was another idea, and as long as these records dont figure in any other "joint" information then I would say its the easies to implement.

I mine databaser styrer UserID hvilke data man kan se. Det vil sige at hvis jeg logger ind på min computer med mit brugerID så kan databasen også hente det, og via en tabel se hvilke data jeg må se, og derfor også hvilke andre BrugerID's data...

OK! So it still needs to use USER ID to do this!

Yeps!

Giv Semperfi et modul som kalder UserID....

semperfi>can you rspond to these comments and answers please!

Beklager den lange ventetid - fridage etc..!
Jeg er ikke så stærk i Access moduler, heller ikke det med at kombinere logon med UserID tabel.
Jeg havde ventet en mere "let" løsning.

Den findes nok ikke...

Hi semperfi>as 3xa says, there isnt an easier way! Is a hard world we are living in :o)

Hvad gør vi så med point´ene ?

I øvrigt: findes der et Run-time modul til Access 2000: Jeg vil gerne have mulighed for at køre databaser på PC´ere der ikke har Access installeret. Kan det mon lade sig gøre ?

You can get the runtime with Office Developer Edition!
Points, well they can be shared to those who have given infromation!