Pass-Through Query

[jarett]

Could someone recommend a good link to read up on pass-through queries. I am trying to replicate an old database and the original author has some pass-throughs in it, when I tried to incorporate them in my DB it didn't work like I thought, so just searching for a good read on the use of them.

 

[jackd]

You haven't told us what the BE software is Access, SQLServer. Oracle??? You have to ensure you are using the correct "SQL Dialog" for whatever BE you have.

Link for Access-->Oracle

PassThrough query Access->SQLServer

You may get some insight from this link.
Or this link/ older tutorial

Google/Bing and Youtube may get your best sources.
Good luck.

 

[jarett]

You haven't told us what the BE software is Access, SQLServer. Oracle??? You have to ensure you are using the correct "SQL Dialog" for whatever BE you have.

Link for Access-->Oracle

PassThrough query Access->SQLServer

You may get some insight from this link.
Or this link/ older tutorial

Google/Bing and Youtube may get your best sources.
Good luck.

What is BE software? I am using Access for my DB.

 

[jackd]

BE === Backend.
If you have an Access frontend(FE) and Access Backend(BE) why do you need pass through query?

Multiuser Access databases are also known as split databases. The BE resides on a server and each user has a copy of the Frontend on his/her PC.
Backend contains Tables. Frontend contains queries,forms, macros, reports. Front end is linked to the BackEnd.

Details from FMS here.

 

[jarett]

BE === Backend.
If you have an Access frontend(FE) and Access Backend(BE) why do you need pass through query?

Multiuser Access databases are also known as split databases. The BE resides on a server and each user has a copy of the Frontend on his/her PC.
Backend contains Tables. Frontend contains queries,forms, macros, reports. Front end is linked to the BackEnd.

Details from FMS here.

I would say it is a FE then, our software package has 100's of tables within itself and we just use Access to pull information out (easier than trying to use the host software).

 

[jackd]

???our software package has 100's of tables within itself??
You should know what this software package is before attempting to modify data stored within it.

Perhaps you could tell readers more bout the exiting database, its purpose and why you need to replicate it.

 

[Micron]

If you have an Access frontend(FE) and Access Backend(BE) why do you need pass through query?

It's not unusual to have a mix of Access tables and for example, Oracle connections in the same be IMO. A pass through might make sense on the ODBC tables. The app tables might even be read only which means the records can't be altered, but for sure one needs to be careful about knowing what they are playing with.

 

[jarett]

???our software package has 100's of tables within itself??
You should know what this software package is before attempting to modify data stored within it.

Perhaps you could tell readers more bout the exiting database, its purpose and why you need to replicate it.

I didn't know what the etiquette was on that type of information, we use Sage 100 and Sage is horrible at exporting data using the actual Sage functions. So we are forced to import/link the tables (only the ones we need) into access and run queries to produce the result's we need.