Using Ddl To Create Sql Server Table

[jaydwest]

I'm trying to create a SQL Server Table (SQL Server 2000) from MSAccess. Here's my Code:

mySQL = "CREATE TABLE tbl_Test_
& "(Code varchar(255), " _
& PartNumb_1 varchar(50)," _
& Price_1 money , " _
& MSRP_1 money, " _
& Avail_1 varchar(5) ) "

Set cmd = MakeStoredProc(cnn, "sp_executesql")
Set prmStatement = cmd.CreateParameter("@Statement", adVarWChar, adParamInput, 4000, mySQL)
cmd.Parameters.Append prmStatement
cmd.Execute
DoEvents

This works great in MS Access 2000 on my development system, but not on my client's Access2002 system. I get a type mismatch Error Message on my client's system when set prmStatement line is executed.

Does anyone have any suggestions for trouble shooting this?

Thanks in advance.