Mark,
I am curious on how the folder and subfolders backfired on you. It is working great for me. Only the people who have access to the subfolder can see that specific database with that specific data I send for that specific department. Maybe I missed something in my application that makes it not secure.
Jim Wagner
From: m_bacheldor <m_bacheldor@yahoo.com>
To: AccessDevelopers@yahoogroups.com
Sent: Tuesday, October 4, 2011 12:07 PM
Subject: [AccessDevelopers] Re: Access Restriction
Jim,
I understand what you mean. I am dealing with payroll information and trying to make sure that each department can only see the information for there department. I am daily uploading Krono's data and other mainframe data into my database. I then add to that wage data, daily status data, and other data from different sources.
I set up the excel files with queries to the database to give them specfic information based on the what the file is setup to access. While this does work unless I let them have access to the database where the information is stored the links won't work. We put the database in a restricted folder and gave the users access to sub folders, but that too back fired.
My current work around is that I have 40 files that are in the secured folder that I run a macro in to refresh all the data. I then make backups which are saved/renamed with the date modified then doing a paste special values on them to get rid of any links. The files are then sent to their respective folders as static files. This gives them the daily information but I was looking to make it more robust by allowing the users to select different Pay Periods in the spreadsheets which would allow the users to view previous Periods data.
I appreciate the suggestions,
Mark
--- In AccessDevelopers@yahoogroups.com, Jim Wagner <luvmymelody@...> wrote:
>
> Mark,
>
> Every morning I get about 21 downloaded excel spreadsheets and import the excel files into a main database. I then send each of the tables to different databases. I also have a process that in a main database creates tables using queries to create about 12 tables with department information including id's and names and other information. I then send the tables to the respective department databases. I do it this way because of the serious and sometimes crazy fear from management of anyone seeing specific information. We have linked tables but not very many because of this management fear.
>
>
> Jim Wagner
>
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: m_bacheldor <m_bacheldor@...>
> To: AccessDevelopers@yahoogroups.com
> Sent: Tuesday, October 4, 2011 8:47 AM
> Subject: [AccessDevelopers] Access Restriction
>
>
> Â
> Good Afternoon,
>
> I have gotten my database working pretty good for now, but now I am faced with a security issue. Is there a was to restrict access, who can open the database, but still allow users to access data through linked/restricted excel files?
> I have set up excel files that have hard code linkes to the database queries. I would like for the users to be able to refresh the data from the excel files but I do not want them to be able to open/access the database.
> It seems like the requirements that I am given to complete this task change daily.
>
> I appreciate you responses,
>
> Mark
>
I understand what you mean. I am dealing with payroll information and trying to make sure that each department can only see the information for there department. I am daily uploading Krono's data and other mainframe data into my database. I then add to that wage data, daily status data, and other data from different sources.
I set up the excel files with queries to the database to give them specfic information based on the what the file is setup to access. While this does work unless I let them have access to the database where the information is stored the links won't work. We put the database in a restricted folder and gave the users access to sub folders, but that too back fired.
My current work around is that I have 40 files that are in the secured folder that I run a macro in to refresh all the data. I then make backups which are saved/renamed with the date modified then doing a paste special values on them to get rid of any links. The files are then sent to their respective folders as static files. This gives them the daily information but I was looking to make it more robust by allowing the users to select different Pay Periods in the spreadsheets which would allow the users to view previous Periods data.
I appreciate the suggestions,
Mark
--- In AccessDevelopers@yahoogroups.com, Jim Wagner <luvmymelody@...> wrote:
>
> Mark,
>
> Every morning I get about 21 downloaded excel spreadsheets and import the excel files into a main database. I then send each of the tables to different databases. I also have a process that in a main database creates tables using queries to create about 12 tables with department information including id's and names and other information. I then send the tables to the respective department databases. I do it this way because of the serious and sometimes crazy fear from management of anyone seeing specific information. We have linked tables but not very many because of this management fear.
>
>
> Jim Wagner
>
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: m_bacheldor <m_bacheldor@...>
> To: AccessDevelopers@yahoogroups.com
> Sent: Tuesday, October 4, 2011 8:47 AM
> Subject: [AccessDevelopers] Access Restriction
>
>
> Â
> Good Afternoon,
>
> I have gotten my database working pretty good for now, but now I am faced with a security issue. Is there a was to restrict access, who can open the database, but still allow users to access data through linked/restricted excel files?
> I have set up excel files that have hard code linkes to the database queries. I would like for the users to be able to refresh the data from the excel files but I do not want them to be able to open/access the database.
> It seems like the requirements that I am given to complete this task change daily.
>
> I appreciate you responses,
>
> Mark
>
__._,_.___
Please zip all files prior to uploading to Files section.
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar