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

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

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

Show all headers | View raw

On 10/3/2014 7:33 AM, Ulrich Möller wrote:
> Am 03.10.2014 um 07:53 schrieb Neil:
>> 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
>
> Hi Neil,
>
> perhaps another idea is not to link the 97 Tables directly but instead
> extend your DB with a module and periodically update your modified data
> in the external 97 DB using ADO. In that case you would not need A10.
>
> Ulrich

Yeah, I tried accessing the A97 table from A13 using OLE DB. Got the 
same message as when I tried to link it.

Back to comp.databases.ms-access | Previous | Next — Previous 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