CREATE TABLE with no columns

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Database Design / August 2005

CREATE TABLE with no columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

peregenem@jetemail.net - 16 Aug 2005 11:54 GMT

Anyone noticed this one?

CurrentProject.Connection.Execute _
"CREATE TABLE Oops;"

Set rs = _
CurrentProject.Connection.Execute _
("SELECT COUNT(*) FROM Oops;")

Reply to this Message

peregenem@jetemail.net - 16 Aug 2005 11:59 GMT

perege...@jetemail.net wrote:

> Set rs = _
> CurrentProject.Connection.Execute _
> ("SELECT COUNT(*) FROM Oops;")

A workaround for this (unusual) error:

Set rs = _
CurrentProject.Connection.OpenSchema(adSchemaStatistics)

rs.Filter = "TABLE_NAME = 'Oops'"

MsgBox rs.Fields("CARDINALITY").Value

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.