Query fails for only one user

D

Doug Starkey

I have inherited an Access database that was, until recently,
functioning normally. I'm still fairly new to Access, so forgive me if
my questions seem naive.

The primary user of the database is now having the database fail on a
query.

The query is on an external table.

Any other user is able to run the query without issue.

I've tried looking at file privileges in Active Directory & local
settings. I'm not finding any difference for this user.

I'm stumped as to where to look.

Is there some sort of error log I should be checking?

What other options do I have for trying to trace this down?

TIA,
 
J

Jerry Whittle

Fails? In what way?

Is the database split into a front end and back end with each user having a
copy of the FE? If so relink that user's FE to the tables in the BE.
 
D

Doug Starkey

The query generates a dialog box:
Action Failed
Macro Name: SalesReports.OpenSalesReport
Condition: True
Action Name: OpenQuery
Arguments: FXFERMktbl_qry, Datasheet, Edit

Three buttons on the dialog box: Step, Halt, and Continue. Only "Halt"
is usable; the others are grayed out.

No "back-end" as such although, as I mentioned, the database does link
to an external data source. All users are using the same copy of the
database... just not simultaneously.

Does that clarify things? Any further suggestions?

Thanks!

-Doug
 
Top