Adding a field to a table with vba-code

[Mgomp]

Hi all.



I have a situation I need some help to fix:

I have a Front-end which several user have a copy of, and they are all using separate Back-end files. (One Back-end for each project)

Now, i have a situation that I have to update the front end, and I need to add a field to every back-end table. But, when that i is done, I need a check in the front end that skip this code if the field in the table are selected.

So I need som hint how to programaticly add a field to a linked table from a front end.
And a code hint on how to check if the field are present...

Regards,

[Robeen]

I've never had to do this but I know that the TableDef Object in Access is what you'd use to achieve this.
Try this link:
http://www.access-programmers.co.uk/...d.php?t=174293
. . . or Google TableDef Object.
I hope this helps.

[orange]

Could you explain these comments in more detail? This is not typical of a split, multi-user simultaneous activity database.

a Front-end which several user have a copy of .. but not all users?

They are all using separate Back-end files. Why?

For adding a field (and other things) see http://allenbrowne.com/func-dao.html

[Mgomp]

Orange.

Thank you for the the link in your reply. This gives me several good ideas.

For your questions, please excuse my lousy english writing.
- Not all in our company need this front end - I ment to ilustrate that several persons have this front end.
- After dealing with one back end, and the limitations of access, I fund that using one backend for each project (with average on 8 - 12000 records) is more suitable for our use.

The question was based on the point there I would like to deploy a new front end, which - by vba - does the nessecary updates on tables.
If I should be little fretty, the module ModifyTableDAO() in your link would be absolutly perfect in my situation if it had a check that check if the field exist befor trying to ad it. This becaus if a user opens an old backend from earlier project, the field would be added automaticly if it's missing...

Regards,

[orange]

I found these via google. I know there are various front end updaters out there. You may get ideas..

http://www.btabdevelopment.com/ts/freetools
http://www.access.qbuilt.com/html/update_front_end.html