mde updates

[Dan @BCBS]

I have a few Access databases linked to SQL Server db's.
I make my changes and create my mde file. But I always wait until everyone
is out of the Access database to delete the old mde and replace it with the
new one.

Is this necessary? Can I work on a database and update the mde without
effecting everyone?

Thanks

 

[Douglas J. Steele]

Each user should have his/her own copy of the MDE, preferably on his/her
hard drive.

You should also have a "master copy" of the MDE on the server, and have some
mechanism in place to ensure that each user always has the most recent
version of the MDE. See what Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

 

[Dan @BCBS]

Everything you stated is correct and reflects what I do.
We do update the mde - which is how I make sure they have the most recent
version.

But my question pertained to when I update the mde. If people are working
thru an mde which updates the SQL database, do I have to wait until everyone
has that mde closed. Because that is what I do, when everyone is out, I
delete the old mde and replace it with the new one. Is this necessary? If
people are working and I replace the mde they have open, with an update, that
has the exact same name, will they loose all the work they have been doing???

I do not see were Tony Toews letters address that concern..

Thanks

 

[Keith Wilby]

Everything you stated is correct and reflects what I do.
We do update the mde - which is how I make sure they have the most recent
version.

So if you do do what Doug suggested, why do you need everyone out? The copy
on the server is never opened on the server, it is copied to a local drive
and *then* opened.

But my question pertained to when I update the mde. If people are working
thru an mde which updates the SQL database, do I have to wait until
everyone
has that mde closed. Because that is what I do, when everyone is out, I
delete the old mde and replace it with the new one. Is this necessary?
If
people are working and I replace the mde they have open, with an update,
that
has the exact same name, will they loose all the work they have been
doing???

Keith.
www.keithwilby.com

 

[Dan @BCBS]

Correct, The serve MDB is never opened and the users are using the MDE.

"We use shared drives for local drives"

Question: the user has an MDE open, then I update and create a new version
MDE and copy it to the shared (local) drive, but they are still working in
the old version until they close it and reopen it - which would open the
newer version MDE.

I beleive the answer is, because the data is updated to the SQL db it does
not matter which MDE they are useing. But I have started this Post because I
had issues with users loosing the data they entered....

Dan