Rabu, 28 Desember 2011

RE: [MS_AccessPros] Re: Add table to a Frontend

John,

Again, who said anything about running the "Linked Table Manager"? Please read the replies carefully.

The "Linked Table Manager" will only display tables that are currently linked.

Duane Hookom
MS Access MVP


To: MS_Access_Professionals@yahoogroups.com
From: jlinux@comcast.net
Date: Wed, 28 Dec 2011 21:26:05 +0000
Subject: [MS_AccessPros] Re: Add table to a Frontend

The problem is that when I run the Linked Table manager the new Table I just created in the backend does not appear in the Update table list and I don't see any way to add it.

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> John,
>
> AdamF didn't say anything about using the "Linked Table Manager". After selecting External Data, click the Access icon to step through finding your backend file and choosing the table(s).
>
>
>
> Duane Hookom
>
> MS Access MVP
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: jlinux@...
> Date: Wed, 28 Dec 2011 20:08:34 +0000
> Subject: [MS_AccessPros] Re: Add table to a Frontend
>
>
>
>
>
> I don't see that in Access 2010. I did click on External Data > Linked Table Manager in the FE, but did not see the Table I just added and the BE has that button grayed out.
>
> --- In MS_Access_Professionals@yahoogroups.com, "AdamF" <runuphillracing@> wrote:
> >
> > From pull down menu at the top:
> > File
> > Get External Data
> > Link Tables
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "yshopper" <jlinux@> wrote:
> > >
> > > I have a split DB and just added a table to the Backend. How do I add that Table to the Frontend?
> > >
> > > Thanks,
> > > John
> > >
> >
>
>
>
>
> .ExternalClass #ecxygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;padding:0 10px;} .ExternalClass #ecxygrp-mkp hr {border:1px solid #d8d8d8;} .ExternalClass #ecxygrp-mkp #ecxhd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;} .ExternalClass #ecxygrp-mkp #ecxads {margin-bottom:10px;} .ExternalClass #ecxygrp-mkp .ecxad {padding:0 0;} .ExternalClass #ecxygrp-mkp .ecxad p {;} .ExternalClass #ecxygrp-mkp .ecxad a {color:#0000ff;text-decoration:none;} .ExternalClass #ecxygrp-sponsor #ecxygrp-lc {font-family:Arial;} .ExternalClass #ecxygrp-sponsor #ecxygrp-lc #ecxhd {font-weight:700;font-size:78%;line-height:122%;} .ExternalClass #ecxygrp-sponsor #ecxygrp-lc .ecxad {margin-bottom:10px;padding:0 0;} .ExternalClass a {color:#1e66ae;} .ExternalClass #ecxactions {font-family:Verdana;font-size:11px;padding:10px 0;} .ExternalClass #ecxactivity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} .ExternalClass #ecxactivity span {font-weight:700;} .ExternalClass #ecxactivity span a {color:#5085b6;text-decoration:none;} .ExternalClass #ecxactivity span span {color:#ff7900;} .ExternalClass #ecxactivity span .ecxunderline {text-decoration:underline;} .ExternalClass .ecxattach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} .ExternalClass .ecxattach div a {text-decoration:none;} .ExternalClass .ecxattach img {border:none;padding-right:5px;} .ExternalClass .ecxattach label {display:block;margin-bottom:5px;} .ExternalClass .ecxattach label a {text-decoration:none;} .ExternalClass blockquote {;} .ExternalClass .ecxbold {font-family:Arial;font-size:13px;font-weight:700;} .ExternalClass .ecxbold a {text-decoration:none;} .ExternalClass dd.ecxlast p a {font-family:Verdana;font-weight:700;} .ExternalClass dd.ecxlast p span {margin-right:10px;font-family:Verdana;font-weight:700;} .ExternalClass dd.ecxlast p span.ecxyshortcuts {margin-right:0;} .ExternalClass div.ecxattach-table div div a {text-decoration:none;} .ExternalClass div.ecxattach-table {width:400px;} .ExternalClass div.ecxfile-title a, .ExternalClass div.ecxfile-title a:active, .ExternalClass div.ecxfile-title a:hover, .ExternalClass div.ecxfile-title a:visited {text-decoration:none;} .ExternalClass div.ecxphoto-title a, .ExternalClass div.ecxphoto-title a:active, .ExternalClass div.ecxphoto-title a:hover, .ExternalClass div.ecxphoto-title a:visited {text-decoration:none;} .ExternalClass ecxdiv#ygrp-mlmsg #ecxygrp-msg p a span.ecxyshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;} .ExternalClass .ecxgreen {color:#628c2a;} .ExternalClass .ecxMsoNormal {;} .ExternalClass ecxo {font-size:0;} .ExternalClass #ecxphotos div {float:left;width:72px;} .ExternalClass #ecxphotos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;} .ExternalClass #ecxphotos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} .ExternalClass #ecxreco-category {font-size:77%;} .ExternalClass #ecxreco-desc {font-size:77%;} .ExternalClass .ecxreplbq {;} .ExternalClass #ecxygrp-mlmsg {font-size:13px;font-family:Arial, helvetica,clean, sans-serif;} .ExternalClass #ecxygrp-mlmsg table {font-size:inherit;font:100%;} .ExternalClass #ecxygrp-mlmsg select, .ExternalClass input, .ExternalClass textarea {font:99% Arial, Helvetica, clean, sans-serif;} .ExternalClass #ecxygrp-mlmsg pre, .ExternalClass code {font:115% monospace;} .ExternalClass #ecxygrp-mlmsg ecx* {line-height:1.22em;} .ExternalClass #ecxygrp-mlmsg #ecxlogo {padding-bottom:10px;} .ExternalClass #ecxygrp-mlmsg a {color:#1E66AE;} .ExternalClass #ecxygrp-msg p a {font-family:Verdana;} .ExternalClass #ecxygrp-msg ecxp#attach-count span {color:#1E66AE;font-weight:700;} .ExternalClass #ecxygrp-reco #ecxreco-head {color:#ff7900;font-weight:700;} .ExternalClass #ecxygrp-reco {margin-bottom:20px;padding:0px;} .ExternalClass #ecxygrp-sponsor #ecxov li a {font-size:130%;text-decoration:none;} .ExternalClass #ecxygrp-sponsor #ecxov li {font-size:77%;list-style-type:square;padding:6px 0;} .ExternalClass #ecxygrp-sponsor #ecxov ul {padding:0 0 0 8px;} .ExternalClass #ecxygrp-text {font-family:Georgia;} .ExternalClass #ecxygrp-text p {;} .ExternalClass #ecxygrp-text tt {font-size:120%;}
>

