Modified Table

[Guest]

Hello,
My database is already " go live" and I have split it into Banck End in the
server and Front in the users' computers.

I need to add 2 fields to the table, for "archived"using check box and "date
of archived". My question is how can we do it, can we revised the BE table
and then we moddfy the form in the FE to conform with the table?

Many thanks,

Frank

 

[John W. Vinson]

Hello,
My database is already " go live" and I have split it into Banck End in the
server and Front in the users' computers.

I need to add 2 fields to the table, for "archived"using check box and "date
of archived". My question is how can we do it, can we revised the BE table
and then we moddfy the form in the FE to conform with the table?

Yes. You must open the backend database itself to make the change to the table
structure. It's then a good idea to open the frontend, DELETE the link to that
table, compact the database (to get rid of query optimization code, cached
records, etc.) and re-link to it. You can then open each affected Form, view
its Recordsource property, add the new field if necessary, and put controls or
code on the form to use it.

John W. Vinson [MVP]

 

[Guest]

Hi

Further to John's comments, - as someone who always looks for an easy life!,
if you are running Access 2003 (I think this will also work in Access 2000 as
well) set the front end DB to compact on close anyway - that way you will
remove any bloat on the local copy each session plus all the things John has
mentioned.

You could also make use of this rather superb utility written by Tony Toews
(Auto FE Updater) that allows you to make the Front End change centrally, and
it will distribute them to your users. Details can be found at

http://www.granite.ab.ca/access/autofe.htm (sorry don't know how to do
hyperlinks in here)

And finally, if you change your startup form to delete and recreate your
links each time the FE is opened, then you are well set to make any
subsequent changes in future without having to do all this manual stuff each
time

HTH