add table field

  • Thread starter Thread starter richaluft
  • Start date Start date
R

richaluft

Hi:
Can anyone describe how one can add a field to a table (in code) for a
linked table?
Thanks,
Richard
 
Hi:
Can anyone describe how one can add a field to a table (in code) for a
linked table?
Thanks,
Richard
Click to expand...

Your code would have to first open the back end database where the table resides
and then it would use code to modify the table in that file. Nothing can be
done via the link.
 
Your code would have to first open the back end database where the table resides
and then it would use code to modify the table in that file. Nothing can be
done via the link.
Click to expand...

Rick:
But can I open the back-end Db table from the front end Db? I think I
heard that this is do-able, but I don't know how.
Richard
 
Richard,

To open up the backend database, look up the OpenDatabase Method in the help
file.

To add a field to a table, look up the TableDef Object in the help file.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
This email made with 100% recycled electrons!
Miscellaneous Access "stuff" at www.ScoBiz.com
 
The fact that you have a need to add a column to a back end table "on the
fly" leads me to believe that you have a spreadsheet that you are calling a
table. Under what conditions do you need to add a new column?
 
Back
Top