Hi,
I am working on a project at work that requires me to log on through VPN to link to my Back End database, the network connection is a bit on the slow side so what i would like to do is use my original Back End database or simply copy the existing Back End database and store it temporarily on my computer so that i can make modifications quicker and i can do this without internet connection, i will be modifying Forms and Reports (the Back End database will not change)
So basically what i want is to use the Front End on my computer as normal
and
Link it to a Copy of the Back End on my computer
Then
Link my front End back to the Back End in the office through VPN (or when i am next in the office)
When i originally split the database i used "Database Tools" "Move Data" "Access Database" but i cant see anywhere to change the location?