you're welcome, Terence :)
I have a chapter in my Access Basics book on SQL that covers the basics of Append and Update queries if you (or someone reading this) need to know how to create and run them
Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access
even though you can open those system tables, the only way to change data in them is with SQL (queries). Do be careful when you make changes. and, of course, backup your database first ;)
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: Terence
TY Crystal, I will give it a shot first thing in the morning.
Terence
--- Crystal <strive4peace> wrote:
>
> Hi Terence,
>
> find the information you want to change in the IMEX tables -- you can use Update and Append queries on them :) be sure you use its primary key and change the right rows ;)
>
> The tables that store import/export specs are:
>
> MsysIMEXspecs
> MsysIMEXcolumns
>
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: Terence
>
> Is there any way to alter a saved export. I have a dozen or so, and all I need to do is change the destination path.
>
> Or do I have to re-create them ?
> Terence
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar