Thanks for that, but I don't know of anyway of 'putting' anything into the backend to run, unless anyone has any suggestions. I am trying to avoid visiting the client (2 hrs travelling) for a 2 minute job. Thanks Jane
--- In [email protected], [EMAIL PROTECTED] wrote: > 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 --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
