Kamis, 08 Juni 2017

Re: [MS_AccessPros] Linked table problems

 

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:


Jim-


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 
http://www.viescas.com/ 
(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"


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 
http://www.viescas.com/ 
(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: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)
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.

.

__,_._,___
Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)