accessing access dbs over network

[4johnny]

I have a small office (in a workgroup environment not a domain) that has a number of DBs that reside on one XP PC and shared for everyone to use. All users have mapped drives to this share and when they tried to open a DB they got the message:

"The file is located outside your intranet on an untrusted site. MS access will not open the file due to potential security problems."

So I went into IE,intranet options, secutiy tab, and added that XP PC (\\fileserver)to the trusted sites list. i did this for each PC in the office.

Now when users try to open a DB they get the error message:

"Your DB contains a missing or broken reference to the file MSOLAPUI.dll version 1.0"

Can anybody help me??? I've shared .MDBs before in the past and accessed them from the network without a problem, so I know it can be done.

Thanks

 

[kjv1611]

Do you get the same error on the host machine?

--

"If to err is human, then I must be some kind of human!" -Me

 

[4johnny]

No, it opens on the host machine without error. So what I did was to search the host PC for the file, MSOLAPUI.dll.
and it resides here: c:\program files\ common files\system\ole db folder

I copied that file and put it on the other PC, the one I am trying to open the DB from (over the network). I placed the .dll file in the same path: c:\program files\ common files\system\ole db folder.

Now it opens fine.

 

[kjv1611]

Great! Glad it got worked out!


--

"If to err is human, then I must be some kind of human!" -Me

 

[traycee]

The best way to use an access database in a peer-to-peer environment would be to split the database. The front end would go on each users machine and link to the single backend on the XP computer. That way it also supports mulitple users and has less chance of corruption.