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

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

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

Show all headers | View raw

On 10/2/2014 2:37 AM, Phil wrote:
> On 02/10/2014 00:42:28, 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 usi
>> ng
>>>
>>>>>
>>>
>>>>> 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 mappi
>>> ng issues or something similar.
>>>
>>> ng issues or something similar.
>>>>
>>> ng issues or something similar.
>>>
>>> ng issues or something similar.
>>> No, that article just says to convert the back end to ACCDB. I need to
>>> ng issues or something similar.
>>>
>>> ng issues or something similar.
>>> keep the back end in A97 (another system also uses it, and it has to be
>> ng issues or something similar.
>>
>>>
>>> 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-an
>> d-modified-functionality-in-Access-2013-bc006fc3-5b48-499e-8c7d-9a2dfef68e2
>> f?ui=en-US&rs=en-US&ad=US It said A2013 removed support to connect t o
>> A97. You are not getting good news. Good luck.
>>

> I can't vouch for Access 2013, but Access with 2010 you just link the tables
> in the normal way. Why haven’t you tried it?
>

Yes, A10 works fine with A97; but the client doesn't want to be forever 
downgrading to A10 every time he gets a new machine. I have a workaround 
worked out that will satisfy his requirements. (See previous note to 
Patrick in this thread if you're interested.)

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