Re: Modifying Sql server data through Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Simple: add a column with an identity value (or autoincrement field in SQL
parlor) as the primary key to be used with these tables.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"romiorojo via AccessMonster.com" <u23440@uwe> wrote in message
news:626c13c1771c6@xxxxxx
Hello,
I cannot give primary key to some of the tables as some tables are temp
tables and store any kind of dupliate information on any key combinations.
So
what should be the solution?


Sylvain Lafontaine wrote:
Make sure that you have defined a primary key for each table and Access
shouldn't ask to supply the field for indexing.

Also, this newsgroup is about ADP, not ODBC linked tables.

We are planning to move our database from Access to Sql server.But the
front
[quoted text clipped - 7 lines]
have any data not corresponding to a key.What is the best solution for
this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200606/1


.

Relevant Pages

  • Row cannot be located for updating
    ... I have a master table and a detail table. ... (autoincrement field and primary key in MasterTable) ... with the proper ID value! ... I've just discovered that even the primary key of MasterTable ...
    (borland.public.delphi.database.ado)
  • Re: Row cannot be located for updating
    ... Both primary keys in MasterTable and DetailTable are Autoincrement field ... But the problem seems to be on the Primary key fields, ... > The master linking field in the detail table needs to be of type Integer ...
    (borland.public.delphi.database.ado)
  • Re: Upsizing
    ... >> first look into the possibility of a missing primary key. ... >> Sylvain Lafontaine, ing. ... >>>I have upsized an Access database to an SQL database via the Access ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Row cannot be located for updating
    ... Value 0 appears only after posting the record, ... I didn’t write any single line of code, apart the ones in the AfterPost event. ... Setting the AutoGenerateValue of the persistent field ID (the autoincrement field in the table) to arAutoInc is totally useless. ... If the primary key is set on other kind of fields everything works. ...
    (borland.public.delphi.database.ado)
  • Re: Sort order of Access table without index
    ... Yes, Viatcheslav is correct. ... Without the autoincrement field (used as a ... primary key also), there is not real DB that guarantees it will maintain ... physical chronological order. ...
    (borland.public.delphi.database.ado)