Run-time error '-2147467259(80004005)'

**Lloyd Blankfein** · 02-13-2013, 02:04 PM

Hi,

I wrote this function to read some data from an access database:

Please Login or Register  to view this content.

I like to read a db table, called Modelle, with this attributes: Index, ModelName, Datum, Signal, Performance.

Here I read the db:

Please Login or Register  to view this content.

The code throws this error:

Run-time error '-2147467259(80004005)':

Automation error
Unspecified error

By using the other sql command, that reads the whole table, there is no problem.

Does anybody know, what might be the reason?

Thank you very much!
Lloyd

**Norie** · 02-13-2013, 02:09 PM

Lloyd

Does the SQL work when you try it manually in Access?

**Lloyd Blankfein** · 02-14-2013, 05:33 AM

No!

It throws this error:

Compile error:

Expected: Case

**Norie** · 02-14-2013, 10:06 AM

Lloyd

Access wouldn't give you a compile error for an SQL statement.

What exactly did you try in ACCESS?

**Lloyd Blankfein** · 02-14-2013, 10:35 AM

I ran the sql command in the access vba editor Immediate window.

**romperstomper** · 02-14-2013, 10:38 AM

You can't run SQL commands directly in the VBEditor. You'd need to enter the SQL into a query.

**Norie** · 02-14-2013, 10:39 AM

It's an SQL query, not VBA.

Open the database you are trying to work with, create a new query, don't add any tables,
goto View>SQL..., paste the contents of the string SQL in that window and then click ! to run the query.

**Lloyd Blankfein** · 02-14-2013, 11:48 AM

OK, I did that.

Now there is a new error:

Reserved error (-3025); there is no message for this error

**Norie** · 02-14-2013, 11:57 AM

I don't recognise that error - I'll check it out, but I'm pretty sure it's connected to the SQL query no being right.

What is the SQL mean to do?

Does it's constituent parts work on their own?

**Lloyd Blankfein** · 02-14-2013, 12:36 PM

OK, I did that.

Now there is a new error:

Reserved error (-3025); there is no message for this error

**Norie** · 02-14-2013, 01:00 PM

Lloyd

About all I can find about the error is that it means the SQL isn't valid.

One quite common reason appeared to be that people were trying you use SQL from some other database and the syntax wasn't recognised by Access.

**Lloyd Blankfein** · 02-14-2013, 01:43 PM

Hmm..., I did not know that there are different database schemata for sql.
I thought all distributors use "standard" sql.

OK, so I will calculate the Median via vba excel, instad doing it inline sql.

Thank you very much, Norie!

**Norie** · 02-14-2013, 01:52 PM

There are quite a few different 'flavours' of SQL.

You can probably calculate the median in Access, if that's what you are trying to do, not sure how though.

Mind you Excel is better suited for that sort of thing.