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 / January 2007

Tip: Looking for answers? Try searching our database.

how can recreate .mdw

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Al - 14 Jan 2007 01:36 GMT
I lost my .mdw file. no back ups. I am the admin. I know what my id and
password was. can I create a new .mdw and add an account with the same ID and
Password as the deleted file? how do I do that if this is going to work?
thanks
Al
Rick Brandt - 14 Jan 2007 01:40 GMT
> I lost my .mdw file. no back ups. I am the admin. I know what my id
> and password was. can I create a new .mdw and add an account with the
> same ID and Password as the deleted file? how do I do that if this is
> going to work? thanks
> Al

You also need the Workgroup ID you entered for the workgroup itself when you
created it.  Just having that for a user (even an admin user) is not enough.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Al - 14 Jan 2007 03:41 GMT
If I was able to find the workgroup id. what do I need to do then? could you
walk me through it, Please.
thanks
Al

> > I lost my .mdw file. no back ups. I am the admin. I know what my id
> > and password was. can I create a new .mdw and add an account with the
[quoted text clipped - 4 lines]
> You also need the Workgroup ID you entered for the workgroup itself when you
> created it.  Just having that for a user (even an admin user) is not enough.
Rick Brandt - 14 Jan 2007 04:29 GMT
> If I was able to find the workgroup id. what do I need to do then?
> could you walk me through it, Please.
> thanks
> Al

You would use the workgroup administrator tool to create a new workgroup file.
When creating the workgroup you would need to use the same WorkgroupID as the
lost file.  Then you would have to create at least one group or one user that
has administrator permissions in the MDB and when creating those you would have
to use the identical IDs that were used in the lost workgroup file.  In all
three cases when I say "ID" I do not mean the name.  When any of these are
created you are also asked to enter an ID that is separate from the name.  If
those are identical to those used in the lost file, then that workgroup should
be able to be used to gain access to the MDB.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Al - 14 Jan 2007 14:45 GMT
"In all  three cases when I say "ID" I do not mean the name.  When any of
these are created you are also asked to enter an ID that is separate from the
name" ?

do you mean the PID? I get the picture but I am not sure that I understand
this particular statment.
Al

> > If I was able to find the workgroup id. what do I need to do then?
> > could you walk me through it, Please.
[quoted text clipped - 10 lines]
> those are identical to those used in the lost file, then that workgroup should
> be able to be used to gain access to the MDB.
Rick Brandt - 14 Jan 2007 15:30 GMT
> "In all  three cases when I say "ID" I do not mean the name.  When
> any of these are created you are also asked to enter an ID that is
[quoted text clipped - 3 lines]
> understand this particular statment.
> Al

Yes.  Two MDW files named Secured.MDW, both containing a group MyAdmins and a
user MyAdmin will not be considered the same by Access unless the PIDs are
identical.  I don't recall if the names ALSO need to be identical or if the PID
is all that matters, but the PIDs definitely do need to be the same.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Joan Wild - 14 Jan 2007 15:44 GMT
Actually you don't need the workgroup ID.  As long as you have the username
and PID of a user that was a member of the Admins Group (or better still the
owner), you should be OK.

Open Access, and go to Tools, Workgroup Administrator, and click on Create -
create a new workgroup file (that will also join you to it as the default).

Close Access, and reopen it.  Add the username and PID to this workgroup
file.

Signature

Joan Wild
Microsoft Access MVP

>
> "In all  three cases when I say "ID" I do not mean the name.  When any of
[quoted text clipped - 28 lines]
>> should
>> be able to be used to gain access to the MDB.
 
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.