Microsoft Access Problem

By ulejas38 ·
This issue started happening around 2 months ago and has driven me crazy.
We have numerous shared Microsoft access databases throughout our network.

The individuals having the issues have the below configurations.
Windows XP SP3
Office 97 Professional
Local Admin. Rights

If employee A has a database open and employee B wants to open the same database. Employee B can't double click on the icon to open the database. Double clicking on the icon has no affect. No error, No message, nothing. Just like you didn't even double click on it.
I thought I had it pinned to the Microsoft jet engine not deploying to open a .ldb but then I found a work around. If I open Microsoft Access through start>>programs and then through Access open the database that I couldn't open by double clicking, everything works perfect. Opens up just fine.
Another interesting thing, if I log on to the workstations that are having problems as a Domain Admin I can open those databases just fine. I know what your thinking that it's a permission issue but it can't be. I have a few W2K workstations running Office 97 and logging in as a user that previously couldn't open the database using XP can with W2k.
I've search with no answers to this question.

Any help will be greatly appreciated.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

See if this is of any help

by Jacky Howe In reply to Microsoft Access Problem

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"
<i>Keep us informed as to your progress if you require further assistance.</i>
<i>If you think that any of the posts that have been made by all TR Members, have solved or contributed to solving the problem, please Mark them as <b>Helpful</b> so that others may benefit from the outcome.

Related Discussions

Related Forums