Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010

    Unanswered: Linking in a Query from a hyperlinked database

    Not even sure if this possible. I am working in eRoom and have two different databases. Database 1 captures all reports with a unique report id. Database 2 has a field in a form that is based off of the report id in Database 1. This is captured in a query doing a SELECT [Database 1].[Report_ID] FROM [Database 1] IN "location". I am able to do this on my hard drive, but can't figure out a way to do it when the location of the other database is on a website.

    Is there a way to do this?

  2. #2
    Join Date
    May 2010
    Is the other database on the web site is a Jet/ACE (Access) then short answer is: You can't.
    Boyd Trimmell aka HiTechCoach (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts