Queries from Access

[=?Utf-8?B?SmFtZXM=?=]

Hello all

I am having a odd problem, I have a page that lists users (GridView), this
list links through to another page when you click on the name. The second
page lists all phone calls they received during the previous month
(GridView). I have done this by a Querystring passing SupportId from the
first to the second page.

The second page GridView data source is based on an SQL statement:
"WHERE (supportid = ?) AND
((Right(Left([datetaken],8),5))=Right(D ateAdd("m",-1,Date()),5))"

the [datetaken] field is the date and time the call was received.

This works fine on my computer running it under a local host. However, when
I copy it to my IIS server V6, it does not show any records on the second
page.

Everything else works fine, the list on the first page works ok, even the
second page loads fine but it says No Calls.

Does anyone have a clue why? I have tried almost everything I can think off
but nothing makes a difference.
Many thanks in advance

James

[Mark Rae]

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:20******** *************** ***********@mic rosoft.com...

Does anyone have a clue why? I have tried almost everything I can think
off
but nothing makes a difference.

It might be helpful if you

a) posted your code

b) told the group what you've already tried

c) posted any error message / EventLog entry you're getting.

Presumably, the account that your site is running under has read-write
permissions not only on the Jet database itself but also on the folder where
the Jet database resides so that it can create the associated locking
database (*.ldw)...?

[=?Utf-8?B?SmFtZXM=?=]

Hello,

I did post my code, "WHERE (supportid = ?) AND
((Right(Left([datetaken],8),5))=Right(D ateAdd("m",-1,Date()),5))"

That is the SQL part of the select statement. The rest is just

SELECT supportid, datetaken, [number], firstname, lastname FROM memberlist

I also said that I do not get any error messages, it just says that there
are 0 records.

As the first page works fine, (that is just based on a simple SELECT from a
table) I am assuming there is no problem with the connection or Read Write to
the database. I have checked this anyway.

I have set the folder to full read write permissions for everyone just to
test it and it still does not work, including the internet guest account.
However I do notice that the lock file is not appearing.

Other than that I am stumped as to what to look for.

Any ideas would be great.

James

"Mark Rae" wrote:

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:20******** *************** ***********@mic rosoft.com...

Does anyone have a clue why? I have tried almost everything I can think
off
but nothing makes a difference.

It might be helpful if you

a) posted your code

b) told the group what you've already tried

c) posted any error message / EventLog entry you're getting.

Presumably, the account that your site is running under has read-write
permissions not only on the Jet database itself but also on the folder where
the Jet database resides so that it can create the associated locking
database (*.ldw)...?

[Mark Rae]

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:7C******** *************** ***********@mic rosoft.com...

I did post my code, "WHERE (supportid = ?) AND
((Right(Left([datetaken],8),5))=Right(D ateAdd("m",-1,Date()),5))"

That is the SQL part of the select statement. The rest is just

SELECT supportid, datetaken, [number], firstname, lastname FROM memberlist

Well, that's your SQL statement certainly...

I also said that I do not get any error messages

Actually, you didn't, but no matter...

As the first page works fine, (that is just based on a simple SELECT from
a
table) I am assuming there is no problem with the connection or Read Write
to
the database. I have checked this anyway.

OK.

However I do notice that the lock file is not appearing.

Ah... Well, it's been a while since I did any Jet database work but I've
never known a situation when the corresponding ldb file isn't created,
especially on a network share... If you interrogate the file properties of
the Jet database itself, is its Accessed date being updated every time it is
queried...?

[=?Utf-8?B?SmFtZXM=?=]

Hi

No the last accessed date does not change. So I thought maybe my link was
wrong so I changed the name of the Db and it came up with an error message it
could not find it so I know its looking at the right one.

Just why does it work for one page but not the other?

"Mark Rae" wrote:

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:7C******** *************** ***********@mic rosoft.com...

I did post my code, "WHERE (supportid = ?) AND
((Right(Left([datetaken],8),5))=Right(D ateAdd("m",-1,Date()),5))"

That is the SQL part of the select statement. The rest is just

SELECT supportid, datetaken, [number], firstname, lastname FROM memberlist

Well, that's your SQL statement certainly...

I also said that I do not get any error messages

Actually, you didn't, but no matter...

As the first page works fine, (that is just based on a simple SELECT from
a
table) I am assuming there is no problem with the connection or Read Write
to
the database. I have checked this anyway.

OK.

However I do notice that the lock file is not appearing.

Ah... Well, it's been a while since I did any Jet database work but I've
never known a situation when the corresponding ldb file isn't created,
especially on a network share... If you interrogate the file properties of
the Jet database itself, is its Accessed date being updated every time it is
queried...?

[Mark Rae]

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:19******** *************** ***********@mic rosoft.com...

No the last accessed date does not change. So I thought maybe my link was
wrong so I changed the name of the Db and it came up with an error message
it
could not find it so I know its looking at the right one.

Every time a Jet database is queried, its Last Accessed date will definitely
change - I can't think of any situation where this wouldn't be the case...

Just why does it work for one page but not the other?

Could it be that the two pages are not in fact pointing at the same
database...? Different connection string, maybe...?

[=?Utf-8?B?SmFtZXM=?=]

Hi

Yes they are both accessing the same database, when I renamed the database
they both had errors saying they could not find it.

I also just deleted one of the names from the database and it dissapeard
from the first page where it lists the names in the table so it is.

I can't think why this is happening
"Mark Rae" wrote:

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:19******** *************** ***********@mic rosoft.com...

No the last accessed date does not change. So I thought maybe my link was
wrong so I changed the name of the Db and it came up with an error message
it
could not find it so I know its looking at the right one.

Every time a Jet database is queried, its Last Accessed date will definitely
change - I can't think of any situation where this wouldn't be the case...

Just why does it work for one page but not the other?

Could it be that the two pages are not in fact pointing at the same
database...? Different connection string, maybe...?

[=?Utf-8?B?SmFtZXM=?=]

Hi

Could it be something to do with the IIS server, do I have to install
anything before it can understand my where statement?

"James" wrote:

Hi

Yes they are both accessing the same database, when I renamed the database
they both had errors saying they could not find it.

I also just deleted one of the names from the database and it dissapeard
from the first page where it lists the names in the table so it is.

I can't think why this is happening
"Mark Rae" wrote:

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:19******** *************** ***********@mic rosoft.com...

No the last accessed date does not change. So I thought maybe my link was
wrong so I changed the name of the Db and it came up with an error message
it
could not find it so I know its looking at the right one.

Every time a Jet database is queried, its Last Accessed date will definitely
change - I can't think of any situation where this wouldn't be the case...

Just why does it work for one page but not the other?

Could it be that the two pages are not in fact pointing at the same
database...? Different connection string, maybe...?

[Mark Rae]

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:07******** *************** ***********@mic rosoft.com...

Yes they are both accessing the same database, when I renamed the database
they both had errors saying they could not find it.

I also just deleted one of the names from the database and it dissapeard
from the first page where it lists the names in the table so it is.

I can't think why this is happening

Me neither...

Are you able to query this database through any other means...? E.g. a full
copy of Access, or something like Excel which can query Jet databases (Get
External Data...)

If so, what happens if you run the query manually...?

[Mark Rae]

"James" <Ja***@discussi ons.microsoft.c omwrote in message
news:8B******** *************** ***********@mic rosoft.com...

Could it be something to do with the IIS server, do I have to install
anything before it can understand my where statement?

???