Re: unsecuring a database?
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Tue, 6 Apr 2004 13:23:42 -0500
"sara" <schan@insighttv.com> wrote in message
news:1901201c41bff$14d7e480$a301280a@phx.gbl...
> is it possible to undo the security altogether in access
> 2000?
> i secured my database while testing it out but don't know
> how to make it revert back to a nonsecured database.
> any help appreciated, thanks.
Log in as an administrator and give full permissions to the group "Users"
on all objects including the database itself. Close Access and reopen it
using a non-secure MDW file. Create a new blank file and import all
objects from the original file. You should now have a file identical to
the original and as if security was never applied to it.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Relevant Pages
- unsecuring a database?
... is it possible to undo the security altogether in access ... how to make it revert back to a nonsecured database. ...
(microsoft.public.access.security) - Re: Building app around Flashback Versions Query
... it's a small database, ... backups should be pretty fast if the undo tablespace gets huge. ... almost identical to the way Flashback Versions Query provides ... >> apps around Flashback Query and Flashback Database. ...
(comp.databases.oracle.server) - Re: Is there just one UNDO with Project?
... "the edited record is written to permanent disk storage" - Do you think ... One of the "cures" for broken .mpp files is to send them to the database ... So, actually, I believe the reason that the number of undo's was limited to ... One can undo changes ...
(microsoft.public.project) - Re: Oracle 9i - database cannot open due to UNDOTBS01
... I am new to using Oracle and I am using 9.2.0.7. ... and spfile of my database. ... not backup was the UNDO. ... alter database datafile 'UNDOTBS01.DBF' OFFLINE DROP; ...
(comp.databases.oracle.server) - Re: Is there just one UNDO with Project?
... I don't know if MSP uses parts of the Jet dbms engine "under the hood" or not but almost all databases I'm familiar with have similar behavior. ... One can undo changes made to a given record while it's in memory for editing but once the record pointer moves to a new record, the edited record is written to permanent disk storage with all changes overwriting the original record in the permanent file and no longer able to be undone. ... Most proggies that allow multiple undo levels are editing to an image in memory and don't commit changes to the actual permanent storage file until it is closed or otherwise explicitly saved. ... But that strategy is just not practical with a database table that potentially could have billions of records - they all read and load either a single record at a time or at most a "page" consisting of a relatively small handful of records. ...
(microsoft.public.project) |
|
