Updating an mde file on the network

[Guest]

Hi,

I have a mde file that i need to update on our network which is shared by
all users. I use runtime to run the database and the link to the mde file is
located on our network. Does anyone know how i can update the mde file while
users are on or if there is a way to overwrite when users are on. Right now
it does not allow me to update the mde file while users are on. I have to
send out a page to everyone to get off. It would be great if i can go ahead
and update while they were on.

Thanks
Linda

 

[Guest]

You can only create and edit queries when there are other users in the
database.

There is a way to see which users are still in your database explained here:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;285822
or
http://support.microsoft.com/kb/198756/EN-US/

But apart from that you just have to get all your users to log out.

--
Adam Thwaites
Access Database Designer
adam.*spamless*[email protected]
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)

 

[Van T. Dinh]

You can't update the design of a database in MDE format. In MDE, the text
component of VBA codes have been removed and therefore you can change the
design of Forms / Reports / etc ...

You need to use the original MDB to modify then create a mew MDE file and
then upload the modified MDE to your server.

 

[Br@dley]

You can't update the design of a database in MDE format. In MDE, the
text component of VBA codes have been removed and therefore you can
change the design of Forms / Reports / etc ...

You need to use the original MDB to modify then create a mew MDE file
and then upload the modified MDE to your server.

They aren't trying to edit the MDE, just update the MDE file with a new
version....

There is no way around it as far as I know. Like any file it will be
locked if someone is using it.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

 

[Van T. Dinh]

OK ... "Update" could mean either but the "overwrite" (which I missed on
first read) indicates the O.P. wanted to *replace* the old MDE with the new
/ updated MDE.

In that case:

1. No. The MDE cannot be overwitten because users have the file open /
locked.

2. While there are posted methods to send message to users (in Access)
asking them to log off (and they may not be in front of their computers) or
even kick them off automatically, the situation arises because users share a
*single* MDE which increases the potential for corruptions and can cause
other problems.

It is much better that each user uses a *separate* copy of the (Front-End)
MDE, whether on the Desktop or the server, e.g. Terminal Server. Create a
Source MDE where all users can access to copy. The Front-End can even be
copied automatically using Windows script or Tony Toews' AutoFE utility.
See Tony's Web site for more info:

http://www.granite.ab.ca/access/autoFE.htm

 

[Albert D.Kallal]

Are you talking about the data part, or the application part?

We assume a split database here...are you trying to update the back end...or
the front end?

Further, you can't allow multiple users into the front end at the same
time...you need to have a copy of the mde front end on EACH
computer.....