Solved: HELP!! Messed up my security settings

[paulked]

Hi all.

Sorry if this is the wrong place to post this as it is not VBA related, but I'm desperate!

I was messing with the Tools - Security settings and now I cannot write data to my tables from an external source (I'm using a PLC interface to read/write/update records in the tables)

How do I reset this back to (I guess default) the level I was at before I foolishly messed with what I didn't understand?:doh:

Many thanks in anticipation

Paul Ked:whip

[hansup]

What did you do after Tools -> Security? My Access 2003 offers multiple choices in that submenu. If you can narrow it down, I will try to help.

[paulked]

I did allsorts :-(

I started with the Wizard and when that stopped me acessing the database remotely I tried setting permissions, added a new user, tried setting their permissions and when that didn't work I deleted the user. I then tried anything and everything and got myself in a right mess. I guess that my only chance is to reset to default settings but don't know how!

Cheers

Paul Ked

[OBP]

When you say that you used the Security Wizard, do you mean you used it to "Secure" the database?
If yes then it created a backup called yourdbname.BAK which you can restore.

[paulked]

Thanks for that.

I have recovered the file but it still won't allow me to save any changes I make in the VBA Modules. It says that another user has the file open when I am the only one with it open.

I try to open it for exclusive use, but I don't have permission (which is a bit of a shame as I have written the damned thing!)

ANY help MUCH appreciated, cheers

Paul Ked

[paulked]

I've just tried to change permissions (User and Group Permissions - Change Owner tab) for the Database Object as its current owner is <Unknown> but the Change Owner butten is greyed out.

[paulked]

Thanks for the Help. I think I've sorted it by creating a new DB and importing everything from the old one to the new one. I can, at least, alter my code!

Cheers

Paul Ked