how can recreate .mdw

[Guest]

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]

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.

 

[Guest]

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

 

[Rick Brandt]

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.

 

[Guest]

"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

 

[Rick Brandt]

"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

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.

 

[Joan Wild]

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.