login info på sammenkædet tabel

same way as you did with db1!

jeg har ikke lavet en sammenkædet tabel i db1 !!!!?

can you give some more infor please? Is db1 the front end (forms etc) and db2 the backend(data)

What types of databases are dB1 and db2 (SQL Sever) ?

ehh - niether...

Jeg vil bare gerne kunne lave en sammekædet tabel i db2 fra db1, dvs tabellen tabel1 (som ligger i db1) vil jeg kunne tilgå fra db2...

Derudover vil jeg også kunne angive et brugernavn, da denne bruger kun har læse rettigheder i tabel1 i db1.

begge databaser er access 2000 (som skrevet i det oprindelige spørgsmål  !?!?)

how is your security set up for dB1?

In dB 2 you should be able to just link the table as follows.
In the files menu select get external data, link tables. Then find db1 containing tabel1. You may be requred to log in

det er også det jeg gør, men hvilken bruger logger jeg på med ?

how is your security set up for dB1?

der er oprettet en bruger ("bruger1", som kun har læse rettigheder i tabel1

What TYPE of security are you using? Is it something you have programmed yourself or are you using Access user/group security?

If you are using Access user/group security are youusing the SAME system.mdw file for BOTH databases? If you are using the same system.mdw file then you will be using the user currently logged on to access dB2.

ok - hvordan åbner jeg så access så det er bruger1 der er "logget ind" ?

tknudsen>I cant give you a correct answer UNLESS I know what METHOD of security you are using!

det er en applikation i access - det er ikke en ekstern applikation, så det må vel være access's egen sikkerheds metode der bliver brugt !?

If you are not prompted with a login form then there is NO Access, unless this is hard coded into the application. If it is hard coded into the application then it will be the current user (NT login) who is "logged in".

Do you know anything about application? have you made it?

nope, men jeg har sourcen...

jeg har ikke tidligere arbejdet med multi user i access !

tknudsen>You say "har jeg oprettet en bruger som har læse rettigheder til tabel1" and then you ask "Hvordan læaver jeg så en sammenkædet tabel i db2, som anvender brugeren fra db1"

From this I understand that table2 in dB2 DID NOT exist the the original program and now you wnat to include this. IF thsi sis correct then it should NOT be necessary to do anything other than link the table from db1 and it should work. But as I have no idea as to how security is being used then it is hard to say.
HOW did you create a user with READ permissions on table1?
If there is NO Access security

Sagen er den at db1.mdb bruges af en ekstern applikation, som skriver data i tabel1. Når jeg åbner db2.mdb låser den tabel1 i db1.mdb da db2.mdb har en sammenkædet tabel (tabel1) i db1.mdb. Og så længe den tabel er låst kan den eksterne applikation ikke skrive i tabel1 i db1.mdb !

lukker