By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,983 Members | 2,035 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,983 IT Pros & Developers. It's quick & easy.

Table read permissions problem in Access 2007

P: n/a
I had a user that converted an application from Access 2003 to Access
2007. The application is split front-end/backj end. When trying to
open certain forms, the front end reportst that they don't have read
permissions on the table. Neverthess, it is possible to actually open
(and read the table directly while still in the front end.

We fixed the References (I think) and ran compact and repair on both
the front end and back end.

Any suggestions on what I could look at to track down/fix the error.
Sep 14 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jim Mandala wrote:
I had a user that converted an application from Access 2003 to Access
2007. The application is split front-end/backj end. When trying to
open certain forms, the front end reportst that they don't have read
permissions on the table. Neverthess, it is possible to actually open
(and read the table directly while still in the front end.

We fixed the References (I think) and ran compact and repair on both
the front end and back end.

Any suggestions on what I could look at to track down/fix the error.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Have you tried changing the permissions of the tables in Tools >
Security User And Group Permissions dialog? You have to log on as the
Administrator (Admin) to change permissions.

On the Dialog, under the Permissions tab, select Table in the Object
Type ComboBox. Highlight the table(s) that are giving you trouble.
Make sure all CheckBoxes in the Permissions section are checked. Then
click the OK button.

--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSM7+jIechKqOuFEgEQIqxQCeNjDzbzMTpZC+ujKifasrt6 7zcIQAn1Zy
BNRzc/evM3/I0gLUM1SWttlU
=ko/F
-----END PGP SIGNATURE-----
Sep 16 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.