Place db on server

[linanderson]

I have placed a secured backend (be) db together with the workgroup file on a server. The directory as well as the be & workgroup files have full permissions.

The frontend (fe) is on the cd of a pc. I have created a shortcut as follows:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Program Files\Microsoft Office\Office\Client Database.mdb" /wrkgrp "F:\client database\System_DSE.mdw"

I am receiving a message that the workgroup file in the f drive cannot be found. I have checked and checked and I cannot see any errors in how I have created the shortcut. Id there a different way I should express this shortcut.

Can someone let me know where I may be going wrong?

Thank you.

 

[Shep]

I see nothing wrong with the syntax you are using.

Windows doesn't care if you use UNC or a mapped drive, and it isn't very particular about case.

One thing it will balk on is the use of the ampersand (&) in your path. Actually, it converts an ampersand to an underscore.

You might try putting a copy of the frontend in the same folder as the .mdw, edit your shortcut accordingly and run it. You may be able to determine whether the problem is in the path itself or whether casing is tripping you up.

Good luck with it.

Shep