access linked table question

[MrB]

Well, a networked Access linked-table question.

(a) Imagine a network with 3 computers on it, Rocky, Bulwinkle and Natasha.

(b) Natasha has a database on it (frontend.mdb).

(c) Natasha has r/w privileges for files on Bulwinkle.

(d) Frontend.mdb has a linked table to backend.mdb on Bulwinkle. This
works fine when opening the database working from the Natasha. See (c)

(e) Rocky has r/w privileges to Natasha drive folder holding the database.
Steve can therefore open frontend.mdb on Natasha.

(f) Rocky has no privileges on Bulwinke.

The question. If a user on Rocky the database, can that user utilize any
functions requiring linked tables to backend.mdb? That is, does using the
links depend on Natasha's privileges or Rocky's.

Thanks in advance,
Jim

 

[KW]

I believe the host computer (where the file accessed
resides) is the one which sets the R/W privileges . The
guest computer has to have R/W privileges on the host.