SQL Access Questions

1

ASP Web page database?
I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it’s good still with access. (I Know basically  ”everything” is SQL but please give [...]

Answer Question   |  August 18, 2010  5:17 PM
ASP.NET, ASP.NET Web applications, SQL Access, SQL Database, SQL Developer
asked by:
20 pts.

ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT
I tried example 6 from the book SQL for Microsoft Access and got the error message” CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys (ToyID, [...]

Answer Question   |  June 8, 2010  5:33 PM
Access errors, Microsoft Access, SQL, SQL Access
asked by:
5 pts.

SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word “Udate”     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]

Answer Question   |  February 16, 2010  11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query
asked by:
1,185 pts.

1