[MS_AccessPros] Help me sort out my [probably self-inflicted] access woes!

 

Hi all,

I think through limited knowledge and being over tired I've caused my self some serious access issues!

We have 2 access databases here...the main one is split into an FE app and BE db, uses Autofeupdater for distribution, and has an MDW file with users/passwords etc. The other is just a simple db that a couple of users access directly...it has no security. They are both mdb files...I'm using the latest version of Access. Some other users use earlier versions e.g. 2007..

 

I've caused a security/access issue for myself (other users still have access). Without thinking a couple of months ago in the main db I used the workgroup wizard to make some changes. I've not needed to use either db since then, but today I do...BUT...the db with no security is asking for a login, but when I use mine it says no such user. I've also tried Admin with no password but I think (can't remember) added a password to that in the MDW file years ago! The main db with the security has intermittently let me in as it should, but then decides I don't have sufficient permission to access the mdb file through the shortcut that calls the autofeupdater ini file...but I've just been in the bl***y db 5 mins ago so something has happened in between!

 

I'm pretty sure I just need to 'undo' the workgroup thing I did a couple of months ago as I suspect Access is trying to use that for my access and its conflicting with the MDW used by autofeupdater – is that possible? Can I somehow tell Access to ignore the standard workgroup file forever!? I did read an article that says to save my mdb as an accdb which will remove the security. I tried this with a copy of our main db but get a message that the db is encoded...I'm then stuck as i don't know how to decode it! Also, I don't know what effect this will have on the other users – some are using Access 2007. If I go ahead with this can I then set up users/passwords in the accdb version?

Thanks for your patience with my incompetence!!!

__._,_.___

---

Posted by: nigel@pegasusconsulting.co.uk

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___