Re: MDE

From: prabha (nospam_at_microsoft.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 00:02:04 GMT

Connie,

It's possible you one or the other problem:

1 - The Admin account does not have the necessary permissions. Whoever
created the security probably set it up this way to keep the Admin (Guest)
from opening objects in the database.

OR

2 - You are using the incorrect MDW file used to secure the database. To
check perform the following:
         + After entering the Admin account and password (either with the
MDE open or not) select teh menu option Tools > Security > User and Group
accounts
         + Under the drop for User it will say "Admin". Pull the drop
down... if you don't see the other User Accounts you created when the
database was Secured then you are using the incorrect MDW

If you don't see the other User accounts then select the menu option (I'm
guessing you are using Access 2002) Tools > Security > WorkGroup
Administrator. Note the WorkGroup Microsoft Access is defaulting to. If
this is incorrect then join to the correct MDW file.

If you are using Access 2000 then double click on the file C:\Program
files\Microsoft Office\Office\1033\wrkgadm.exe

then like in Access 2002 note the WorkGroup (MDW) Microsoft Access is
defaulting to and if this is incorrect join to the correct MDW file.

Eric

--------------------
| Content-Class: urn:content-classes:message
| From: <anonymous@discussions.microsoft.com>
| Sender: <anonymous@discussions.microsoft.com>
| References: <ca8901c3ef3c$0d1b1220$a101280a@phx.gbl>
<q5$ywS07DHA.2508@cpmsftngxa07.phx.gbl>
<e1c301c3f024$5b7f63b0$a401280a@phx.gbl>
<8NGdnUURSLinjLfdRVn-hw@comcast.com>
| Subject: Re: MDE
| Date: Wed, 11 Feb 2004 14:46:44 -0800
| Lines: 62
| Message-ID: <f08901c3f0f0$ec2e9940$a501280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPw8Owun+1W1dZwSmaQR9KIkhvmnw==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.security:8257
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.security
|
| I can open the database and see the objects. However, I
| cannot open, view, import, export any tables, forms,
| etc. The messgae tells me I don't have permission. No
| changes are necessary to forms etc. Just want to view
| data
|
|
| >-----Original Message-----
| >Can you actually open the database ... by this I mean
| can you open the file
| >and open forms, reports, etc etc ... if you can, then
| security isn't your
| >trouble.
| >
| >If you're using an .mde file, you won't be able to
| change anything regarding
| >the OBJECTS in the database ... for example, you
| wouldn't be able to open a
| >form in design view and add a button, or add a report,
| etcetc. You would
| >need to find the original .mdb file that was used to
| create the database.
| >Quite often it's the same name as the file you have now
| except with an .mdb
| >extension.
| >
| >If that's not what you're trying to do, please post back
| and we'll try to
| >help further.
| >
| >--
| >Scott McDaniel
| >CS Computer Software
| >Visual Basic - Access - Sql Server - ASP
| >
| >"Smash forehead on keyboard to continue ... "
| >
| >
| ><anonymous@discussions.microsoft.com> wrote in message
| >news:e1c301c3f024$5b7f63b0$a401280a@phx.gbl...
| >> Hi Eric
| >>
| >> Thank you so much for the information. I was able to
| go
| >> in and change the password for the admin. I was given a
| >> user id and p/w to use, however, it did not work. I
| got
| >> in using "admin" as an id and the p/w i changed it to,
| >> but as always, access was denied for anything else,
| >> including import, export, changes etc.
| >>
| >> Contact with the administator is difficult as he has
| left
| >> the organization.
| >>
| >> Any further suggestions are welcome
| >>
| >> Connie
| >
| >
| >.
| >
|