Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Access & ASP Question (I Know, But I really need help!)

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-13 : 08:05:23
Jimmy writes "SQLTeam-

Y'all are great, and I've learned alot from your input a 4guys. Anyway, my question...

I am trying to create a table in an Access2000 database from my ASP page. I have actually gotten it to work with the following SQL statement

CREATE TABLE myTable (
[myTableID] integer,
[relationalID] integer,
[myName] text(50),
CONSTRAINT [Index1] PRIMARY KEY ([myTableID]));

The problem is that the newly created table's primary key is of type Number, when I need it to be AutoNumber. Any ideas?

Thanks for you time.

-Jimmy"
   

- Advertisement -