MDE File

[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

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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.

 

[Albert D.Kallal]

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?

You got some good advice and answers here. The following is a "easy" to read
article as to "why" you are being suggested (told) to place the mde on each
workstation.

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Guest]

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?

 

[Rick Brandt]

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?

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