Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Neil Newsgroups: comp.databases.ms-access Subject: Re: Can an Access 2013 database link to an Access 97 back end? Date: Fri, 03 Oct 2014 00:51:37 -0500 Organization: A noiseless patient Spider Lines: 76 Message-ID: <542E3969.4020807@gmail.com> References: <3027f50c-eb61-430f-bbf6-ac9a1740d48d@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Injection-Info: mx05.eternal-september.org; posting-host="9768a1193dc012cfc531ce57a9e79a74"; logging-data="5998"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18n6ckxAEVFre/diiAFCUGM" User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.1.2 In-Reply-To: Cancel-Lock: sha1:HbKUFIWUnaEYc0GYjIU/61/sD08= Xref: csiph.com comp.databases.ms-access: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