We recently split a Microsoft Access 2007 accdb file into two separate files so that users would not accidentally get into the debug mode and unintentionally change code. (which was happening occasionally)
After we did the split we created a shortcut from our Windows 2008 Server to the clients to the ACCDE file which on the server gives us a good shortcut from which to launch the application.
However when we go to the clients and try to launch from the same shortcut we get the " Path was not found to the ACCDB file. So testing the shortcut on the server to the ACCDE works just fine.
We thought since the ACCDE is on the Server but launching it fails with the error "path not found to the ACCDB file " which on the client machine was located at C:\.........\Data|\Ourdatabase.ACCDB It would seem that the client machines are looking locally on the C:\ drive when they should be looking on the Server.
Does anyone know how to solve this or are we looking in the wrong place......Please advise. Thank you.