Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem using parameters and Alter Table together?

Status
Not open for further replies.

protagonist

Programmer
Jul 2, 2004
6
IE
I'm using access 2000, and I have,for instance, the following simple query:

PARAMETERS name TEXT(30);

ALTER TABLE Table1
ADD COLUMN game TEXT(30);

Now, without the parameter bit, the alter table section works fine. I add in the parameter (which does nothing, you'll notice) and it won't work. I get the "Invalid SQL statement. Expected "Delete" etc." error.

Anybody got any idea's?
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top