Query Two Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a Query In Access where i Query 2 databases on seperate .mdb
files this works fine, however when i publish it to the web i get the trusty
old yellow error showing up again. I link between two tables in the first mdb
file and also link to another table in the other mdb file.

The query is as follows.

SELECT ScannerIDs.ScannerID, ScannerIDs.OurID, Results1.Location,
Results1.TSinfo, Results.Fail
FROM (Results INNER JOIN ScannerIDs ON Results.ScannerID=ScannerIDs.OurID)
INNER JOIN Results1 ON ScannerIDs.OurID=Results1.Drive_ID
WHERE ((Results1.Location)="Sent To Vendor");

If i open the published mdb file with the query the results are fine,
setting up the results through FP is fine, but the published page doesn't
work.

This is not essential but is a nice to have, and if i do have it it has to
be available on the web.

Thanks in advance.


Al....

Any suggestions would be appreciated
 
Both databases are local to the same web?

Did you reestablish the link on the net servers?
 
Both databases are in the same folder in the same web.

As for reestablishing the link on the net servers, all i have done is check
that it works if i open the published file. So i havent reestablished the
link because i never knew i needed one.

The wesite is published to My PC within InetPub using FP2003, is it possible
for me to do this link, and if so how do i go about doing it.

The joys of being a Novice.

Thanks

Al....
 
On the live/remote server from within FP, run Tools | Web / Site Setting | Database and verify your
connection(s).

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Unfortunately i've done that already, all databases are in there and verified.

I did however change to debug mode and got the following error

Database Results Wizard Error
Description: The Microsoft Jet database engine cannot open the file
'C:\Documents and Settings\sproul\My Documents\My Web
Sites\TestEng\fpdb\ScanIn.mdb'. It is already opened exclusively by another
user, or you need permission to view its data.
Number: -2147467259 (0x80004005)
Source: Microsoft JET Database Engine

it looks as though the link is to the database on the pre published website,
i did delete it and re-do it on the Published site, i'll do it again and see
if it still gives the same error.

I'll get back to you tomorrow.

Thanks Al....
 
To test are you accessing the site/page via http:// and a .asp page ?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Sorry Thomas i must appologise i have redone the link within the published
file and it's working.
I did do this before and then transfer back to the Pre-published folder, i
can only assume that it changes the location of where it looks for the file
when transfered back, and keeps it when republished, if you understand what i
just said (i find it hard to follow myself).

I'll try it again later, once again i'm sorry for wasting your valuable time

Al....
 
Yes to view the data i am accessing the site/page via http:// and a .asp page.

I've had a play about this morning and it seems that as long as i setup the
linked databases on the actual published website it works fine, i'm sure i
tried this yesterday but it's going fine now. So it means if i open in access
and change any data i'm going to have to re link it after i republish it.

Thanks for your input, Sorry for wasting your valuable time.

Al....
 
Back
Top