Help with opening multiple Access 2000 files 1

[AnthonyR]

I'm not sure if anyone has ever come across this problem, as I certainly have not.

Well, here are the facts. I am using MS Access 2000 on a Win 2000 workstation. The PC is relatively new, 2.8 GHz with 512Mb RAM. The workstation is connected to a LAN (Novell Netwok).

The problem which happened coincidentally about the same time as SP 4 was released. However I cannot say for certain it is related. Anyhow, the problem is I have three backend Access mdb's stored on the file server and for some strange reason I cannot directly open more than one mdb at a time using Explorer. The problem is more annoying than anything else. My workaround, which seems to work OK, is to firstly open MS Access from the program manager then open the database using File-Open.

Our Help desk is at a loss to explain or solve the problem , so if anyone knows of a solution to this problem please reply to this post.



Cheers
Anthony

 

[mp9]

What value do you have for the Registry Key HKEY_CLASSES_ROOT\Applications\MSACCESS.EXE\shell\Open\command

http://www22.brinkster.com/accessory/

 

[AnthonyR]

There are two values:

"Default" Type is "REG_SZ", Data is "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /NOSTARTUP "%1"

"Command" Type is "REG_MULTI_SZ" Data is "26,!!gxsf(Ng]qF`H{LsACCESSFiles>plT]jI{jf(=1&L[-81-]/NOSTARTUP "%1

 

[AnthonyR]

Well, after much head scratching and cursing, thinking I would never resolve this problem. I tried to see if it was a Registry thingy to noavail. I then went over the steps that our IT help desk followed to see if something was missed. To my astonishment the problem was resolved when I re-associated .mdb files with MSAccess. This was something I did not believe had anything to do with file association given that I could still open .mdb files in the same directory albeit one at a time.