Lost .mdw file

[Guest]

Hi,
I created a secured Access (97) Database and I am the Admin And I had all
permissions. But I lost my .mdw file. I have written down My Username and
User ID. So How can I retrieve Data from my Database. How to created a new
mdw file?
Please Help me.
(e-mail address removed)

 

[Scott McDaniel]

Has the machine never been backed up? If it has, then go back through the
backups and recreate the .mdw file and open your database. Otherwise, the
only way to recreate the mdw file is to rebuild it, using the EXACT
information as used originally.

 

[Guest]

No Backups. I know Only User Name and ID. Will that enough to recreate .mdw
file and see data?

 

[Scott McDaniel]

No Backups. I know Only User Name and ID. Will that enough to recreate
.mdw
file and see data?

No, you need the exact credentials you used when originally creating the
workgroup file (the name, PID, etc). Without those, the file will not be
identical.

I can't believe that an application in use for any length of time wouldn't
have a backup ... check with your IT people and see what they say.

 

[shiro]

Thanura,
If it's still possible,may be it's a good idea
to import all databse object from your older db
to a new db file.Then you can re-perform ULS
to the new one.