Help With Security Options

[Oldsoftboss]

I'm soooo sorrry. My mum reckons I am 1 big problem
Dave

 

[Hayley Baxter]

I'm soooo sorrry. My mum reckons I am 1 big problem
Dave

I quite agree, I was fair proud of myself there thinking I'd found a solution but you've gone and spoiled it I'm not finished yet though some more private detective work should do the trick..there's always ways you just have to find them

 

[Oldsoftboss]

When YOU find an answer let ME know so I can fix all MY problems. I am going to put my feet up. It's Friday night here, so I will be of very little use for the next couple of days. (Even less than usual)
Dave

 

[JMcQueen]

Hi Hayley. Sorry its taken so long to get back to you but I havent had much time lately to check in. I've definately downloaded the '97 version (did so repeatedly to make sure) and even if I just open the demo in its downloaded state, before I get my mits on it, I get the same error message. Frustrating to say the least as like I said, it works fine on my laptop which is Access 2002.

 

[waipahunet]

Can't get it to work when I import the files

I open up the login form and it doesn't automatically pull up the network user name it just shows #Name? It works fine when I'm running the example by itself. Anyone have any suggestions?

 

[Kath]

MS Access Security - joining the conversation..help!

Hello,
I have read through this thread and got a lot of good info. However, I am still struggling with what I would need to do to incorporate Security in access using the demo posted by Hayley. Is it possible to implement security into Access without User Security implemented (where it affects other Access apps?) I do not want to have users have to switch workgroups. I also am aware that if I cannot, I would have to have an ini file that references the secure.mdw file - Basically, I have an HR apps that has secure data within it, and will need users to access reporting off of that database. Would it be just easy to have the database split across 3 file sets (1) for non secure data (2) for secure data (3) for general reporting, then having file level security on the servers protecting the secured data? Would I be able to integrate the files between the secure and non-secure? As you can see...many struggles on the best way to do this and I have limited time to figure it out. Any thoughts would be GREATLY appreciated! Oh, I did not mention that this database is tied to our PR system - using a select statement to automatically pull the needed data. So...I am sure I have many security issues that I need to deal with. Also, does anyone have any information on RWOP? (Could I secure data but have a user run a select/update query on that data to the HR db table(s)? Thanks!
Kath

 

[kdt]

Hi Hayley

I have a problem that I think your solution might solve. I am however using an access 97 db. Could you please send me a copy of this in 97 format or the code??

Many thanks

 

[dgmorr]

I know this is a really old thread, but great work Hayley!

I am curious to know how to hide the DB view fromthe user while they are logging in. I am still able to play with the tables and whatnot while the login screen loses its focus. Is there setting I have to check off?

 

[The_Doc_Man]

I would never chastise anyone for being upset enough with Access security to "roll their own" - but the average user does better to follow the Windows paradigms. The ability for Hayley, who has developed a lot of experience with Access since first coming on board, is not the same as for new DB admins who still haven't quite got the Users and Groups collections figured out.

 

[Moniker]

Also note that adding a USys prefix is the same as right-clicking a table, going to Properties, and then checking the "Hidden" checkbox. Both can be revealed in Options on the View tab by unchecking or checking the Show System Objects textbox.

Of course, people that know how to do that should know enough to not screw with the DB design, but you never know.

 

[unluckytoe]

I know that this is a very old thread, but is there a way to easily integrate this into an Access 2007 project? I saw this and my jaw dropped because it's so awesome! This is the kind of security I need. Right now I'm just using a general user name and password setup. I tried importing it into my FE and changed a few things, but I can't get it to work.

If this can't work with 2007, is there something else out there (free or commercial) that will work?

Thank You:

Brian

 

[Dazzy]

Yes I need this to work now with 2007 if possible, the office has updated some PC's but not all and that attitude is driving me mad. Database now wont work for those using Access 2007 and unfortunately they happen to be the managers.

 

[anski]

Here's what I found on the web:

Q) Can I hide a table so that it doesn't appear in the Database window?

(A) If you want to hide a table in the database windows so that other users can't select it, preface the table's name with 'Usys'. For example, if your table's name is employee, change it to UsysEmployee. This makes your table into a system object which access does not display. To see this table later, choose view, options, show system objects.

Now all I did was put Usys in front of tblSecurity and changed this in the code as well. Now open a balnk db and try to import tblsecurity it's now unavailable.

Is this a solution?

is there another way? because if i do this, i will have to update all the forms, queries, reports that link to the table. or do these objects update automatically when i rename a table?

even if the table is visible to the users, i dont want them to CHANGE ANY OF THE DATA in the table. how do i do this?

 

[Dazzy]

Can help me get this to work with 2007? please pm me with a quote.

 

[Dazzy]

Ok was finally given a copy of 2007 today and figured what the problem was the code works fine, it's the security settings in 2007, just add the location of the DB to the trusted sites and all is good.