I've just spent 3 weeks designing and writing an Access database and writing the accompanying reports for my new company - nothing fancy but will meet the needs of this one man (woman) band. I finished the main bulk of the reports last night and decided to do some general housekeeping today as I had lots of unnecessary files that I'd generated recently. So far so good, until I tried to open the database and received the message:
"You do not have the necessary permissions to use the C:\etc object. Have your system administrator or the person who created this object establish appropriate permissions for you"
I have also received a message "Cannot lock the file"
I have spent the rest of the day researching Access to see what I've done and think that it's because I've deleted the Security.mwd file (yes, I remember looking at it and thinking, no idea what that is ... delete)
I've tried recovering the deleted file using Softlogica Handy Recovery and PC Inspector software packages but when I try to open them Access shows a message "Unrecognized database format".
To make matters worse, I backed up my database onto a DVD today but didn't back up the Security.mwd file as I didn't realise its importance so now I can't use the backup either. The only one I can use is from about a week ago ... very basic version with no reports but I suppose that's something.
Anything you can suggest to get me up and running again would be welcome. My business only started officially this week and now it's at a halt until I can get into the database again ... what joy!