I would personally use SQL ALTER TABLE statement.
ALTER TABLE tblName ADD TextField VARCHAR(30); 'to add a 30 character text
field called TextField to table tblName.
My guess is you must run this in the back end. Google ALTER TABLE and check
syntax for other data types and keys and indexes if necessary
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
"vjcross2004"
<[EMAIL PROTECTED]
ucts.plus.com> To
Sent by: [email protected]
AccessDevelopers@ cc
yahoogroups.com
Subject
[AccessDevelopers] Modify table in
09/22/2005 07:33 backend with code?
AM
Please respond to
AccessDevelopers@
yahoogroups.com
I have a database split as FE/BE at a clients office. I need to add a
new field to one of the tables in the backend, using code which will
run once when the FE is first opened. I can use TableDefs OK to modify
tables within the existing FE, but not those linked from the BE. This
is a one time only event & all the users can be forced out of the
database before the change happens.
Does anyone have any suggestions as to how to do it?
Thanks
Jane
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
Visit your group "AccessDevelopers" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
