Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 17th, 2005, 09:02 AM
Registered User
 
Join Date: Oct 2005
Location: Chapel Hill, NC, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default You don't have permission

I have been given an Access database (2002) to modify. The application has been used for about 2 years but now needs modification. I used the Admin id and password to look at the database but cannot open any objects. Get 'You don't have permission to read '____'. I have tried using another ID, exporting the objects and copying the database. Get the same message. The owner of the database and each of the objects is listed as <unknown>. Help. - Thanks Len.
  #2 (permalink)  
Old October 17th, 2005, 09:10 AM
Authorized User
 
Join Date: Apr 2005
Location: , , USA.
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try going to the "modules" tab in you database window. Open a module and search for "password". You can usually find the database password in a module.

Hope this helps!

D. Bartelt
  #3 (permalink)  
Old October 17th, 2005, 09:21 AM
Registered User
 
Join Date: Oct 2005
Location: Chapel Hill, NC, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There aren't any modules - the person who wrote it used macros.

Leb

Len Bush
  #4 (permalink)  
Old October 17th, 2005, 09:48 AM
Authorized User
 
Join Date: Apr 2005
Location: , , USA.
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I haven't worked with macros yet. I am assuming they can be searched for permissions, usernames, id's or passwords also.

Macros can change controls and properties on forms and reports. Macros can also change existing data in the database tables, so be careful before you make any changes. I suggest making a back-up copy of the entire database.

D. Bartelt


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permission Ruman29 Access 2 July 1st, 2006 07:09 AM
(0x800A0046) Permission denied,not IIS permission! David Hay Classic ASP Basics 3 April 30th, 2006 10:47 PM
Permission denied tksarun Classic ASP Components 0 March 11th, 2005 03:01 AM
Permission Denied hamidmq Javascript How-To 2 March 10th, 2005 09:41 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.