Access 2003 - nonAdmins can't run Reports !!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was installing my Access 2003 on client machines and found everything
working normally on the development machine with full Admin rights. I
installed on a few client machines and found that any machine with full Admin
rights could run reports, but non-Admin machines couldn't.
I made a tiny db with a single field, single table, and a report based on
that (show me the values for that field). Again, the non-admin machine
couldn't run the report when I double-clicked on it while an admin machine
could. So it's not a programming error - there's no programming involved.
Is it an Access installation problem (and just a coincidence that it runs on
Admin machines only) or is it a setup problem (I couldn't find any setting to
disable reports) or is it an XP Pro problem (I'm not familiar with Policies,
etc)
Any help would be most appreciated.

jp
 
bigpalooka said:
I was installing my Access 2003 on client machines and found everything
working normally on the development machine with full Admin rights. I
installed on a few client machines and found that any machine with full
Admin
rights could run reports, but non-Admin machines couldn't.
Click to expand...

What is the error message? When you refer to 'Admin' are you talking about
the Windows user, or have you implemented User-level security in Access and
you're referring to members of the Admins Group?

If the former, do all users have modify permission (windows permission) on
the folder where the mdb is located? If you haven't, you should split the
mdb (backend only on the server), and give each user a copy of the frontend
on their computer.
 
The Admin account is Windows User Acct.

This was a red herring, though. The problem was that there was no Default
Printer configured. The two users with Admin accounts had default printers
set up - nobody else did.

jp
 
Back
Top