Access and Visual Basic 6.0

[Joel27]

I have a simple question here

Is it possible to create a Visual Basic program that can run only certain parts of a database i.e.
Create a VB program that will only show a form or a table.
The database I am working on will be shared on a network through out the plant, and well, basically I only want some parts of the database to be viewed. I am hoping that using VB will prevent alot of the extra work dealing with passwords and user accounts.

Thanks Joel

 

[famousb]

simple idea. instead of installing the entire database on the network and having everyone access the whole thing that way. create a database for the tables, put that on the network, and then have seperate databases for the forms, which is installed locally on each user's machine. this way you can have different forms installed on different people's machines, and if they aren't supposed to see certain forms, they won't have them. also, if you have the Database Window hidden most user's don't know that F11 brings it back into view. simple switchboards should be good enough for most people to navigate the forms and reports they need.


Brian Famous
bfamous@ncdoi.net

 

[MichaelRed]

Just go ahead and DO the Ms. Access Security thing. It IS a bit of a PAIN initally, but once it is down pat the assignment of various users to groups and assigning the permissions for the objects works quite well. Sooner or later you will have to do it, so go ahead and get it done.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[Terpsfan]

Personally I don't like Access security...it's a potential bottleneck especially when you get over 15 concurrent users. I think the best way to implement security within Access without actually using Access security is to base screen forms on queries that only present to the user what they need to see. You could create different queries for different groups of users...data entry people would only need to see the records they are entering, etc.

 

[petermeachem]

Brian Famous (excellent name). If I looked hard, someone told me how to stop an mdb from showing the database window. I found it.

dbsTemp.Properties("AllowBypassKey&quot = false

I've not actually tried it. Also, it is a one way trip, so do it on a copy.