Adam,
Please always reply with the previous messages included. If you read your email on its own, it gives us no clue as to what your original question was.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 12 Feb 2016 10:12:57 -0800
Subject: Re: [MS_AccessPros] pdateable query with SQL linked tables
John,
Didn't work.
It's not itself. I'm updating a field in a non-linked FE table with a field from a linked BE table. The business reason is that, at login, I copy data from BE tables to reside locally. Forms and reports (i.e., queries) run much faster for the user this way. I only copy over the tables that need to be updated. I time stamp the BE when I update it, and the FE when I copy over. I compare the time stamps at login. This code is supposed to copy the BE time stamp to the FE after updating the FE.
Adam
Please always reply with the previous messages included. If you read your email on its own, it gives us no clue as to what your original question was.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 12 Feb 2016 10:12:57 -0800
Subject: Re: [MS_AccessPros] pdateable query with SQL linked tables
John,
Didn't work.
It's not itself. I'm updating a field in a non-linked FE table with a field from a linked BE table. The business reason is that, at login, I copy data from BE tables to reside locally. Forms and reports (i.e., queries) run much faster for the user this way. I only copy over the tables that need to be updated. I time stamp the BE when I update it, and the FE when I copy over. I compare the time stamps at login. This code is supposed to copy the BE time stamp to the FE after updating the FE.
Adam
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar