> -----Original Message-----

> This is a VB problem you are having? Or an ASP problem?



Erm... not really a VB question - but a question of database programming

with the Jet providers 4.0 and 3.51

is this the correct mailing list? sorry if its not...



I have solved the problem of 4.0 not liking my SQL string...



Basically the Statement part



"Items.Module = modules.id"



upset Jet4.0



By putting quotes around the Items.`Module`   part allows Jet to see

"module" as a field name and not something else...



Question: Why does Jet4.0 not like my field name "module" and what is it

doing?



Thanks,

Phil.

There are certain reserved words in Jet.  Module is one of them (since MS

Access files can have modules).  When you use a reserved word without

delimiting it in some way (i.e., putting it in ' '  or [ ]), the Jet

database assumes you're talking about an actual Module.



-Stephen



> -----Original Message-----

> From: Philip.Ware 

> Sent: Friday, June 16, 2000 6:58 AM

> To: ASP Databases

> Subject: [asp_databases] Re: Databases Jet4.0 and Jet3.51

> 

> 

> > -----Original Message-----

> > This is a VB problem you are having? Or an ASP problem?

> 

> Erm... not really a VB question - but a question of database 

> programming

> with the Jet providers 4.0 and 3.51

> is this the correct mailing list? sorry if its not...

> 

> I have solved the problem of 4.0 not liking my SQL string...

> 

> Basically the Statement part

> 

> "Items.Module = modules.id"

> 

> upset Jet4.0

> 

> By putting quotes around the Items.`Module`   part allows Jet to see

> "module" as a field name and not something else...

> 

> Question: Why does Jet4.0 not like my field name "module" and 

> what is it

> doing?

> 

> Thanks,

> Phil.

>