Results 1 to 4 of 4
  1. #1
    postiekiddo is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    4

    No permissions after security was setup


    Hi There

    Well I am not sure where to start with this, I am using access 2007 and last night i was playing with the security settings and ended up with a couple of extra files on my desktop, I realised these files were not what I wanted and went ahead and deleted them, it was only after this that I realised that I actually did need them as now when I open my DB I get the terrible msg 'you dont have permission to run switchboard' .... OK so I tried to open the DB using the shift key and this got rid of the switchboard msg, however when I try to access the tables I get 'could not read definitions, no read definitions permission for table or query'

    I am not sure how I can go about restoring this DB to 'not' use the permissions'

    Any ideas?

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209

    No permissions after security was setup

    Try re-installing MS-Office2007

  3. #3
    postiekiddo is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    4

    No permissions after security was setup

    I have tried the database on another computer and it does the same thing. I am wondering if there is anything in the source code I could change to fix the problem.

    Any ideas?

  4. #4
    postiekiddo is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    4

    No permissions after security was setup

    SOLVED!

    Seems MS automatically creates a backup, I restored this and all is well

    Cheers!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Best way to setup
    By griz47 in forum Access
    Replies: 5
    Last Post: 05-17-2011, 12:59 AM
  2. Setup
    By aisza in forum Database Design
    Replies: 6
    Last Post: 05-09-2011, 03:43 PM
  3. Permissions
    By helpaccess in forum Access
    Replies: 2
    Last Post: 04-22-2011, 03:33 PM
  4. Permissions Issue
    By softspoken in forum Access
    Replies: 2
    Last Post: 04-30-2010, 09:36 AM
  5. Permissions
    By emccalment in forum Forms
    Replies: 12
    Last Post: 02-17-2010, 04:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums