RESOLVED Database sharing !

Hi All !,

I have created an utility which is Login/password based in Access 2003. I have created a MDE file of this database.

Now I have uploaded this MDE to the server and created shortcut on the local user machines. This utility should work on Network (LAN).

When I open the MDE from a loacl machine, It asks for macro security setting and after that shows that Database is ReadOnly. When user log in then it should add a record in a table, maintained for Session log. But this is not done on the user's machine. While I am able to do this from my machine.

What may be the error and how can I resolve it ?

Please help !

Alankar

read/write permissions on the folder on the shared area.

Hi Ecniv!

I am still trying to sort out the shared folder permissions on the server with the help of my System Administrator.

Get back to you after my R & D.

Thanks,
-Alankar

Hi Ecniv !

I placed my MDE in a folder at server which has permission full control to everyone.

But only I am able to use it from my local machine. All other users are unable to use it and it is showing ReadOnly database on their machines. Also I noted that no user is able to delete the MDE from the server, but I can do this from my local machine.

What may be wrong ?

=Alankar

I take it that the server is on a works network?
If no one else can delete the mde, then they do not have full rights. Usually I had to go to the network administration people to assign a group to the folder, giving them full access.

If you are not looking after the network, then ask them about it.

Also, I am asuming that the network (shared) drive/folder is viewable via windoze explorer.
If this is not that case, then I am sorry, I cannot help, otherwise ask the network admin nicely to see if they have some ideas.

Also as a test use a text file, then get the users to
1) browse to it (view the file)
2) open it
3) edit and save
4) delete it
5) create a new blank text file

if they can do 1 and 2 then they only have read-only access
if they can do 3 they have update access
4 and 5 are self explanitory, but at least you can tell whether the other users are getting full control to the folder or not.

Hi Ecniv !,

The folder in which the MDE is placed is viewable in the Windows Explorer.

The folder is having full control permission for everyone.

All other files in this folder are fully accessible and are deletable by the users, except this MDE.

waiting reply,

Alankar

hmmm
Is the file itself been set to readonly?
When the file is opened by someone else, does an ldb get created too? If not then everyone does NOT have full access (even if XP Pro says they do).
Also found that on my home comp the xp pro for accessing folders was inherited, so all folders above also needed to have full access, or it would not share on a local network. Possibly a bug in ms or the way I set it up.