|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
12-02-2008
| #1 (permalink) |
| | Running A Script Whenever A User Tries To Open A Folder On TheNetwork Hi, I have a backend to an access database saved in a folder on the network. Because Access requires users to have Read/Write permissions to that folder, there is a liability assumed because the back end database contains alot of data that most of the users should not see. I want to write a script in VB Script that will kick users out whenever they try to open this folder. Or through some other method prevent them from being able to physically open the back end to the database. Does anyone have any ideas? |
My System Specs |
|
12-03-2008
| #2 (permalink) |
| | Re: Running A Script Whenever A User Tries To Open A Folder On TheNetwork On Dec 2, 7:52 am, nouveauricheinvestme...@xxxxxx wrote: Quote: > Hi, > > I have a backend to an access database saved in a folder on the > network. Because Access requires users to have Read/Write permissions > to that folder, there is a liability assumed because the back end > database contains alot of data that most of the users should not see. > I want to write a script in VB Script that will kick users out > whenever they try to open this folder. Or through some other method > prevent them from being able to physically open the back end to the > database. Does anyone have any ideas? |
| My System Specs |
|
12-03-2008
| #3 (permalink) |
| | Re: Running A Script Whenever A User Tries To Open A Folder On The Network nouveauricheinvestments@xxxxxx wrote: Quote: > On Dec 2, 7:52 am, nouveauricheinvestme...@xxxxxx wrote: Quote: > > Hi, > > > > I have a backend to an access database saved in a folder on the > > network. Because Access requires users to have Read/Write permissions > > to that folder, there is a liability assumed because the back end > > database contains alot of data that most of the users should not see. > > I want to write a script in VB Script that will kick users out > > whenever they try to open this folder. Or through some other method > > prevent them from being able to physically open the back end to the > > database. Does anyone have any ideas? > No ideas on this anyone? protect the backend database. Then create a new front end (using "Link Tables" to the backend database tables) that only allows the users to see and use the forms, tables, etc. that you specify (use properties to hide sensitive tables) and compile it to an .mde to prevent alterations. Then distribute the new front end .mde to your users. They wont even know the local front end is linked to the backend on the server. -- Todd Vargo (Post questions to group only. Remove "z" to email personal messages) |
| My System Specs |
|
12-05-2008
| #4 (permalink) |
| | Re: Running A Script Whenever A User Tries To Open A Folder On TheNetwork On Dec 3, 11:07 am, "Todd Vargo" <tlva...@xxxxxx> wrote: Quote: > nouveauricheinvestme...@xxxxxx wrote: Quote: > > On Dec 2, 7:52 am, nouveauricheinvestme...@xxxxxx wrote: Quote: > > > Hi, Quote: Quote: > > > I have a backend to an access database saved in a folder on the > > > network. Because Access requires users to have Read/Write permissions > > > to that folder, there is a liability assumed because the back end > > > database contains alot of data that most of the users should not see. > > > I want to write a script in VB Script that will kick users out > > > whenever they try to open this folder. Or through some other method > > > prevent them from being able to physically open the back end to the > > > database. Does anyone have any ideas? Quote: > > No ideas on this anyone? > This is not a scripting issue. This is a database setup issue. Password > protect the backend database. Then create a new front end (using "Link > Tables" to the backend database tables) that only allows the users to see > and use the forms, tables, etc. that you specify (use properties to hide > sensitive tables) and compile it to an .mde to prevent alterations. Then > distribute the new front end .mde to your users. They wont even know the > local front end is linked to the backend on the server. > > -- > Todd Vargo > (Post questions to group only. Remove "z" to email personal messages) accde file? I have tried encrypting (password protecting) the backend and it does not allow me to access the database. |
| My System Specs |
|
12-05-2008
| #5 (permalink) |
| | Re: Running A Script Whenever A User Tries To Open A Folder On TheNetwork On Dec 5, 10:08 am, nouveauricheinvestme...@xxxxxx wrote: Quote: > On Dec 3, 11:07 am, "Todd Vargo" <tlva...@xxxxxx> wrote: > > > Quote: > > nouveauricheinvestme...@xxxxxx wrote: Quote: > > > On Dec 2, 7:52 am, nouveauricheinvestme...@xxxxxx wrote: > > > > Hi, Quote: Quote: > > > > I have a backend to an access database saved in a folder on the > > > > network. Because Access requires users to have Read/Write permissions > > > > to that folder, there is a liability assumed because the back end > > > > database contains alot of data that most of the users should not see. > > > > I want to write a script in VB Script that will kick users out > > > > whenever they try to open this folder. Or through some other method > > > > prevent them from being able to physically open the back end to the > > > > database. Does anyone have any ideas? Quote: Quote: > > > No ideas on this anyone? Quote: > > This is not a scripting issue. This is a database setup issue. Password > > protect the backend database. Then create a new front end (using "Link > > Tables" to the backend database tables) that only allows the users to see > > and use the forms, tables, etc. that you specify (use properties to hide > > sensitive tables) and compile it to an .mde to prevent alterations. Then > > distribute the new front end .mde to your users. They wont even know the > > local front end is linked to the backend on the server. Quote: > > -- > > Todd Vargo > > (Post questions to group only. Remove "z" to email personal messages) > Is an mde file access 2003? I'm using access 2007. Do you mean an > accde file? I have tried encrypting (password protecting) the backend > and it does not allow me to access the database. the back end is encrypted... |
| My System Specs |
|
12-06-2008
| #6 (permalink) |
| | Re: Running A Script Whenever A User Tries To Open A Folder On The Network nouveauricheinvestments@xxxxxx wrote: Quote: > On Dec 5, 10:08 am, nouveauricheinvestme...@xxxxxx wrote: Quote: Quote: > > Is an mde file access 2003? I'm using access 2007. Do you mean an > > accde file? I have tried encrypting (password protecting) the backend > > and it does not allow me to access the database. > It does not allow me to access the database through the front end when > the back end is encrypted... work also. I can not help without exact message that it gave you. I suspect you created the table links before applying the password to the backend. The correct way is to apply the password and/or encrypt the backend before creating the links. This brings to mind that if you change the password on the backend database later on, then you will have to delete and recreate the table links (because I don't know of another way to change the password on the links). -- Todd Vargo (Post questions to group only. Remove "z" to email personal messages) |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
 Help Stop running this script Msg | Network & Sharing | |||
| Running PowerShell script from within an MSI? | PowerShell | |||
| Problems running an app from within a script | PowerShell | |||
| i want Windows Explorer to open in user folder not Start Menu fold | Vista file management | |||
| Help on running a a script | PowerShell | |||
