Select Into works, Create table does not

[Sd]

Hi

We are migrating from Access to SQL server. The code is in VB and uses
DAO3.6. I have successfully made the connection to the databases on
the SQL server and done operations with recordsets. I have also used a
SELECT INTO command to create new tables. However CREATE TABLE and
ALTER TABLE commands do not work.

Any ideas?

The DBA says we have owner privileges on the databases and therefore
should be able to do what we like.

Many thanks

Si

[Erland Sommarskog]

Sd (sd*********@hotmail.com) writes:

We are migrating from Access to SQL server. The code is in VB and uses
DAO3.6. I have successfully made the connection to the databases on
the SQL server and done operations with recordsets. I have also used a
SELECT INTO command to create new tables. However CREATE TABLE and
ALTER TABLE commands do not work.

What does "not work" mean? They are on holiday and are to be expected back
after New Year?

Seriously, please include error messages or whatever symptoms you get that
make you think that they don't work. We can't guess what is happening on
your system.

As for DAO, this is old technology, and maybe you should consider moving
to ADO. (Then again, ADO is also gaining some age, and I can't say that I
like ADO. About DAO I know nothing.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp