Re: Cannot view results of query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 09:53:33 -0800

Hi, Scott.

> some users are not able to
> view the results of a query we created. One user can sit at a specific
PC,
> login to the database and view the results, but when another user performs
> the exact same task, the results are not shown.

This implies that the query runs, but only an hourglass is displayed. I
suspect instead that there is a specific error message when these users
attempt to run the query. What is the error message?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"scottshiller" <scottshiller@discussions.microsoft.com> wrote in message
news:5BBEA68E-6719-40F6-BD1A-1ECC0321480D@microsoft.com...
> All,
>
> We have created a shared Access 2003 database and some users are not able
to
> view the results of a query we created. One user can sit at a specific
PC,
> login to the database and view the results, but when another user performs
> the exact same task, the results are not shown.
>
> The DB is password-protected, but that does not seem to be the issue. The
> folder where the DB sits has the correct permissions. The network folks
> claim it is a DB problem, but the security settings are the same within
our
> DB and the folder in which it sits.
>
> Any ideas would be greatly appreciated! Please let me know if more
> informaiton is needed to describe this problem.
>
> Thank you!
>
> Scott
>

Relevant Pages

  • Re: More query questions re: keywords
    ... I left out a closing quote mark in the query after the word "Active". ... As far as your database problem, I am shooting in the dark. ... > & it gave me an error message that I needed. ... > table in Excel (to keep it free from any possible corruption) and imported it ...
    (microsoft.public.access.queries)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: Export Delimited
    ... Database or objects is read-only. ... T558c Table (this is the name of a query) ... My error message: The Microsoft Jet database engine could not find the ...
    (microsoft.public.access.externaldata)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)