Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

updating data from access into sybase database - need help.

3 posts in Windows NT Last posting was on 2000-07-13 14:49:45.0Z
Jorge Ferreira Posted on 2000-07-13 11:22:27.0Z
From: "Jorge Ferreira" <jorge.manuel.ferreira@tmn.pt>
Subject: updating data from access into sybase database - need help.
Message-ID: <01bfecbb$ba9aa640$af828eb4@tmnp01058802.tmn.pt>
X-Newsreader: Microsoft Internet News 4.70.1154
Newsgroups: sybase.public.sqlserver.nt
Date: Thu, 13 Jul 2000 07:22:27 -0400
Lines: 7
NNTP-Posting-Host: tmnaccess.tmn.pt 194.65.141.142
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1900
Article PK: 1089314

I´m having problems updating data from access into sybase.
I tried linking the tables from ODBC(with full permitions) but he doesn't
let me modify the data in the tables.
The only way i can modify data is by using the sybase central.

thanks.


dave Posted on 2000-07-13 14:14:23.0Z
Message-ID: <396DCEBF.C23A832E@nospam.com>
Date: Thu, 13 Jul 2000 07:14:23 -0700
From: dave <dave@nospam.com>
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: updating data from access into sybase database - need help.
References: <01bfecbb$ba9aa640$af828eb4@tmnp01058802.tmn.pt>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 11
NNTP-Posting-Host: SD-128-124.usaw.bah.com 128.229.128.124
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1899
Article PK: 1089316

when you link your tables in access, make sure that you specify the
primary key or access will not let you modify the data.

Jorge Ferreira wrote:
>
> I´m having problems updating data from access into sybase.
> I tried linking the tables from ODBC(with full permitions) but he doesn't
> let me modify the data in the tables.
> The only way i can modify data is by using the sybase central.
>
> thanks.
>


Jorge Ferreira Posted on 2000-07-13 14:49:45.0Z
From: "Jorge Ferreira" <jorge.manuel.ferreira@tmn.pt>
Subject: Re: updating data from access into sybase database - need help.
References: <01bfecbb$ba9aa640$af828eb4@tmnp01058802.tmn.pt> <396DCEBF.C23A832E@nospam.com>
Message-ID: <01bfecd8$b08d3b00$af828eb4@tmnp01058802.tmn.pt>
X-Newsreader: Microsoft Internet News 4.70.1154
Newsgroups: sybase.public.sqlserver.nt
Date: Thu, 13 Jul 2000 10:49:45 -0400
Lines: 19
NNTP-Posting-Host: tmnaccess.tmn.pt 194.65.141.142
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1898
Article PK: 1089308

thanks now i can modify data, but when i try to close the table access
gives this message ' ODBC -- update on a linked table 'table name' failed.
'
why can't i change data if i have admin permitions.

thanks

dave <dave@nospam.com> wrote in article <396DCEBF.C23A832E@nospam.com>...
> when you link your tables in access, make sure that you specify the
> primary key or access will not let you modify the data.
>
> Jorge Ferreira wrote:
> >
> > I´m having problems updating data from access into sybase.
> > I tried linking the tables from ODBC(with full permitions) but he
doesn't
> > let me modify the data in the tables.
> > The only way i can modify data is by using the sybase central.
> >
> > thanks.
> >
>