Steve Bremner
Registered User.
- Local time
- Today, 17:09
- Joined
- Jul 16, 2003
- Messages
- 34
Thanks for the additional advice guys. I'll let you know if I have any problems!
Kevin_S said:Steve -
From your original note you were looking to set up a table/query combo to provide user login - based on this post I provided the "user created" security option as a way to implement your requested solution...
- As Jon pointed out - no it is not real secure. Now there are options to make it more secure then it currently is (disable shift bypass option, hide db objects/window, password protect be, etc) but this solution is best used if your users are not literate/db savy and the info being complied is not critical info. - Basically, this is best for a small, handful of users db....
If you want to fully secure then I suggest splitting your application into front end/ back end and implementing MS Access User-Level Security and password protecting the backend. For more info on this search this forum for 'User Level Security" , "Splitting database" , and "password protect backend"
HTH,
Kev
Kevin_S said:Maybe you could provide Steve with an example of the table layout/relationships he will need?... or the forms/code to implement your proposed solution...? Possible to e-mail him an example maybe? I don't want to offer up your work for you but he posted here in the first place because he didn't know how to set this up and was looking for guideance...
Mile-O-Phile said:
Mile-O and I
Steve Bremner said:YAY!
Usually I'm the only one in other forums! The others better not hope we start typing with an accent!
Mile-O-Phile said:
Mile-O and I