Error create table

[Guest_imported]

I have this error when executing the statement:
Microsoft VBScript runtime error '800a01a8'
Object required: ''

My code (extract):
strQuery="Create Table tbl_" & PartGroupName & " (General_Information varchar(50), Released_Part_Number varchar(50))"
Response.Write strQuery
objRS.Open strQuery, objConn

 

[snowboardr]

Can you show more code? Either objRS, or objConn is not set above... www.vzio.com
ASP WEB DEVELOPMENT

 

[HowardMarks]

Hi, this should work:

strQuery="Create Table tbl_" & PartGroupName & " (General_Information varchar(50), Released_Part_Number varchar(50))"
Response.Write strQuery
objConn.Execute strQuery

Nick (Web Developer)

http://www.retrographics.co.uk

nick@retrographics.co.uk

 

[Guest_imported]

Thanks, I had forgotten to put my include file 'ConnectToDB' at the beginning