Fail to query from Access DB

[Shay Tavor]

Hi,
I'm trying to write a simple ASP page which retrieve data
from an Access DB. However, the recordset.open method
always fails, and I can't get anything, even though the
connection is open.
Any advises?
Shay

[Bob Barrows]

Shay Tavor wrote:

> Hi,
> I'm trying to write a simple ASP page which retrieve data
> from an Access DB. However, the recordset.open method
> always fails, and I can't get anything, even though the
> connection is open.
> Any advises?
> Shay

Hmm, my crystal ball seems to be defective today: I can't see any of your
code, or your error messages :-)

Seriously, how do you expect anyone to tell you what your problem is without
seeing your code. Strip it down to its barest essentials and show us what
you are doing.

Before you do that, however, go to [url]www.aspfaq.com[/url] and see if there is an
article that covers your problem. There's a pretty good Search function on
that site, so you should be able to find something. A Google search for the
keywords asp open recordset Access should get you some information as well,
especially if you include your error number as one of the keywords.

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Shay Tavor]

>-----Original Message-----
>Shay Tavor wrote:

>> Hi,
>> I'm trying to write a simple ASP page which retrieve

data

>> from an Access DB. However, the recordset.open method
>> always fails, and I can't get anything, even though the
>> connection is open.
>> Any advises?
>> Shay

>
>Hmm, my crystal ball seems to be defective today: I can't

see any of your

>code, or your error messages :-)
>
>Seriously, how do you expect anyone to tell you what your

problem is without

>seeing your code. Strip it down to its barest essentials

and show us what

>you are doing.
>
>Before you do that, however, go to [url]www.aspfaq.com[/url] and see

if there is an

>article that covers your problem. There's a pretty good

Search function on

>that site, so you should be able to find something. A

Google search for the

>keywords asp open recordset Access should get you some

information as well,

>especially if you include your error number as one of the

keywords.

>
>HTH,
>Bob Barrows
>
>--
>Microsoft MVP - ASP/ASP.NET
>Please reply to the newsgroup. This email account is my

spam trap so I

>don't check it very often. If you must reply off-line,

then remove the

>"NO SPAM"
>
>
>.
>OK, Bob, Thanks,

I'll do that...
Shay