We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Splitting Access file in two from Accde and accdb the shortcut fails on client machines

Medium Priority
732 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question

Programmer
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Bill RossProgrammer
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.

Author

Commented:
Thank you for the clarity.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.