Jumat, 12 Februari 2016

RE: [MS_AccessPros] pdateable query with SQL linked tables


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


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.



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