Microsoft Access help

[ppaik]

I need a little help I have a feeling its very simple, none the less I am struggling with this. We have a server that has an Access DB and I shared it with all the workstations. The only way I was able to share the thing was to map the drive on each computer. Now I want to set them up as read-only, but I can't. Does anyone know how I can change this? or is this the only solution I have?

Thanks in advance!!!

 

[MattTheTech]

Microsoft access files create an LDB file where the database is stored, which contains locking information (to keep track of which parts of the database people are editing, so people dont edit the same thing etc...)

if the share is read-only, it cannot create this file.

one solution would to be implement the security in the access file itself, instead of the share.

 

[ppaik]

thanks will try it out!!!

 

[ppaik]

ok....heres th problem.....for some reason, i cant share the file and allow others to view the database....i have to map the drive to F: on everyone's computer....so I guess its a little more complicated...

 

[MattTheTech]

it might also work if you simply create a link to the file on their machine.. giving it the network path to the file.. like :

\\servername\sharename\file.mdb

(its worth a shot if you dont want to have to map a drive.. might not work though for several reasons)