Stack Overflow
Stack Overflow

Questions tagged [accessdatasource]

The AccessDataSource class is a data source control that works with Microsoft Access databases. Like its base class, SqlDataSource, the AccessDataSource control uses SQL queries to perform data retrieval.

The AccessDataSource class is a data source control that works with Microsoft Access database files. Like its base class, SqlDataSource, the AccessDataSource control uses SQL queries to perform data retrieval.

AccessDataSource Class on Microsoft Docs

10 questions
0
votes
0 answers

System.Data.OleDb.OleDbException: 'An INSERT INTO query cannot contain a multi-valued field.'

I was trying to use the insert query on a small vb application. When I typed in the data and tried to upload it via a button, an error shows up: System.Data.OleDb.OleDbException: 'An INSERT INTO query cannot contain a multi-valued field.' I have…
user22007770
  • 1
0
votes
1 answer

How to Export the Data/ Table containing more than 100k records From an Access Database to an Excel format

How to Export the Data/ Table containing more than 100k records) From an Access Database to an Excel format. I tried by unchecking export data with formatting and layout option in .xlsx file format. But i can see that some data is missing in some…
user9342493
  • 21
  • 5
0
votes
1 answer

How to remove hidden connection strings

I have a vs winform application which gets its datasources from a configuration file (app.config). I had connections to several databases. I have now removed some of them so that I am remaining with only one database and one connection…
Hannington Mambo
  • 998
  • 2
  • 13
  • 28
0
votes
1 answer

Enable "Access data sources across domains" in IE 11

I am trying to enable the "Access data sources across domains" flag in IE11 but it is disabled by default and I am unable to update it. Is there any way I can tweak some registry flag to enable the same. My objective is to handle the…
Aakash Jain
  • 730
  • 1
  • 12
  • 31
0
votes
3 answers

How to group columns when the value repeats in sql

I connected my Access DB to an Excel file and executed a few simple SQL queries and I want to do something that I don't know if it is possible. I want to group values in columns when the values repeat. For example, here is a simple query results: ID…
Gilad K
  • 17
  • 5
0
votes
1 answer

Syntax error in FROM clause Access

I want to read the data from Access Database in order to check if a password is correct or not. I use this code: var check=false; OleDbCommand c = new OleDbCommand(); c.Connection = co //the connection to the Database; c.CommandText = "select * FROM…
Mohamed Mostafa
  • 25
  • 7
0
votes
1 answer

Update command on AccessDataSource doesn't update table as expected

Update button executes the query, but nothing shows up in my database. Any thoughts as to why? I've moved it in and out of an UpdatePanel. I've tried with the couple of variations on the variables like @Atty_ID or ?, but I can't seem to get it to…
Joseph
  • 609
  • 2
  • 12
  • 26
-1
votes
2 answers

Exception thrown when executing query

I have vb.net app form, it contains id as combobox. after click on edit buton & chose an other id, i found error Like the picture below.so what to do? Private Sub searchparfum() Dim dt As New DataTable Dim ds As New DataSet …
ayoub
  • 3
  • 3
-1
votes
2 answers

How do I update an an Access database from a GridView in Visual Studio?

I'm trying to update an access database when using a Grid View in Visual Studio 2010 but not having any success. Let me try and explain what I have. I have an access database with a table "tblConfirmedworkhours" which has fields "dateworked" &…
Chris Music
  • 109
  • 11
-4
votes
2 answers

change of location of the database dynamically in app running

Try to make my app read the ms-access database from shortcut of my database it failed to read, so try to change the location of database dynamically ( there is an option in the app to move the database to drop-box folder and create a shortcut to…
Mahmoud Hiyani
  • 1