quote:

---

Creating table(s)...
CREATE TABLE ADS_CONTENT( ID int IDENTITY (1, 1) NOT NULL , TOPIC_ID int NOT NULL , NAME varchar(75) NULL , EMAIL varchar(50) NOT NULL , DATE_POSTED text (20) NOT NULL , PRICE varchar(20) NULL , AD_TITLE varchar(100) NOT NULL , CONTENT memo NOT NULL , ADDRESS varchar(100) NULL , CITY varchar(50) NOT NULL , STATE varchar(20) NOT NULL , ZIP varchar(12) NULL , LINK varchar(100) NULL , IMAGE_URL varchar(75) NULL , ADDED_BY int NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE ADS_CATEGORY( ID int IDENTITY (1, 1) NOT NULL , CATEGORY_NAME varchar(50) NOT NULL , DESCRIPTION memo NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Antiques', 'Coins, Furniture, Instruments, Collectibles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Computers', 'Accessories, Desktop, Laptop, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Real Estate', 'Apartments, Condos, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Automobiles', 'Cars, Imports, Motocycles, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Wanted', 'Merchandise, Services, more...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO ADS_CATEGORY (category_name, description) VALUES ('Relationships', 'Man seeking Woman, Woman seeking man, etc...')
-2147217865 | [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table 'ADS_CATEGORY'.

---