473,320 Members | 1,802 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Stumped when using the Data Adapter Configration Wizard...

Ive got what must bea very basic question, but its got ne
thouroughly stumped. Im writing a very simple application
in Visual Basic.Ne 2003, thats using a data adapter hooked
up to an Access database. The data adapter configuration
wizard generates both insert, and select statements, but
on the final page of the wizard it says that update, and
delete statements could not be generated. The reason that
Im given for this happeneing is "could not determine which
columns uniquely indentify the rows for 'names' ". (Names
is the table in the access database that I am using.) I
have checked, and there is a primary key on the table, and
that column is included in the select statement of the
data adapter. Other than that Im not sure what I should be
looking for. Can anyone point me in the direction that I
shoudl be looking to resolve this ?

Any help that can be provided is greatly appreciated!!
Nov 20 '05 #1
0 1220

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dermot O'Loughlin | last post by:
Can anyone help me with this? I get the following error when using the odbc adapter wizard in VS.Net 2003: --------------------------- Wizard Form --------------------------- An unexpected...
3
by: Simon | last post by:
Hi everyone, I have a small problem regarding a wizard that I'm making on my website. The wizard is obviously a series of pages that take values from the user. My question is: - Should I...
2
by: SirPoonga | last post by:
Lets say I have a couple of tables in a database containg car make, type, and model. I want to create a drop down box that is populated by the makes. Based on that selection run a query to get...
2
by: Parveen | last post by:
I want the data adapter wizard to automatically generate update, insert, and delete statements from a given select statement if the select statement is a multiple table query. I know this works...
2
by: M Sameer Haider | last post by:
I am trying to use SQL statement in my Data Adapter Configuration wizard. Can anyone help me to write a query which will selest some field from different tables from a relational database and...
1
by: Hugh Barnett | last post by:
I am using Visual Studio to create a VB .NET application to run on Windows 2000. I am trying to display data from a Sybase ASA table in a form, allow the user to update the data in the form, and...
1
by: Demetri | last post by:
I have a question / concern regarding the new suggested way of creating a data access layer in an n-tier application. Typically, a web application specifically, using the SOA (Service Oriented...
2
by: Paul Craig | last post by:
Hi everyone, I have recently upgraded several of my projects from Visual Studio 2003 to 2005 and everything went across quite smoothly. The main problem that I am having is I have used SQL Data...
5
by: Alan Pretre | last post by:
In VS 2003 when I use the Configure Data Adapter option in VS 2003 I get the size parameter to the SqlParameter set to the correct size for a varchar, for example, .... new...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.