ACCESS QUERY WINDOW

[100dtl]

How come if i run a query thus:

alter table products add COLUMN boxnumber text(25)

in the access query window it works but if i run the same query from a ASP page ie:

conn.execute("alter table products add COLUMN boxnumber text(25)&quot it dont work?

 

[Darrylles]

Hi,

Try a ; immediately before the last quote.

Otherwise - don't know.

Why not create a named query, and execute that?

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[100dtl]

A named query? how do you mean