Dear MS Access Expert.


I currently have a split database. The backend on Server 1 and the frontends on each workstation.

I am now in need of introducing a new machine into the above organizational scheme. I will call this Server 2.

Server 2 will be continously updating a MS Access table (call it Table Q) every 5 minutes.

I need the frontend workstations to have access to table Q on Server 2.

Should I organize the new infrastrucutre using option A or option B.

Option A: Link Server 1 to Server 2 Table Q. Link Front End to Server 1 Table Q.

Option B. Link Front End directly to Server 2 Table Q.


What do you recommend? Option A is more effecient from an administrative point of view because all links will be updated from one source (I update links often because I do development remotely). Option B is probably easier for the MS Access engine to understand.

Thanks for your feedback.

I don't think Access will let you link to a linked table so that rules out Option A. I would go for Option B regardless as I think it will have better performance.

Ok Thanks for your input