Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #9961

Re: Can an Access 2013 database link to an Access 97 back end?

Show all headers | View raw

On 10/1/2014 6:42 PM, Patrick Finucane wrote:
> On Wednesday, October 1, 2014 5:07:13 PM UTC-4, Neil wrote:
>> On 9/30/2014 8:02 AM, Patrick Finucane wrote:
>>
>>> On Monday, September 29, 2014 5:17:03 PM UTC-4, Neil wrote:
>>
>>>> Can an Access 2013 database link to an Access 97 back end, perhaps using
>>
>>>>
>>
>>>> ODBC even?
>>
>>>
>>
>>> I think this answers the question.  http://office.microsoft.com/en-us/access-help/convert-a-database-to-the-accdb-file-format-HA102749625.aspx.  I don't see why the links to the backend wouldn't work unless you have mapping issues or something similar.
>>
>>>
>>
>> No, that article just says to convert the back end to ACCDB. I need to
>>
>> keep the back end in A97 (another system also uses it, and it has to be
>>
>> in A97 format, as that system is old).
>>
>>
>>
>> I understand A13 not supporting the A97 format for databases, as that
>>
>> format is old. But I don't understand it not allowing to at least link
>>
>> to A97 tables. Seems it should be able to do that. But, apparently, you
>>
>> can't.
>>
>>
>>
>> One person I've spoken with elsewhere was able to relink from A13 to an
>>
>> A97 back end. But other people I've spoken with have not been able to.
>>
>> So it's a bit of puzzle.
>>
>>
>>
>> Thanks.
>
> I went to https://support.office.com/en-US/Article/Discontinued-features-and-modified-functionality-in-Access-2013-bc006fc3-5b48-499e-8c7d-9a2dfef68e2f?ui=en-US&rs=en-US&ad=US  It said A2013 removed support to connect to A97.  You are not getting good news.  Good luck.
>

Yeah, the other person I was talking to (who said he was able to link to 
A97 from A13) said he had done it on a pre-release version of A13. When 
he tried it again on the current version, he couldn't. So, apparently, 
the ability to link to A97 from A13 was originally in A13 (but not the 
ability to open an A97 db); but then they took it out in the final version.

As for my situation, I have a workaround worked out. The client needs to 
keep the A97 file in place, because he has third party software writing 
to it that he can't upgrade. But his new computers have A13 and he 
doesn't want to downgrade to A10. So my solution will be to have A10 
installed on the machine that has the A97, and create a small db that 
links to both the A97 and the A13 back ends. The small db will run 
automatically via Scheduler once a day or more, and will copy any new 
data from the A97 back end into the A13 back end. That way, he can keep 
his A97 file in place for his 3rd party software, but all his users can 
access the data in an A13 back end.

Neil

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Can an Access 2013 database link to an Access 97 back end? Neil <xxx@gmail.com> - 2014-09-29 16:17 -0500
  Re: Can an Access 2013 database link to an Access 97 back end? Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-30 06:02 -0700
    Re: Can an Access 2013 database link to an Access 97 back end? Neil <xxx@gmail.com> - 2014-10-01 16:07 -0500
      Re: Can an Access 2013 database link to an Access 97 back end? Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-10-01 16:42 -0700
        Re: Can an Access 2013 database link to an Access 97 back end? "Phil" <phil@stantonfamily.co.uk> - 2014-10-02 08:37 +0100
          Re: Can an Access 2013 database link to an Access 97 back end? Neil <xxx@gmail.com> - 2014-10-03 00:51 -0500
        Re: Can an Access 2013 database link to an Access 97 back end? Neil <xxx@gmail.com> - 2014-10-03 00:53 -0500
          Re: Can an Access 2013 database link to an Access 97 back end? Ulrich Möller <knobbi38@arcor.de> - 2014-10-03 14:33 +0200
            Re: Can an Access 2013 database link to an Access 97 back end? Neil <xxx@gmail.com> - 2014-10-03 14:32 -0500

csiph-web