Upgrade Tables in access

[Alu_GK]

Hello
Access 2003. vista.
I have an application with 5 users.
This application is splitted, 1 file is the application, the other is the
data, and the application is linked to the data (Tables) file.
To upgrade the application, i simply replace the old on with the new on, and
no harm done.
I need to do this some time on the tables file, which is an MDE file.
My Question - do i have any option, with a VBA code, to redesign a table is
the mde file ? for example - to add a field or more ? to add a table or more
to the file ?
If not with VBA, then if anyone have an idea how to upgrade the table file
in a simple way, that can be done by the users themselfs.
Thanks

 

[Peter Hibbs]

If you want to make changes to tables in a back-end database file then
have a look at the Back End Update Utility code at :-

http://www.rogersaccesslibrary.com/...p?FID=21&SID=1467163adzcf2ff6c866b65a8772d953

If you need to re-link the front end to the back end at the user's
site (which you probably will) then have a look at the Back End
Re-Linker code on the same site.

If the users are using a network and you need to replace a number of
front-end files on several computers then have a look at the Front End
Updater Utility which provides a VB program to do that automatically.

HTH

Peter Hibbs.

 

[Alu_GK]

Hey -
Thanks !!!
the link you gave me helpfull in more ways. so double thanks to you.

 

[Larry Linson]

There's no need to package the "back end" tables / relationships database as
..MDE.

MDE locks out design view on Forms and Reports that have associated code
modules; otherwise, it provides no security nor safety that an MDB file does
not provide.

Larry Linson
Microsoft Office Access MVP