Kamis, 08 Juni 2017

Re: [MS_AccessPros] Linked table problems

 

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"


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:


 

Jim-


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:



Hello all,


So I was finally given the go ahead to slowly change all of our databases to a FE and BE solution one by one after testing for a month each database. They did not want to do it because they said it is wrong to do and it is not stable. I am looking really silly now because I created the FE and the BE and I thought it was working with the linked tables. Until today a report came up with incorrect data. So I opened the FE to see the date on the table and it was last modified 5/10/2017. Another table had todays date. the other 2 tables have older dates. So I opened the BE and I received a nasty message


I see a READ ONLY This database has been opened read-only. You can only change data in linked tables. To make design changes, save a copy of the database. with a Save As... message at the top.


 So I send 4 tables to this BE database each morning, and never received an error. 

So how do I make the database so that the tables get updated so the tables get refreshed and the reports work. 

I am assuming because it is read only nothing is happening. 


Thank You

Jim Wagner




__._,_.___

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 (3)

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