Re: Link table alternative

From: MGFoster (me_at_privacy.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 20:18:08 GMT

Post your query's SQL statement. Maybe something there we can analyze. 

-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
B Nieds wrote:
> Hi:
> 
> I am using Access to report on data maintained outside of Access. I have
> created links to the ourside files and have then created Queries, Forms, and
> Reports using these links. All of that is working reasonably ok.
> 
> The problem I encounter is when I need to get more complex. Access will then
> complain that the linked table is in use (or opened exclusively) by another
> user. I tested with a copy of the files locally on my computer with the same
> results. Example is a subquery use the same table as the main query.
> 
> Is this a limitation of linked tables? Is there a workaround or alternative
> method for getting the data? I know I can import the data but seems to
> defeat the purpose of linked tables.

Relevant Pages

  • Link table alternative
    ... I am using Access to report on data maintained outside of Access. ... created links to the ourside files and have then created Queries, Forms, and ... complain that the linked table is in use by another ...
    (microsoft.public.access.queries)
  • Re: Jerry Porter deal?
    ... starters lets start with the news i gotta report. ... So i called my cousin in Oakland ... a WR they had there hopes set on Jerry Porter. ...
    (alt.sports.football.pro.ne-patriots)
  • Re: Andrew Prock, guess what
    ... report you. ... You'll have only yourself to blame. ... Patti Beadles, Oakland, CA | ...
    (rec.gambling.poker)
  • Re: catpuring data
    ... >Won't this make the user enter the dates twice? ... >when the query is run and then again when the report is ... >>On the report create a TextBox. ... >>Oakland, CA ...
    (microsoft.public.access.queries)
  • Re: Day number to day name
    ... IS there a way to do this in a report?? ... I know its easy to do in vba, but i ask criteria in my report and each time a run it it give me a bug...... ... Oakland, CA. ...
    (comp.databases.ms-access)