[AccessD] Re-linking Issue

Jim Dettman jimdettman at verizon.net
Fri Feb 22 12:28:51 CST 2013


  Wait...you said Access 97 didn't you?  The DB needs to be in JET 4.0
format at least (A2000 and up).

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Friday, February 22, 2013 12:53 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Re-linking Issue

Well...what I have now done, is to allow the DB to update itself to 2010,
and after doing this, link manager was enabled. It let me go in and alter
the link, and I am not in and using the program. I think I just learned
something, because I never knew this to be the case. 
 
This won't fix me for good though, because I don't think that department is
all up to date and on 2010. So, I've got to find out what version they do
have and go from there. 

>>> "Jim Dettman" <jimdettman at verizon.net> 2/22/2013 12:12 PM >>>
<<But, my immediate question...my request fro y'all...is how to open link
manager? It is grayed out, and I'm thinking the reason is that I am now
using MS Access 2010, and these programs report as being "Access 97 file
format." Is this the case...that since they are in a different format, link
manager won't run? And, if so, how can I get around this?>>

Still should work.  What's most likely is that it was not installed.  The
other issue is if it is a runtime version. Wizards are not available under
the runtime.

  You can double check quick by creating a blank DB in 2010, link to a
external table, then see if the linked table manager is still grayed out.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Friday, February 22, 2013 11:53 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Re-linking Issue

OK...thank you all for your advise and comments in my last post. This is a
continuation...sort of...of the same mess. Different program this time, but
it all stems from our recent network move. 

Of all the Access DBs not working, there were only two that I was really
responsible for. Both for the same department, and both with similar
problems. The rest of them were simple little network/rights issues, but
mine, which were done in the Front-End/Back-End fashion, both came down to
bad links...

The first one was a relatively simple fix, and we did it from the network,
rather than Access itself...because Access wouldn't let us. The link was
broken to the data on the Back-end, and it was a drive mapping that no
longer existed. One of our new policies that we have adopted is to no longer
map anyone to the root of a network drive...it isn't necessary. But, these
programs were written under the old network scheme and we had an "H:"
mapping for just about everyone that took them to the root of the servers.
So, going with that flow, I linked using that H: mapping. So, to fix this,
we swallowed our pride and added a new H: mapping...for those users that
absolutely need it only. 

Now, I was always a fan of UNC, so if I used an actual mapping, I must have
had to. And, I seem to remember Access, at one time, disallowing UNC format
for linking. But, that must have changed, because the 2nd DB that we're now
having a problem with also has a broken link, but this time the link seems
to be the UNC path, rather than a drive letter. 

The error that was reported to me however, pointed to a different problem.
It said they were getting "...error 3042 - Out of MS-DOS file handles."
Looking this up pointed me in the direction of security and rights. But,
after verifying that all rights are properly setup, I looked deeper into
Access. Right away I discovered the link issue. ...however, I'm thinking, as
I type this, they should have been able to access the front end, which just
has a menu, until the chose a button on that menu...so maybe I'm having
another issue as well. 

But, my immediate question...my request fro y'all...is how to open link
manager? It is grayed out, and I'm thinking the reason is that I am now
using MS Access 2010, and these programs report as being "Access 97 file
format." Is this the case...that since they are in a different format, link
manager won't run? And, if so, how can I get around this?

What I plan to do, while waiting for your help, is to try allowing Access to
update this to the newer version...w/a backup of course...and then go from
there. There is some pretty hefty code behind these programs though, so I'm
not sure this will work. If it updates, and continues to run, then I'm
hoping link manager is then enabled. 

If this does not work, I'm trying to find a workstation...hopefully one of
theirs...that has an older version of Access. Then maybe I can remote in and
use there PC to do the change. 

So, if anyone has any ideas regarding the relinking and/or the error, I'd
appreciate the help.

Thank you

John W Clark

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list