Re: Converting Access 2000 back to 97
From: david epsom dot com dot au (david_at_epsomdotcomdotau)
Date: 01/28/05
- Next message: david epsom dot com dot au: "Re: MSysObjects Name field"
- Previous message: PAUL FRANKS: "2000 TO 2003 ISSUE NEED HELP"
- In reply to: deb gerdes: "Converting Access 2000 back to 97"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 Jan 2005 12:59:30 +1100
Those table links - and tables - are probably not compatible with
Access 97, so your options are limited.
Access 2000+, and recent versions of SQL Server, normally use
'unicode' or 'nVarChar' fields for text. nVarChar fields can't
be used by A97, and if any of your tables use nVarChar fields
you won't be able to link to them.
On the other hand, if this is a old database, using VarChar
fields for text, just delete all the tables/links and then
re-create the links.
You will be able to re-create the links in the A97 database
when you open it in A2000. You won't be able to change any
of the forms or reports, but you will be able to change queries,
macros, tables, and links.
If you have any trouble re-creating the links, you could also
use any of the sample code available to re-create the links.
The sample code often demonstrates linking CurrentDB, but you
can link any database (dao code uses OpenDatabase) using code,
include A97/A2.0 databases.
(david)
"deb gerdes" <debgerdes@discussions.microsoft.com> wrote in message
news:1EF8719B-4FCD-4EFE-94B3-4D55AA428905@microsoft.com...
> I am trying to convert an Access 2000 database back to Access 97. It has
> tables linked to SQL Server. When I try to go to convert it back to 97 it
> converts the Linked tables into Access tables. Is there any way to
convert
> back to 97 and still keep the tables linked?
- Next message: david epsom dot com dot au: "Re: MSysObjects Name field"
- Previous message: PAUL FRANKS: "2000 TO 2003 ISSUE NEED HELP"
- In reply to: deb gerdes: "Converting Access 2000 back to 97"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
