Add field to db using code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 22 May 2008 03:17 GMT

I developed a linked front-end/back-end application (Access 2000) for one of
my customers. Is there anyway I can add a field to one of the existing
back-end tables using VBA from the front-end? I'd like to simply be able to
send them a new front-end with a command button that adds the field to the
back-end table. Otherwise, I have to have them send me the large back-end
for modification. Thanks in advance.

Reply to this Message

Bill - 22 May 2008 06:35 GMT

Ken,
I think you'll find your solution at one of Allen Browne's VBA
samples here: http://allenbrowne.com/func-DAO.html#ModifyTableDAO
Bill

>I developed a linked front-end/back-end application (Access 2000) for one
>of
[quoted text clipped - 4 lines]
> back-end table. Otherwise, I have to have them send me the large back-end
> for modification. Thanks in advance.

Reply to this Message