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
>
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar