T
Tracey
I'm reposting this plus my replies.. not sure how many
people scroll back a few days.
databases that were in access 97, but once gone thru a few
conversion are no longer multi-user. They re 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!
TraceyCheryl's reply
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,
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
What I've tried since:
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
people scroll back a few days.
I have a few
databases that were in access 97, but once gone thru a few
conversion are no longer multi-user. They re 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!
TraceyCheryl's reply
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,
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
What I've tried since:
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