Add fields to BE Tables remotely

[Robin Preiser]

Hi Y'all,
I have completed some updates on a FE/BE Access 2002
program, converted from A97, and some new fields and
field type changes were required in the various tables.
Distributing on CD will be straightforward for the front
end using Wise and Sagekey scripts. But I am stuck on
how to use some form of automation to change a handful of
field types, from number to text, and Add New fields to
existing tables.

I have had some luck with Alter Table SQL to add a couple
of the fields but cannot seem to change the field types
or set defaults. Importing has not produced the results
that I expected.

Please let me know what I'm missing.

Thank you, Robin Preiser

 

[Rebecca Riordan]

Robin,

You can't change the field type. What you have to do is add a new field and
copy the data across using an update query.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...