473,231 Members | 1,902 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,231 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 1216

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...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
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: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.