Re: Access 97 to SQL Conversion

You are so right! I am upgrading the program as we speak. Thanks!

Dianne

"Mary Chipman [MSFT]" wrote:

> Is your front-end Access 97? If so, then you'll solve a lot of your
> problems by upgrading to Access 2003. Access 97 is no longer
> supported, and never worked smoothly with SQLS 2000, mostly due to
> data type incompatibilities.
>
> --Mary
>
> On Fri, 20 May 2005 11:49:37 -0700, Dianne
> <Dianne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >I have an Access 97 program that for many years linked to tables in another
> >database through drive letter access. Recently, because of speed, we
> >converted the Access tables to a SQL Server 2000 database and linked the
> >tables via an ODBC connection.
> >
> >The program can read the tables but there are several problems. The append
> >queries that are trying to build new records in one of the SQL tables keep
> >giving a key violation error. Also, a few of the screens used to append
> >records to some of the tables no longer let me add records. It will show the
> >records that were originally imported, and let me delete them, but not add.
> >
> >The first time I converted, many of the Access queries wouldn't work and we
> >discovered that in the conversion, the Autonumbering in many of the tables
> >got lost. Since then, I have set the Identity to Yes and when viewing the
> >design of the ODBC tables through Access, they are now showing as Autonumber.
> >
> >Is there some incompatibility between Access 97 and SQL server 2000, or do I
> >have the wrong data types in the SQL tables? Is there something wrong with
> >the way I set up Autonumbering in SQL? When the data was all in Access, I
> >had no problem appending records, but now that the data is in SQL..... what
> >am I missing?
> >
> >Please help!
> >
> >Thanks,
> >
> >Dianne
>
>
.

Relevant Pages

  • Re: Access 97 to SQL Conversion
    ... "Dianne" wrote: ... >> data type incompatibilities. ... >>>have the wrong data types in the SQL tables? ... >>>the way I set up Autonumbering in SQL? ...
    (microsoft.public.sqlserver.odbc)
  • Re: Access 97 to SQL Conversion
    ... data type incompatibilities. ... >queries that are trying to build new records in one of the SQL tables keep ... a few of the screens used to append ... >the way I set up Autonumbering in SQL? ...
    (microsoft.public.sqlserver.odbc)
  • Re: Data Problems creating view to Access Database
    ... It probably is a data type incompatability problem then, ... We will be upgrading the database in the new future anyway. ... Unlike Access, SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Express - Identity specification property - how to change
    ... FOO_ID int identity, ... Tony Rogerson, SQL Server MVP ... They are making unfortunately frequent use of the IDENTITY column in conjunction with Primary Key. ... IDENTITY has none of the properties of a data type because it is not a data type at all. ...
    (comp.databases.ms-sqlserver)
  • Re: Type Mismatch Error Message
    ... >> Using Text as SQL data type. ... I created a database on a SQL server manually and matched the column names ... I thought you "didn't use the database wizard?" ... >> Data type in form is No Constraints. ...
    (microsoft.public.frontpage.programming)