Have you ruled out remote connection to their system using GoToMyPC, pcAnywhere, or other such services? That would let you have the necessary hands-on.
Aside from that, here's an idea I've used successfully several times with remote clients: Create a temporary MDB that someone at the client will execute, and then discard. This MDB would contain code to add the field to the table ... refer to DAO tabledefs etc for instructions in VBA. Once you've tested to make sure it works on a copy of their back-end, then submit it to your main contact person, ask them to run it for you (preferably with everyone out of the data), and problem solved. HTH Bryant --- In [email protected], "vjcross2004" <[EMAIL PROTECTED]> wrote: > 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/
