How does Access Know? (1 Viewer)

[Ketcham488]

Today I finished and installed a access project for a nonprofit that has no server, just a bunch of PC's connected thru a a old Synopsis 2950 Switch. I split the database and loaded the BE in a shared folder on a PC and then distributed the FE to other PC's. My question is no matter where the PC was located the FE knew where to find the BE and work. I was kinda amazed, everything just worked! Thanks for your help!..sdk

 

[Pat Hartman]

It "knew" because you split it on the network so the FE knew where the BE was when it was split and the "path" to the shared folder was the same from all the computers.

If you move the BE to a different folder, Access won't be able to find it. You'll need to use the linked tables manager to find it and point to the new location.