Linked table manager question

M

Mark

Hi All,

We have 50 plus linked tables. During a process we reconnect the tables to
a backup db. Previously, all we had to do was select the new linked database
once and all tables were updated. Now however, it asked what db for each
table, even though it's the same db for all the tables.

What could cause this? Is there an option for this?
 
A

Armen Stein

We have 50 plus linked tables. During a process we reconnect the tables to
a backup db. Previously, all we had to do was select the new linked database
once and all tables were updated. Now however, it asked what db for each
table, even though it's the same db for all the tables.

What could cause this? Is there an option for this?
Click to expand...

Hi Mark,

If even 1 table has a different path from the others, even if it's a
drive letter instead of UNC (\\) to the same folder, you'll see this
behavior. That's only one of the reasons why we never use Linked
Table Manager.

If you want a more automated approach to relinking tables, you're
welcome to use our free J Street Access Relinker on our J Street
Downloads page: http://ow.ly/M56Q

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
T

Tom Wickerath

Hi Mark,

I have encountered this many times in the past, and yes, it is very
annoying. The fix is to delete all of the table links from the front-end (FE)
database, do a compact and repair operation (hold down the shift key the
entire time, to prevent any startup form or code from running), and then
establish brand new links, using

Access 2003 and earlier: File | Get External Data | Linked tables...
Access 2007: Database Tools tab on ribbon | Linked Table Manager in Database
Tools group

A much easier method versus the linked table manager is to use VBA code to
handle all of your relinking needs. Access MVP Armen Stein offers free
relinking code on his web site that works for native Access tables (does not
work with linked files of other types, such as text files or linked Excel
files):

http://ow.ly/M2WI (see "J Street Access Relinker")


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
I

iman

Mark said:
Hi All,

We have 50 plus linked tables. During a process we reconnect the tables
to
a backup db. Previously, all we had to do was select the new linked
database
once and all tables were updated. Now however, it asked what db for each
table, even though it's the same db for all the tables.

What could cause this? Is there an option for this?
Click to expand...
 
T

Tom Wickerath

Hi Armen,

I somehow included an embedded space at the end of the ow.ly link I
provided. If you backspace it in the address bar, then the page opens
correctly.
In the future, you can also use the
slightly easier www.jstreettech.com/downloads.
Click to expand...

Yeah, I know, but I've also noticed how that link re-directs to the link I
provided.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
W

Wesley Silveira

Mark said:
Hi All,

We have 50 plus linked tables. During a process we reconnect the tables
to
a backup db. Previously, all we had to do was select the new linked
database
once and all tables were updated. Now however, it asked what db for each
table, even though it's the same db for all the tables.

What could cause this? Is there an option for this?
Click to expand...
 
S

sissy4025

Mark said:
Hi All,

We have 50 plus linked tables. During a process we reconnect the tables
to
a backup db. Previously, all we had to do was select the new linked
database
once and all tables were updated. Now however, it asked what db for each
table, even though it's the same db for all the tables.

What could cause this? Is there an option for this?
Click to expand...
 
D

David W. Fenton

I somehow included an embedded space at the end of the ow.ly link
I provided. If you backspace it in the address bar, then the page
opens correctly.
Click to expand...

What you posted was this:

http://ow.ly/M2WI (see "J Street Access Relinker")

....and if that doesn't get interpreted correctly (i.e., it gets read
with a trailing space), it's a problem with the client you're using
to display the URL and execute it, not with what you posted.

May I also suggest that any time you post a shortened URL, you also
post the full URL. Yes, the full URL with wrap and possibly be
broken, but if the URL-shortening website should go out of business
(at least one major one shut down in the last few months), there's
at least the possibility that someone can reconstruct the target URL
from the mangled full URL. I always post like this:

http://ow.ly/M2WI =>
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

I would also *never* use a URL shortening service that frames the
main site (as is the case with ow.ly) -- I'd only use one that gets
out of the way and just redirects to the target website. I still use
TinyURL.com, but it's not as popular as others.
 
A

Armen Stein

On 17 Jan 2010 19:40:26 GMT, "David W. Fenton"

Hi David,
May I also suggest that any time you post a shortened URL, you also
post the full URL. Yes, the full URL with wrap and possibly be
broken, but if the URL-shortening website should go out of business
(at least one major one shut down in the last few months), there's
at least the possibility that someone can reconstruct the target URL
from the mangled full URL.
Click to expand...

Yes, but shortening isn't my only goal. I was curious about the
amount of traffic the public newsgroups generated vs other sources,
and hootsuite provides summary traffic stats.
I would also *never* use a URL shortening service that frames the
main site (as is the case with ow.ly) -- I'd only use one that gets
out of the way and just redirects to the target website. I still use
TinyURL.com, but it's not as popular as others.
Click to expand...

Well, that's the trade-off for the traffic stats. At least
hootsuite's top bar is quite minimal. It's an experiment. I'll try
it for a while and perhaps switch to something else, or just back to
the direct links.

Thanks,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
T

Tom Wickerath

....and if that doesn't get interpreted correctly (i.e., it gets read
with a trailing space), it's a problem with the client you're using
to display the URL and execute it, not with what you posted.
Click to expand...

I'm using IE 8.0, on a laptop PC that only has a few favorites saved to
date. And, yes, I do use the Web Interface that many of the regulars have a
strong dislike of, but that's a different discussion.

My regular desktop PC has literally hundreds of bookmarked pages related to
MS Access stuff. When I was answering this question, I needed a link to
Armen's download page, which, of course, I didn't have bookmarked on the
laptop yet.

