473,699 Members | 2,562 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Queries from Access

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
Mar 17 '07 #1
20 1070
"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)...?
Mar 18 '07 #2
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)...?
Mar 19 '07 #3
"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...?
Mar 19 '07 #4
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...?
Mar 19 '07 #5
"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...?
Mar 19 '07 #6
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...?
Mar 19 '07 #7
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...?

Mar 19 '07 #8
"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...?
Mar 19 '07 #9
"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?
???
Mar 19 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
6771
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:
4
2021
by: dschl | last post by:
Hi, I'm converting an Access 2000 database to Sql Server and must be missing something obvious. Using the Import utility in Sql Server, the Access queries seem to get executed and the resultant data imported as tables. Oops! Using the Upsize lizard in Access 2003, the queries aren't even in the selection list of "tables" to upsize. It looks like the Upsize wizard
4
1857
by: R | last post by:
Hi When an Access query is run against an ODBC table, is it possible in any way to tell what is passed to the server? I have a remote Sybase database linked into Access and the bandwidth is terrible, so I need the processing to be done purely on the server. Some simple queries run quickly, so the processing is being done on the server. Some complex queries with IIf statements etc. are definately not being converted to Sybase compatible...
5
4038
by: Jerry Hull | last post by:
I'm working with a database developed by an untrained person over several years - and on a network that has recently been upgraded with a new server installed and MS office upgraded from 2K (I think - it might have been XP) to 2003. The database is impressive, both in what it does and the obtuse and inconsistent ways it works. There are several hundred queries, for example, with no indication of where they are used or if they are in fact...
5
6322
by: marshmallowww | last post by:
I have an Access 2000 mde application which uses ADO and pass through queries to communicate with SQL Server 7, 2000 or 2005. Some of my customers, especially those with SQL Server 2005, have had pass-through queries fail due to intermittent connection failures. I can easily restablish a connection for ADO. My problem is with pass-through queries.
0
8705
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9054
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8941
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8896
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7784
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4390
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4637
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2362
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.