multi-user/networking

[Tracey]

I have a few databases that were in access 97, but once
gone thru a few conversion are no longer multi-user. They
are ones that i did not create but of course have to
maintain and fix this. I need to make the db's so that more
than one person can be in the db and add/update data and be
able to save.

What I have done so far: checked settings in Access
(currently access xp), everyone is set to shared

Novell rights/settings to that directory are the same and
they have read/write/create/delete access.

Someone outside our agency said something about creating a
mde file? I'm not sure how to do this. I'm not a programmer
and will need basic instructions

Thank you for any help!
Tracey

 

[Cheryl Fischer]

Tracey,

Re MDE file: Creating an MDE file of your Access database will have no
effect on whether the database can be opened by multiple users or not.
From Access Help, here is the definition of an MDE file and what it does:
"When you save a database as an .mde file, Microsoft Access removes all
editable source code, compiles all modules, and compacts the database. Your
Visual Basic code still works, but the code cannot be viewed or changed. In
addition, you can't add or make changes to form or report objects."

You appear to be checking the things that need to be checked; however, you
might want to clarify one point with your network people: Make sure that
Read/Write/Create/Delete permissions are set for each user *on the folder*
in which your database resides - not just the directory in which the folder
is found.

hth,

 

[Guest]

they have those rights. The db's are stored in
Y:\apps\access97 the have full rights to the access97
folder/directory.

 

[Guest]

I created a mdw assigned rights etc. I had one user "join"
that mdw. she can now work in the database at the same time
but still cannot save if someone else has it open. I also
gave her "supervisor" rights to the below direcory

any one else have an idea? Do you have to create a runtime
app in order to have a user log in to a db? I have the
developer tools for office 97 but not office xp

thanks
Tracey