Database mdb can't access in network drive

[Michael Chau]

I can't access to a mdb file on the network drive, when someone open it first

I double click the files, no response, no error, just can't open it

all the user has full right already.

What's the problem?

 

[Olduke]

Your first problem is that you have an mdb on the server and not an mbe.
For network operations, the database is supposed to be split into a front
end and a back end. While it is possible to use an mdb in the network, you
are now experiencing the problems involved in the decision to do it this way.
I am somewhat taken aback by your claim that all the users have full rights
already. This would indicate that you have some kind of user or group
security set up in the mdb environemnt on the server. You are fortunate that
his is the only problem you are having.

 

[Keith Wilby]

Your first problem is that you have an mdb on the server and not an mbe.
For network operations, the database is supposed to be split into a front
end and a back end. While it is possible to use an mdb in the network,
you
are now experiencing the problems involved in the decision to do it this
way.

I'm sorry but that just isn't true. You can quite happily use an mdb as a
front end provided that each user has their own copy. The advantage of an
mde is that it provides an extra layer of security and a smaller file size.

Keith.