mde problem

[gibsonsgman]

alright, i have a problem. I do not know if this is even possible. I
have a front end and back end database in access. My database is multi
user and located on a network. I have a command button that if
selected, will create a copy of the .mde file on that users desktop to
speed up the database. What I want to do is to make this copy read
only if it is not on the network so the only way data can be updated is
through the network version.
The only thing i could think of is having two separate databases with
two separate mde files, one read only and one not and having the
command button copy the read only one to the desktop. I do not want to
go this route because any changes i make have to be made twice. any
ideas on how i can accomplish this?

 

[gibsonsgman]

actually, nevermind. I wasn't thinking. If the BE stayed on the
network, which is what I would be doing, then data integrity could
still be maintained through the security i have set up. I would still
be interested in knowing if this is possible though, so if you know,
please fill me in.

 

[Joseph Meehan]

alright, i have a problem. I do not know if this is even possible.
I have a front end and back end database in access. My database is
multi user and located on a network. I have a command button that if
selected, will create a copy of the .mde file on that users desktop to
speed up the database. What I want to do is to make this copy read
only if it is not on the network so the only way data can be updated
is through the network version.
The only thing i could think of is having two separate databases with
two separate mde files, one read only and one not and having the
command button copy the read only one to the desktop. I do not want
to go this route because any changes i make have to be made twice.
any ideas on how i can accomplish this?

If the mde you are talking about is the FE, it should not be located on
the server, it should be on each users's machine and all the data should be
on the BE on the server.

 

[gibsonsgman]

yeah, thats what i am talking about, but i don't want to go around
installing it on each individual machine, so i wrote a .bat file to
have each user install it themselves. once i posted it i realized it
was kind of a dumb question. sorry.

 

[Joseph Meehan]

yeah, thats what i am talking about, but i don't want to go around
installing it on each individual machine, so i wrote a .bat file to
have each user install it themselves. once i posted it i realized it
was kind of a dumb question. sorry.

There are tools available to help with distribution and maintenance of
the FE's.. You may want to ask a new question about that.