Question Locked

opening a folder on my network using Access 07

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a database that has a sql 05 back end. The database is a list of jobs. I would like to point this database record to the scanned copies of the record that reside on my server in a share
path \\server\share\jobs\jobnumber and be able to open the folder with the corresponding job.
I have to use this beside attachments as it will exceed the size limit and SQL 05 does not support attachments.

is this possible?

edited for spelling...

2 replies

by rob miners

but worth a try.

You could try this by substituting the Drive Letter for your Mapped Drive Letter, Your Shared Folder and Database Name. Navigate to C:\Program Files\Microsoft Office\ and check the folders. Create a shortcut from the modified link below and place it in the Desktop of the Users profile.

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "Drive letter:\Shared Folder\Access.mdb"

This discussion is closed to new replies.