Re: Linking SQL Server 2000 to Access - Bigint datatype

From: Ken McAndrew (kmcandrew_at_infoconcepts.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 10:40:29 -0500

I'm using Access 2003 to generate the database, but it's in Access 2000
format. I did try converting it to Access 2002-2003 format using the
database utilities, but it had the same problems. 

-- 
Kenneth S. McAndrew
Software Developer, Information Concepts
kmcandrew@infoconcepts.com
"Brian Moran" <brian@solidqualitylearning.com> wrote in message
news:O7cd0PMGEHA.3568@tk2msftngp13.phx.gbl...
> What version of Access are you using? I hadn't known about this particular
> issue, but I can understand why it's happening. Perhaps a newer version of
> Access knows about BIGINT? Although that may not be a viable solution for
> you anyway?
>
> -- 
>
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
>
> "Ken McAndrew" <kmcandrew@infoconcepts.com> wrote in message
> news:ej4kwpLGEHA.740@tk2msftngp13.phx.gbl...
> > I'm currently trying to create an Access database that has links to SQL
> > Server views, so that end users can directly edit their data. When I
link
> > these SQL views into Access, however, I'm given the "#DELETED" message
> > across all my rows. I've narrowed down the issue to the bigint datatype;
> it
> > appears that Access is not equipped to handle it. I tried this in both
an
> > Access 2000 and Access 2002-2003 format database.
> >
> > One of my colleagues suggested using a CAST to change the datatype of
the
> > bigint to an int [CAST(<field> as int)], which works fine for display
> > purposes, the SQL view comes up in Access. However, when I attempt to
edit
> > the data, I get the following message:
> >
> > Update or insert of view or function '<name>' failed because it contains
a
> > derived or constant field. (#4406)
> >
> > In doing a Google search, I found the MySQL ODBC connector program has a
> > "convert bigint to int" option, but a similar tool doesn't seem to exist
> in
> > the Microsoft ODBC administrator.
> >
> > Does anyone have any ideas on how to make this viable?
> >
> > Thanks.
> >
> > -- 
> >
> > Kenneth S. McAndrew
> > Software Developer, Information Concepts
> > kmcandrew@infoconcepts.com
> >
> >
> >
>
>

Relevant Pages

  • Re: GEDOM as a database format
    ... industrial-strength SQL databases like SQL Server and Oracle. ... I worked in the area of multi-dimensional database ... your database to some format that the utility understands, ... Subject: re GEDCOM ...
    (soc.genealogy.computing)
  • Re: Create Non Access DB with VB??
    ... but then that isn't really a database. ... Application and the "MDB" file format, yet their is a distinction between ... > And then just write a VB app to interact with one of those! ... You could also do it with ASP using either Access or SQL ...
    (microsoft.public.vb.database)
  • Re: GridView basics
    ... I must format is e.Row.DataItem.ItemArray, ... On 31 aug, 14:56, "Eliyahu Goldin" ... database. ... end up with a bulky sql. ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Linking SQL Server 2000 to Access - Bigint datatype
    ... I'm using Access 2003 to generate the database, ... I did try converting it to Access 2002-2003 format using the ... >> I'm currently trying to create an Access database that has links to SQL ... I've narrowed down the issue to the bigint datatype; ...
    (microsoft.public.sqlserver.server)
  • Re: Linking SQL Server 2000 to Access - Bigint datatype
    ... I'm using Access 2003 to generate the database, ... I did try converting it to Access 2002-2003 format using the ... >> I'm currently trying to create an Access database that has links to SQL ... I've narrowed down the issue to the bigint datatype; ...
    (microsoft.public.sqlserver.odbc)