K
kramer31
Hi. At my company, we have an internal application for updating access
databases. It allows the user to select an access database to update
and a text which contains a series of SQL statements to be executed on
the database.
I'd like to write add to that an SQL statement to change a field from
type int to type double.
Now the statement:
ALTER TABLE tblName MODIFY fieldname double
doesn't work in Access.
ALTER TABLE tblName ALTER COLUMN fieldname double
does work if executed directly in Access, but not when executed by this
application.
Can anyone explain this? I believe that the application uses JET for
database connectivity.
I've read that somehow I can accomplish this by using the hidden table
tableDef or something like that. Can someone explain please?
Thanks in advance.
databases. It allows the user to select an access database to update
and a text which contains a series of SQL statements to be executed on
the database.
I'd like to write add to that an SQL statement to change a field from
type int to type double.
Now the statement:
ALTER TABLE tblName MODIFY fieldname double
doesn't work in Access.
ALTER TABLE tblName ALTER COLUMN fieldname double
does work if executed directly in Access, but not when executed by this
application.
Can anyone explain this? I believe that the application uses JET for
database connectivity.
I've read that somehow I can accomplish this by using the hidden table
tableDef or something like that. Can someone explain please?
Thanks in advance.