Side note to Armen:
Your downloads link is not so easy for me to find, by starting at J Street's
home page.

However, I had just read a reply in this newsgroup, from Armen about 20
minutes earlier, where he had provided the shortened ow.ly link to his
downloads page. So, I went back to this reply:

Subject: Re: access2003/sqlserver2005 performance issue
1/16/2010 11:05 AM PST
By: Armen Stein
In: microsoft.public.access

Here's a link to the reply in question, so that you can see it as I did:

http://www.microsoft.com/office/com...39cc0b-7147-4b5b-8546-18df359261e2&sloc=en-us


I copied the URL and pasted it into my reply. Unbeknownst to me, Armen had
posted a link with an embedded space as well, so my actions just replicated
the mistake.
May I also suggest that any time you post a shortened URL, you also
post the full URL.
Click to expand...

Usually, I only post the full URL. In this case, I did not have the needed
URL bookmarked, and it wasn't easy for me to find it (I did actually look
first). I do have one saved TinyURL that I tend to post for questions related
to bloat in JET databases. In that case, the TinyURL opens up a KB search
that has several articles on this subject. So, it's really not that practical
to try to bookmark each of those individually, and then copy them into a
reply later. I'd have to perhaps store them in a text file for easy copy and
paste of all the applicable URLs. I do validate that this TinyURL works each
time, before I post it.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
A

Armen Stein

I'm using IE 8.0, on a laptop PC that only has a few favorites saved to
date. And, yes, I do use the Web Interface that many of the regulars have a
strong dislike of, but that's a different discussion.
Click to expand...

I'm using Agent, so that's a difference. However, I don't like how
Agent launches links directly, so I usually copy & paste them into a
browser (usually Chrome).
Side note to Armen:
Your downloads link is not so easy for me to find, by starting at J Street's
home page.
Click to expand...

It's a matter of real estate. We have hundreds of pages on our site,
and we try to focus on the ones that generate revenue. :) The
downloads page is two clicks from the home page - Custom Programming,
then Downloads.

Also, both Bing and Google searches for J Street Downloads are well
indexed with our Downloads page as the first result.
However, I had just read a reply in this newsgroup, from Armen about 20
minutes earlier, where he had provided the shortened ow.ly link to his
downloads page. So, I went back to this reply:

Subject: Re: access2003/sqlserver2005 performance issue
1/16/2010 11:05 AM PST
By: Armen Stein
In: microsoft.public.access

Here's a link to the reply in question, so that you can see it as I did:

http://www.microsoft.com/office/com...39cc0b-7147-4b5b-8546-18df359261e2&sloc=en-us


I copied the URL and pasted it into my reply. Unbeknownst to me, Armen had
posted a link with an embedded space as well, so my actions just replicated
the mistake.
Click to expand...

I'm confused. I just opened the community thread using the link
above, and then clicked on my original ow.ly and it worked just fine.
I also copied and pasted it into a browser and it worked that way too.
I see no embedded space in any of my shortened links. What's going
on?

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
D

David W. Fenton

Here's a link to the reply in question, so that you can see it as
I did:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=mic
rosoft.public.access&mid=4a39cc0b-7147-4b5b-8546-18df359261e2&sloc=
en-us


I copied the URL and pasted it into my reply. Unbeknownst to me,
Armen had posted a link with an embedded space as well, so my
actions just replicated the mistake.
Click to expand...

No, he did no such thing. And the MS website is not screwing it up,
either -- it's IE that's making the mistake. When you choose "copy
shortcut" form the right click menu it includes the trailing space.
If you do the same thing in FireFox, it rightly trims the trailing
space. A trailing space is not and cannot be a valid part of a URL.

I just don't understand why anyone in their right mind would
voluntarily use IE. For heaven's sake, the German government just
recommended (based on the recently discovered zero-day exploit) that
nobody use IE at all. I've been recommending that since summer 2001,
the point at which Mozilla reached a level of maturity and
performance that made it a vastly superior alternative to IE. It was
not until 2007 that IE offered tabbed browsing and MS started fixing
IE's security and rendering problems. Yes, IE is vastly improved,
but it still supports ActiveX and as long as that's the case, it
can't possibly be made safe by any means.

Do yourself a favor and get a better browser, if not FireFox, then
Google Chrome, or Apple Safari (the most recent Windows version is
quite good) or Opera. All are much better than IE, hands down (it's
not even a close race).
 
D

David W. Fenton

I'm confused. I just opened the community thread using the link
above, and then clicked on my original ow.ly and it worked just
fine. I also copied and pasted it into a browser and it worked
that way too. I see no embedded space in any of my shortened
links. What's going on?
Click to expand...

It's an IE problem. It doesn't trim the trailing space.
 
T

Tom Wickerath

No, he did no such thing. And the MS website is not screwing it up,
either -- it's IE that's making the mistake. When you choose "copy
shortcut" form the right click menu it includes the trailing space.
Click to expand...

What makes you *assume* that I copied the shortcut using the right-click
menu? I did not....in fact, I didn't even know that worked until after
reading the above. I had manually selected the link (I apparently selected
the trailing space as well) and then used <Ctrl><C> to copy it.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create one table using multiple linked tables 6
Problem with Linked Table Manager 1
Is there a way to automatically relink linked tables when opening. 1
Access 2007 - Copy linked table to a local table or have linked tableas read-only 0
linked table manager not working 3
Linked Table Manager Errors 12
Delete Tables 2
Property Description of a Linked Table 1

Top