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

Groups > comp.databases.ms-access > #9948 > unrolled thread

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

Back to article view | Back to comp.databases.ms-access

Contents

  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

#9948 — Can an Access 2013 database link to an Access 97 back end?

Can an Access 2013 database link to an Access 97 back end, perhaps using 
ODBC even?

[toc] | [next] | [standalone]

#9949

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.

[toc] | [prev] | [next] | [standalone]

#9951

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.

[toc] | [prev] | [next] | [standalone]

#9953

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.

[toc] | [prev] | [next] | [standalone]

#9954

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?

Phil

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[toc] | [prev] | [next] | [standalone]

#9960

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

[toc] | [prev] | [next] | [standalone]

#9961

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

[toc] | [prev] | [next] | [standalone]

#9964

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

[toc] | [prev] | [next] | [standalone]

#9972

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.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web