is there a way, using code, to change all of the numeric fields in a
database (preferrably in selected tables but not necessarily so) form
Long to DOuble Precision?


Greetings,

Henro Veijer

Execute a DDL query statement to change the field type, e.g.:
ALTER TABLE MyTable ALTER COLUMN MyField DOUBLE;

Introduction to DDL, and example:
http://allenbrowne.com/func-DDL.html#ModifyFieldDDL

List of the names to use in DDL, compared to the names in the Access
interface:
http://allenbrowne.com/ser-49.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Henrootje" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> is there a way, using code, to change all of the numeric fields in a
> database (preferrably in selected tables but not necessarily so) form
> Long to DOuble Precision?
>
>
> Greetings,
>
> Henro Veijer

Thanks Allen



On 2 apr, 17:30, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
> Execute a DDL query statement to change the field type, e.g.:
> ALTER TABLE MyTable ALTER COLUMN MyField DOUBLE;
>
> Introduction to DDL, and example:
> http://allenbrowne.com/func-DDL.html#ModifyFieldDDL
>
> List of the names to use in DDL, compared to the names in the Access
> interface:
> http://allenbrowne.com/ser-49.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users -http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Henrootje" <Hen...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > is there a way, using code, to change all of the numeric fields in a
> > database (preferrably in selected tables but not necessarily so) form
> > Long to DOuble Precision?
>
> > Greetings,
>
> > Henro Veijer- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

1