I am running Advance server 2000

Installed is

sv pack 2 for win 2000

MDAC ver 2.5

Do I need service pack 5 for Visual Studio ??



When I download the demo database from wrox that is in Access 97 and 

convert it to Access 2000 and follow the book (beginning ASP DB sailors ) 

all works fine and dandy. 



When I  make my own test d-base I get the error   0x80040E14 and it refers 

to my SQL statement near the word "FROM" this is in a   SQL querry in a 

ASP call.



I used the same worx page that called the fist DB, changed the DSN, 

datebase name and table to call.



Is there some versioning or update that I do not have installed or is it a 

permission issue?? 

Have a look at www.adopenstatic.com/faq/80040e14.asp

which covers a lot of common causes of this type of error.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: <lakefront21k@a...>

To: "ASP Databases" <asp_databases@p...>

Sent: Monday, June 18, 2001 10:37 PM

Subject: [asp_databases] error 0x80040E14 more that a syntex error??





: I am running Advance server 2000

: Installed is

: sv pack 2 for win 2000

: MDAC ver 2.5

: Do I need service pack 5 for Visual Studio ??

:

: When I download the demo database from wrox that is in Access 97 and

: convert it to Access 2000 and follow the book (beginning ASP DB sailors )

: all works fine and dandy.

:

: When I  make my own test d-base I get the error   0x80040E14 and it refers

: to my SQL statement near the word "FROM" this is in a   SQL querry in a

: ASP call.

:

: I used the same worx page that called the fist DB, changed the DSN,

: datebase name and table to call.

:

: Is there some versioning or update that I do not have installed or is it a

: permission issue??