Re: D7-access key problem

Do you have primary keys on detail table (or on all tables affected by
queries)?

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Claude Lec" <livresplus@xxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4428eda7$1@xxxxxxxxxxxxxxxxxxxxxxxxx
D7 ACCESS
I have a master/detail relation with access
On the detail table, if I want to delete one record in the detail
which is more than one time in the details table, I have the exception
"Information on the Key column insuficiant or incorect.To many line are
affected"
But I have just 2 tables with indexe on the 2nd table only on the key
fields
which is index with double possible.
Any Idea
Claude



.

Relevant Pages

  • Re: Access Migration to SQL
    ... you need to move it to SQL Server, and then rewrite all your queries, sprocs and views on the database side and not on the clientside ... First thing to check, make sure that all the primary keys are correctly defined for each tables and that if you have multiple indexes for a table, that the primary key is clusterized and if it's not, that there are no other index clusterized and that the name for the primary key is the first one in alphabetical order. ... If it's still too slow after that, you will have to dig further: use Terminal Server is you are on a very slow LAN or on a VPN, change the design of your frontend in order to retrieve the minimal number of records.; create and use Views, use passthrough queries, create your own recordsets or use unbound forms, switch to ADP or even better, switch to .NET. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server 2000 and Latching problem
    ... While the way we indexed our tables and the way we wrote the queries etc ... "chances are you are getting latches because you are ... query on the results the query .. ... SQL Server 2000 and Latching problem ...
    (microsoft.public.sqlserver.connect)
  • Re: Sql server as back end
    ... There is an option in the Tools menu, Database Utilities, for Upsize to SQL Server. ... But after that, the queries should generally work, shouldn't they? ...
    (microsoft.public.access.tablesdbdesign)