Re: [MS_AccessPros] Linked table problems

 

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

---

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.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___