MDE File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I will be creating an mde file and using access 2000 runtime to distribute
the file. On occassion I will need to update one of the text fields in my
form. Will I have to recreate the mde file every time?

Also, I've created the form and tables in ac97 and will be putting the form
and tables in ac2000. Is it just a matter of pasting the form and tables to
ac2000 or is there more involved?

Thanks
Linda
 
Yes, you will have to recreate the mde file and redistribute to the
workstations.

There is a conversion utility to go from 97 to 2000 in Access. Go to Tools,
database utilities, convert. If it is the first time opening in 2000, it
will prompt for a conversion.

Hope this helps.
 
Even though I will be putting the MDE file on a server, I will need to
redistribute to the users? Do I only install the 2000 runtime once on the
users systems?
 
In a multiuser environment, you should ideally have the program on the
workstations and the data on the server. That is why I said it needed to be
redistributed to the workstations. It is easiest to create a .bat file and
attach to an icon on the desktop. That way, each user can update the program
from a copy on the server when needed. At some clients I have it
automatically updating when the workstation is rebooted since they have
changes almost daily.

You are correct about the runtime version. It will only need to be
installed once. I have experienced some instances where the runtime version
needs to be reinstalled when they experienced database errors on that
workstation only.

Hope this helps.
 
I was under the impression that an MDE file would just allow the user to view
the form and not be able to get to the tables. But when I when the MDE file
and open the form, it doesn't allow me to get into the design (which is
great) but if I were to click on the Restore button, then the user can move
the window enough and be able to see the table. Was I incorrect to think the
MDE file would only allow users to see the form?
 
Linda said:
I was under the impression that an MDE file would just allow the user
to view the form and not be able to get to the tables. But when I
when the MDE file and open the form, it doesn't allow me to get into
the design (which is great) but if I were to click on the Restore
button, then the user can move the window enough and be able to see
the table. Was I incorrect to think the MDE file would only allow
users to see the form?
Click to expand...

Yes. An MDE file (by itself) does nothing to protect tables and queries.
Only code-based objects are locked down.
 
Back
Top