Hello,
I have an ASP that should get data from 2 tables located in 2 mdb files.
Is it possible to create a liked table in one of them so I will need to open
only one connection?
If yes, how?
Thanks
I don't know if the tables will be liked, but it should be possible.
What happened when you tried?
Bob Lehmann
"Rami"
news:05F69CD1-33D1-480F-9941-18BF531631C8@microsoft.com...
> Hello,
>
> I have an ASP that should get data from 2 tables located in 2 mdb files.
> Is it possible to create a liked table in one of them so I will need to
open
> only one connection?
>
> If yes, how?
>
> Thanks
>
Executing:
rs1.Open sql, conn1, 3, 3
I get:
'C:\Menahel4\AccessApp\products.mdb' is not a valid path. Make sure that the
path name is spelled correctly and that you are connected to the server on
which the file resides.
This path is the local path of the linked table.
"Bob Lehmann" wrote:
> I don't know if the tables will be liked, but it should be possible.
>
> What happened when you tried?
>
> Bob Lehmann
>
> "Rami"
> news:05F69CD1-33D1-480F-9941-18BF531631C8@microsoft.com...
> > Hello,
> >
> > I have an ASP that should get data from 2 tables located in 2 mdb files.
> > Is it possible to create a liked table in one of them so I will need to
> open
> > only one connection?
> >
> > If yes, how?
> >
> > Thanks
> >
>
>
>
Both DBs need to be in the same file path. Is that the case?
Bob Lehmann
"Rami"
news:64E7B901-2EC1-4591-B76D-E8C3AFFFF588@microsoft.com...
> Executing:
> rs1.Open sql, conn1, 3, 3
>
> I get:
>
> 'C:\Menahel4\AccessApp\products.mdb' is not a valid path. Make sure that
the
> path name is spelled correctly and that you are connected to the server on
> which the file resides.
>
> This path is the local path of the linked table.
>
>
> "Bob Lehmann" wrote:
>
> > I don't know if the tables will be liked, but it should be possible.
> >
> > What happened when you tried?
> >
> > Bob Lehmann
> >
> > "Rami"
> > news:05F69CD1-33D1-480F-9941-18BF531631C8@microsoft.com...
> > > Hello,
> > >
> > > I have an ASP that should get data from 2 tables located in 2 mdb
files.
> > > Is it possible to create a liked table in one of them so I will need
to
> > open
> > > only one connection?
> > >
> > > If yes, how?
> > >
> > > Thanks
> > >
> >
> >
> >
Yes, but the path I use locally is not the same as the server path, where I
use Server.MapPath
"Bob Lehmann" wrote:
> Both DBs need to be in the same file path. Is that the case?
>
> Bob Lehmann
>
> "Rami"
> news:64E7B901-2EC1-4591-B76D-E8C3AFFFF588@microsoft.com...
> > Executing:
> > rs1.Open sql, conn1, 3, 3
> >
> > I get:
> >
> > 'C:\Menahel4\AccessApp\products.mdb' is not a valid path. Make sure that
> the
> > path name is spelled correctly and that you are connected to the server on
> > which the file resides.
> >
> > This path is the local path of the linked table.
> >
> >
> > "Bob Lehmann" wrote:
> >
> > > I don't know if the tables will be liked, but it should be possible.
> > >
> > > What happened when you tried?
> > >
> > > Bob Lehmann
> > >
> > > "Rami"
> > > news:05F69CD1-33D1-480F-9941-18BF531631C8@microsoft.com...
> > > > Hello,
> > > >
> > > > I have an ASP that should get data from 2 tables located in 2 mdb
> files.
> > > > Is it possible to create a liked table in one of them so I will need
> to
> > > open
> > > > only one connection?
> > > >
> > > > If yes, how?
> > > >
> > > > Thanks
> > > >
> > >
> > >
> > >
>
>
>
<<
I have an ASP that should get data from 2 tables located in 2 mdb files.
Is it possible to create a liked table in one of them so I will need to
open
only one connection?
If yes, how?
>>
Perhaps something here may be helpful:
http://www.sitepoint.com/forums/showthread.php?t=101500
Forums » Program Your Site » ASP » Populate 1 Array with 2 Queries?
http://www.sitepoint.com/forums/showthread.php?t=178119
Forums » Program Your Site » ASP » linking 2 sep db's
Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
It seems Iâm on the way but,
Executing:
"SELECT OrdLines.*, Products.* FROM Products IN 'd:\mydbpath\products.mdb'
RIGHT JOIN OrdLines ON Products.pcode = OrdLines.ProdCode WHERE
(((OrdLines.OrdNum)=9001414)) ORDER BY Products.g1, OrdLines.Product; "
Gives:
Syntax error in FROM clause.
"Bullschmidt" wrote:
> <<
> I have an ASP that should get data from 2 tables located in 2 mdb files.
> Is it possible to create a liked table in one of them so I will need to
> open
> only one connection?
>
> If yes, how?
> >>
>
> Perhaps something here may be helpful:
>
> http://www.sitepoint.com/forums/showthread.php?t=101500
> Forums ; Program Your Site ; ASP ; Populate 1 Array with 2 Queries?
>
> http://www.sitepoint.com/forums/showthread.php?t=178119
> Forums ; Program Your Site ; ASP ; linking 2 sep db's
>
> Best regards,
> J. Paul Schmidt, Freelance ASP Web Developer
> http://www.Bullschmidt.com
> ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>