.ExternalClass #ecxygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;padding:0 10px;} .ExternalClass #ecxygrp-mkp hr {border:1px solid #d8d8d8;} .ExternalClass #ecxygrp-mkp #ecxhd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;} .ExternalClass #ecxygrp-mkp #ecxads {margin-bottom:10px;} .ExternalClass #ecxygrp-mkp .ecxad {padding:0 0;} .ExternalClass #ecxygrp-mkp .ecxad p {;} .ExternalClass #ecxygrp-mkp .ecxad a {color:#0000ff;text-decoration:none;} .ExternalClass #ecxygrp-sponsor #ecxygrp-lc {font-family:Arial;} .ExternalClass #ecxygrp-sponsor #ecxygrp-lc #ecxhd {font-weight:700;font-size:78%;line-height:122%;} .ExternalClass #ecxygrp-sponsor #ecxygrp-lc .ecxad {margin-bottom:10px;padding:0 0;} .ExternalClass a {color:#1e66ae;} .ExternalClass #ecxactions {font-family:Verdana;font-size:11px;padding:10px 0;} .ExternalClass #ecxactivity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} .ExternalClass #ecxactivity span {font-weight:700;} .ExternalClass #ecxactivity span a {color:#5085b6;text-decoration:none;} .ExternalClass #ecxactivity span span {color:#ff7900;} .ExternalClass #ecxactivity span .ecxunderline {text-decoration:underline;} .ExternalClass .ecxattach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} .ExternalClass .ecxattach div a {text-decoration:none;} .ExternalClass .ecxattach img {border:none;padding-right:5px;} .ExternalClass .ecxattach label {display:block;margin-bottom:5px;} .ExternalClass .ecxattach label a {text-decoration:none;} .ExternalClass blockquote {;} .ExternalClass .ecxbold {font-family:Arial;font-size:13px;font-weight:700;} .ExternalClass .ecxbold a {text-decoration:none;} .ExternalClass dd.ecxlast p a {font-family:Verdana;font-weight:700;} .ExternalClass dd.ecxlast p span {margin-right:10px;font-family:Verdana;font-weight:700;} .ExternalClass dd.ecxlast p span.ecxyshortcuts {margin-right:0;} .ExternalClass div.ecxattach-table div div a {text-decoration:none;} .ExternalClass div.ecxattach-table {width:400px;} .ExternalClass div.ecxfile-title a, .ExternalClass div.ecxfile-title a:active, .ExternalClass div.ecxfile-title a:hover, .ExternalClass div.ecxfile-title a:visited {text-decoration:none;} .ExternalClass div.ecxphoto-title a, .ExternalClass div.ecxphoto-title a:active, .ExternalClass div.ecxphoto-title a:hover, .ExternalClass div.ecxphoto-title a:visited {text-decoration:none;} .ExternalClass ecxdiv#ygrp-mlmsg #ecxygrp-msg p a span.ecxyshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;} .ExternalClass .ecxgreen {color:#628c2a;} .ExternalClass .ecxMsoNormal {;} .ExternalClass ecxo {font-size:0;} .ExternalClass #ecxphotos div {float:left;width:72px;} .ExternalClass #ecxphotos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;} .ExternalClass #ecxphotos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} .ExternalClass #ecxreco-category {font-size:77%;} .ExternalClass #ecxreco-desc {font-size:77%;} .ExternalClass .ecxreplbq {;} .ExternalClass #ecxygrp-mlmsg {font-size:13px;font-family:Arial, helvetica,clean, sans-serif;} .ExternalClass #ecxygrp-mlmsg table {font-size:inherit;font:100%;} .ExternalClass #ecxygrp-mlmsg select, .ExternalClass input, .ExternalClass textarea {font:99% Arial, Helvetica, clean, sans-serif;} .ExternalClass #ecxygrp-mlmsg pre, .ExternalClass code {font:115% monospace;} .ExternalClass #ecxygrp-mlmsg ecx* {line-height:1.22em;} .ExternalClass #ecxygrp-mlmsg #ecxlogo {padding-bottom:10px;} .ExternalClass #ecxygrp-mlmsg a {color:#1E66AE;} .ExternalClass #ecxygrp-msg p a {font-family:Verdana;} .ExternalClass #ecxygrp-msg ecxp#attach-count span {color:#1E66AE;font-weight:700;} .ExternalClass #ecxygrp-reco #ecxreco-head {color:#ff7900;font-weight:700;} .ExternalClass #ecxygrp-reco {margin-bottom:20px;padding:0px;} .ExternalClass #ecxygrp-sponsor #ecxov li a {font-size:130%;text-decoration:none;} .ExternalClass #ecxygrp-sponsor #ecxov li {font-size:77%;list-style-type:square;padding:6px 0;} .ExternalClass #ecxygrp-sponsor #ecxov ul {padding:0 0 0 8px;} .ExternalClass #ecxygrp-text {font-family:Georgia;} .ExternalClass #ecxygrp-text p {;} .ExternalClass #ecxygrp-text tt {font-size:120%;}

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar