Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / May 2007

Tip: Looking for answers? Try searching our database.

NECESSARY PERMISSION..........

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
shiro - 26 May 2007 04:42 GMT
I just performed one step security wizard to my db
( I don't really understand with this ) but in the end
I can't open my db anymore,Access just sent me
a message

"You don't have necessary permission to use file c:/my document//.
Have your system administrator or the person who estabilish this
file, create approriate permission for you"

And I have not created a new user account yet.

When doing this,I received one step security wizard report.
Then I'm trying to create a new workgroup through wrkgadm.exe
by entering the data based to the report.
But there was more error message

" An error has occured at changing database workgroup"

I don't know what I made wrong,except one thing I did not
back up my file and do not have any copy of my file.

Is there any solution.
Scott McDaniel - 26 May 2007 14:37 GMT
>I just performed one step security wizard to my db
>( I don't really understand with this ) but in the end
>I can't open my db anymore,Access just sent me
>a message

The security wizard most likely created a .bak file (which is an unsecured copy of your database). Use that copy, and
rename it with the .mdb extension. The security wizard is not the best method to use to secure your database; see the
link below for step-by-step instructions on doing this manually.

Access ULS is not a trivial subject, and it would be a good idea for you to understand what is going on before you
secure your database. There are several resources available which can help you, the easiest way to get to them is
through Joan Wild's site (www.jmwild.com) which includes links to the Security FAQ and Jack MacDonald's site, which
contains a must-read whitepaper on ULS.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
shiro - 28 May 2007 03:16 GMT
Thank's a lot Scott,
I got my db back.And thank's too for your suggestion.
But one more question,
Why I can't assign a new user to my database?
When I attempting to assign a new user,there was
a messagge:

'Cannot update.Database or objects is read only'

> >I just performed one step security wizard to my db
> >( I don't really understand with this ) but in the end
[quoted text clipped - 13 lines]
> scott@takemeout_infotrakker.com
> www.infotrakker.com
Scott McDaniel - 28 May 2007 12:17 GMT
>Thank's a lot Scott,
>I got my db back.And thank's too for your suggestion.
[quoted text clipped - 4 lines]
>
>'Cannot update.Database or objects is read only'

Not sure about that. Can you make changes to other objects? Note that Users are stored in the .mdw file, not the actual
database, so make sure you don't have the .mdw file open when you're trying to add users.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.