Code to update fields in backend database

[Beth]

Hi,
I have an Access 2002 database with a FE/BE structure. Each user may have
up to 20 backend files that I allow them to dynamically link to from my main
switchboard. All that works great.
However, I now need to add some fields to the backend file. With over 100
backend files ( growing list), I need some way to have the front end check
to see if those fields exist and then add them to the backend file if they
aren't there. Is there a way to do this?

Thanks in advance,

Beth

 

[Steve]

Look up TableDef Object in the Help file. There are instructions there to do
what you want.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John W. Vinson]

However, I now need to add some fields to the backend file. With over 100
backend files ( growing list),

owwwww.......

It really sounds like you're "storing data in database names", which is even
worse than "storing data in tablenames".

You have hundreds of more-or-less identical .mdb files as backends to a single
application?? Why? How on Earth are you going to replace or update all of
these different backends?

I really have to ask, because this is a VERY unusual way to set up an Access
application - perhaps it's legitimate, but I've never seen a case where this
was done!

John W. Vinson [MVP]