Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

passthru query question

melliemellie Member Posts: 2
Greetings,

I have a database that was recently upsized to SQL 7. The front end is still in Access 2000. All of the tables are linked. However for optimizing speed, etc. I am trying to convert some of the queries to passthru queries. Problem is, there is one linked table from another database that is on the same server that the queries call from so I get an error in the passthru query saying it can't find the table. Is there any way around this? Thanks.

SELECT people.FirstName, people.LastName, people.Address, people.City, people.State, people.Zip, Pledge.PledgeDate, Pledge.PledgeType, Pledge.PledgeAmount
FROM Pledge INNER JOIN people ON Pledge.PeopleID = people.PeopleID;

People is the table that is linked. Is there ANY way to call this table from another database in a passthru query? Thanks for your help.

P.S. There are two other databases that also have this 'people' table linked.

Comments

  • melissa_may1melissa_may1 Member Posts: 937
    I'm a little confused. Is the linked database also on SQL? On another server?

    If it is on another SQL server, there is a SQL function to link databases.

    If not in SQL, can you import it into SQL, or does it change too often for that to be practical?


    [purple]Melissa[/purple]

  • Chris BrownChris Brown USAMember Posts: 4,496 ✭✭

    _________ // http://forcoder.org // free ebooks and video tutorials about ( Visual Basic .NET, JavaScript, Perl, Python, C, Delphi, Ruby, Java, C++, Visual Basic, Go, PL/SQL, Objective-C, MATLAB, Assembly, PHP, C#, Scratch, R, Swift FoxPro, Apex, Clojure, SAS, Alice, Rust, D, F#, Hack, Scheme, Julia, Lisp, VBScript, ML, LabVIEW, Fortran, Dart, Ada, Logo, COBOL, Crystal, Erlang, Lua, ABAP, Bash, Scala, Prolog, Awk, Kotlin, Transact-SQL ) _____________

Sign In or Register to comment.