John,
IT changed the access permissions for me and it all works now. Thank you for the help.
Jim Wagner
On Thu Jun 08 2017 09:27:23 GMT-0700 (US Mountain Standard Time), John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
To be able to "refresh" the tables, YOU have to be able to get full update access. If someone else has it opened read-only, your refresh will fail.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Jun 8, 2017, at 6:19 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John
all tables going to the database are tables that should not be changed. they are refreshed each morning for reporting. That is why I am perplexed at why the read only is even an issue here. So if it does not matter then why is the database even read only in the first place.
Jim Wagner
On Thu Jun 08 2017 08:54:49 GMT-0700 (US Mountain Standard Time), John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Won't help. YOU need full update authority to update the tables, and you won't get that if anyone has the database open read-only. Now, if you had a way to kick everyone out so that you can update… I assume that read-only doesn't matter in your front end because it's all reporting?
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Jun 8, 2017, at 4:10 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
Apparently not everyone has full access to the folder by looking at the folder properties. Yesterday only one table was updated and the rest did not change modified dates. Today none of the tables modify dates were changed. This is how I am copying the tables to the database
' Data warehouse database
' copy objects to W:\ADMINISTRATIVE SERVICES DATABASES\MANAGEMENT SUPPORT SERVICES T-A-P\MISC INFO DATABASE
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-CURRENTEMPLOYEES"
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-EMPLOYEEHISTORY"
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-STIPEND"
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-SUPPAY"
' copy objects to W:\ADMINISTRATIVE SERVICES DATABASES\MANAGEMENT SUPPORT SERVICES T-A-P\MISC INFO DATABASE
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-CURRENTEMPLOYEES"
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-EMPLOYEEHISTORY"
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-STIPEND"
DoCmd.CopyObject "W:\ADMINISTRATIVE SERVICES DATABASES\Department Datawarehouse.accdb", "", acTable, "R&D-SUPPAY"
But would it be more efficient to run a make table query in the base database into the target database? To be honest after all these years I never noticed that you could do that. But then it was never needed in our scenarios here.
Jim Wagner
On Thu Jun 08 2017 00:24:45 GMT-0700 (US Mountain Standard Time), John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Everyone must have full access to the folder where you have stored the backend. If not, then the first person to open the database who does not have full access will lock it to read only.
How are you "sending" the four tables to the backend each morning? That must be getting some sort of error if it can only get read only access and not actually update the tables.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Jun 8, 2017, at 12:01 AM, luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
__._,_.___
Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar