PC Review


Reply
Thread Tools Rate Thread

Microsoft jet error only from some desktops

 
 
Jesse Gomes
Guest
Posts: n/a
 
      6th Aug 2003
I am getting this error
"The Microsoft jet database engine could not execute the
SQL Statement because it contains a field that has an
invalid data type."

version:Access 97 sr-2

this report used to work on all computer but now it gives
error on win 98 desktops.

It works fine on mine ( Win NT 4).

 
Reply With Quote
 
 
 
 
SA
Guest
Posts: n/a
 
      7th Aug 2003
Jessie:

1.) are you postive that all machines have SP 2 installed?
2.) Not withstanding that, that error can occur if you are doing a join, or
some calculation on field that may return a null. Work around this by
looking at your underlying data, and or using the NZ function in the
potentially effected field, specifying a default value if null. Note that
you may also have to wrap the call to NZ with a numeric conversion function
like
CCur(NZ(MyField,0)) to return a number in a query rather than text string
for a field that may contain a null.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Jesse Gomes" <(E-Mail Removed)> wrote in message
news:02b301c35c54$520e4120$(E-Mail Removed)...
> I am getting this error
> "The Microsoft jet database engine could not execute the
> SQL Statement because it contains a field that has an
> invalid data type."
>
> version:Access 97 sr-2
>
> this report used to work on all computer but now it gives
> error on win 98 desktops.
>
> It works fine on mine ( Win NT 4).
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 desktops, but want e-mail to go to both desktops, not just one. =?Utf-8?B?V0xKT05FUzU5?= Microsoft Outlook Discussion 2 25th Oct 2006 01:50 AM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer Microsoft ASP .NET 0 30th Mar 2006 04:16 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer Microsoft ASP .NET 1 24th Mar 2006 05:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer Microsoft ASP .NET 0 24th Mar 2006 03:22 PM
Jet 3.51 to Jet 4.0 graham Microsoft VB .NET 2 13th Jul 2004 12:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:54 PM.