By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,410 Members | 1,626 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,410 IT Pros & Developers. It's quick & easy.

Select Into works, Create table does not

P: n/a
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
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.