Click here to Skip to main content
15,887,027 members
Everything / Productivity Apps and Services / Microsoft Office / Microsoft Access

Microsoft Access

MS-Access

Great Reads

by William Hey
Classical number theories
by Rob Culhane
How to dynamically add access database columns at runtime using VB.NET
by William Hey
Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.
by Clifford Nelson
This is a tip that has the code for selecting an Excel file and sheet for import into Microsoft Access. This includes the code required to browse for a file, and populate a ListBox with the sheets of the Excel Workbook, and the code to import an Excel spreadsheet.

Latest Articles

by DotNetLead.com
Azure AD for authentication and authorization of users for your website
by Gustav Brock
Format amounts in VBA using the Indian number format for currency and amounts
by Clifford Nelson
Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

All Articles

Sort by Updated

Microsoft Access 

26 Jan 2010 by #realJSOP
A lot of your classmates have already asked this question. Search the C# forum for "matlab".
14 Apr 2010 by #realJSOP
Make sure that the service class inherits from System.Web.Services.Service.Without this you don't have access to the Server object.
17 Jan 2011 by #realJSOP
Googled the phrase "asp.net ms-access database", and among the 6.5 MILLION hits returned by google:http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/[^]
18 Apr 2011 by #realJSOP
We're not here to write code for you. Write the code, try to make it work. If you have a specific question about a specific part of your code that is not working, come back here and ask that question.
12 Jun 2011 by #realJSOP
Are you double-damn sure that the file exists?
11 Jul 2011 by #realJSOP
You mean the user Login?ALTER LOGIN Account_Name WITHPASSWORD = @newPasswordOLD_PASSWORD = @oldPassword;
29 Aug 2011 by #realJSOP
Beyod the obvious answer involving your reluctance to use google, you have to improve your question. Import/export involves a destination and source for the data, which you have failed to provide.
29 Aug 2011 by #realJSOP
Backing up "only selected tables" is a poor backup strategy. Since the entire database is located in one MBD file, your best strategy is just to copy the file to a different location.
19 Dec 2011 by #realJSOP
Setup a Timer that sets the Progressbar.Value property once every second. How far the progressbar goes with each update depends on how long you want to run befor the progress bar reaches 100 percent. If you want it to reach 100% in 60 seconds, you have to perform math on the value.Dim...
27 Dec 2011 by #realJSOP
This might help, but no guarantees:http://office.microsoft.com/en-us/office-xp-resource-kit/administering-fonts-HA001136393.aspx?redir=0[^]
27 Oct 2016 by #realJSOP
You could delete the selected row(s) from the database, THEN re-fetch the data, and refresh the gridview...
25 Nov 2016 by #realJSOP
DO NOT migrate backwards. Access has more issues than the Hillary Clinton does with the FBI.All you have to do is make SqlServer (in one for or another) a requirement of using your software. Your installer can install it for them.Check this link that compares the different sql server...
31 Dec 2016 by #realJSOP
You can use an access database, but not "run" the application itself. Here's a static class I use to get/put data in an Access database. If this isn't what you need, you're going to have to improve your question.using System;using System.Collections.Generic;using System.Data;using...
4 Jan 2017 by #realJSOP
I provided a class in my solution to this answer: How do I run access from a WS 2012 and IIS 8 with ASP.NET[^]
10 Jun 2018 by #realJSOP
All exposed classes and methods have have the comvisible attribute. If textsharp classes/methods don’t have that attribute, you’ll probably have to write a wrapper assembly that does it. I’m just guessing, I don’t know anything about itextsharp, and abhor MS Access and VBA.
14 Mar 2019 by #realJSOP
System tray notifications are typically modeless so that they don't interfere with apps running on the desktop. To set a cell's background color, do something like this: DataGridViewCellStyle style = new DataGridViewCellStyle(); style.BackColor = Color.FromArgb(255,0,0); style.ForeColor =...
5 Mar 2014 by $*Developer - Vaibhav*$
Hihttp://www.softwareforce...
5 Nov 2020 by   Forogar  
We are getting an unexpected (massive) slow-down in an Access 2016 VBA application over Citrix. No code changes, possible anti-virus update, possible Windows update, possible Citrix and Security updates. Perhaps the number of records has...
8 Oct 2012 by (unkownOfMe)
Hello, i try to connect access using MFC,here is the sample codeCString str;str=_T("Provider=Microsoft.Jet.OLEDB.4.0;""Data Source=C:\\Users\\User\\Documents\\DataBase.mdb;");there is an error,error C2308: concatenating mismatched strings1> Concatenating wide...
27 Jun 2017 by .net developer123456789
I am working on a existing MS Access 2007 project that has a linked table link to Sql Server database. When I mouse over to the linked table I can see a connection string 'ODBC;DRIVER=SQL Server;SERVER=10.0.0.1;UID=test;APP=Microsoft Office 2003;WSID=abc;TABLE=dbo.test' This looks like a...
7 Dec 2014 by /\jmot
use..a select Query Like: select * from table_Name where cDate(Date_column)=cDate(datetime.now)See the link..Insert, Update, Delete in ASP.NET Gridview, DataSource as SQL Server, MS Access (mdb/accdb), XML and Framework as 2.0 / 3.0 / 3.5 / 4.0 (VS...
25 Dec 2012 by 09hadi
Hi,I want to export a gridview into an access database. I have the same header created in the database. Just wanted to know how to export gridview into that database. Any code sample would be highly appreciated. The header for the gridview and database is as...
23 Feb 2013 by 09hadi
Hi every one, I need help with devising logic for archiving data. Currently I am storing data in an access database. The customer requires the data to be archived after a month. The data is being feteched by a c# application and then stored into accessAny suggestions would be great
7 Mar 2013 by 09hadi
Select * into month from History
28 Aug 2012 by 123sj
Hi, I have developed and distributed software in VB.net and MS-Access database,Now I have made changes in database so I want to create an utility which will replace the existing database file with new created, so that I can distribute that Update utility to client. What is easiest way to do...
24 Sep 2021 by 1step-forward-2steps-back
All I want to do is add pictures to my database as OLE objects from my Asp.net page via C# and yet be able to open it (the picture) when working in Access itself… I found code on how to enter it into the database and according to Access the...
17 Oct 2010 by 2gizzo
Have you already written the necessary SQL scripts to do this?
12 Jan 2012 by 3lb3njy
Hello i need a bit of help.I just managed to run a .exe front Access 2000 with the command Shell ("root/name.exe"), but now i need that the new window(my outside app) shows up in the front window, because when i run the Shell command it comes minimized.Ty in advances
12 Jan 2012 by 3lb3njy
thanks.i used a variant Dim name as Variantname= Shell("root/name.exe",vbMaximizedFocus) or the vbNormalFocus was good also, but thanks :)
8 Feb 2010 by 4277480
connection != adapter, your question doesn't reflect your answer
21 Jul 2011 by 4wtech
The date in the search string should compatible with the sql date column.( else typecast error ) Convert the date into sql suitable format(MM/DD/YY). User Convert.ToDateTime function.(OR) Else split the value from the date time picker using , int mon =...
1 Apr 2013 by 8400593361
I developed a window application using asp.net in this application i am using ms access database to store the recordsthis application works fine when i run it from VS 2010 but when i am running it into any other system it shows an OLEDB EXECPTION operation must use an updateable...
21 Oct 2010 by @nuraGGupta@
O que é este Código de validação CPF? Por favor, seja ao mesmo tempo mais elaborativo sua pergunta .........
5 Aug 2012 by _Amy
The error is thrown by the underlying Jet Oledb provider, which doesn't know or care which language you are using. So long as you can identitfy the correct user account to apply the permissions to, you whould be able to resolve the issue.Refer this[^].--Amit
12 Aug 2012 by _Amy
Check your update query carefully:sql = "UPDATE tblsample SET sname = @sname,contact = @contact WHERE contact = @ID"Quote:contact = @contact WHERE contact = @IDYou are updating the same ID field which you are providing as condition. Check your table, otherwise use this:sql = "UPDATE...
13 Sep 2012 by _Amy
Let me google that[^] for you.--Amit
23 Apr 2013 by _Amy
Don't be afraid to use google[^]. See the top 3 links:Pass values from Popup window to parent window using javascript[^]javascript - pass selected value from popup window to parent window input box[^]Passing Value From Popup Window To Parent Window[^]--Amit
26 Aug 2013 by _Amy
No, it's not possible. A value you inserted in database will/should be available in the database table. If I am not wrong, your record(which you are trying to insert) is not getting inserted in database.PatilVL Wrote:By entering a character of the value in search textbox, it will be visible...
1 Mar 2014 by _Asif_
Try thisSetting Up an ODBC Data Source For MS Access[^]
11 May 2014 by _Asif_
Check this link. Hope it helps your issueError message when you run a query in Access: "The field is too small to accept the amount of data you attempted to add"[^]
19 May 2014 by _Asif_
Your approach should look like followingStep 1: merge all sql queries as one. For examplesql query = "select Value from Parameters;select Value from Tooltip;";Step 2: Execute the query and read multiple resultset using (OledbCommand command = new OledbCommand ...
24 Jun 2014 by _Asif_
1. List all stuids which are enrolled in ART 103A and which are enrolled in MTH 103CSelect C.STUIDFROM CLASS CINNER JOIN ENROLL E ON C.CLASSID = E.CLASSIDWHERE C.CLASSID in ('ART103A', 'MTH103C')2. List all stuids which are enrolled in ART 103A and which are not enrolled in MTH...
9 Sep 2014 by _Asif_
Try providing date in YYYY-MM-DD HH:NN:SS format. That is instead of '10-09-2014 AM 06:23:24' use #2014-09-10 06:23:24#
18 Jan 2015 by _Asif_
You require scheduling mechanism which schedule the activity and at define time trigger the event.Below link might help!A Simple Scheduler in C#[^]
11 May 2015 by _Asif_
The format of INSERT INTO command with select is as followsINSERT INTO TARGET_TABLE_NAME(Field1, Field2)SELECT Field1, Field2FROM SOURCE_TABLE_NAMEYou need to change your SQL as explained above and try again
2 Jun 2015 by _Asif_
Though i have not tried this, but it should work. If it didn't then you can do a google search to tweak it.update table1 as a set a.totalInstallmentAmount = ( select SUM(b.credit) as credit from table2 b where b.ID= a.ID)
10 Aug 2011 by _Damian S_
There are two general ways to achieve this. One is to bind the data to your form, the other is to use a SQL statement (whether that's by query or hand coded) called from an event behind the form, say the on click event of a Process button or something similar...
16 Nov 2011 by _Damian S_
You don't have anything linking com and con... You open your connection (con), but you don't set the connection property of com.BTW, com and con are very similar - perhaps consider more meaningful (and less similar) variable names...
29 Nov 2011 by _Damian S_
If you are going to want your code to control the data conversion, your best bet is to open a dataset for the SQL Server data and process it one row at a time, inserting it into Access. A word of advice though - when you say there is a "lot" of data, by definition anything you do isn't going to...
5 May 2013 by _Damian S_
You don't have the OLEDB provider installed on your IIS server. You could install the Microsoft Access Jet redistributable package to achieve this.
5 May 2013 by _Damian S_
Looks pretty close... This is how I do it (VS2010).Dim crDoc As CrystalDecisions.CrystalReports.Engine.ReportClassDim pvParamValue As New CrystalDecisions.Shared.ParameterValuesDim pdvParamDiscreteValue As New CrystalDecisions.Shared.ParameterDiscreteValuecrDoc = new...
7 May 2013 by _Damian S_
When you are saving your dates to an Access Database, to ensure they are saved in the correct way (it changes depending on regional settings), you should format them #yyyy/mm/dd#This will resolve your issue.
9 May 2013 by _Damian S_
In Access, dates are denoted with a hash #.Try:select AMT from SomeTable where DateValue(TestDate) between #"+ format(fromdate, "yyyy/mm/dd") + "# and #"+ format(todate, "yyyy/mm/dd") +"#"Also, it's a good idea to format your dates yyyy/mm/dd to avoid regional issues.
2 Oct 2013 by _Damian S_
You need to have your Access DB present on the other machine. cat.Create() in your code above isn't creating an Access DB, it's creating a connection to a DB that already exists.
8 Mar 2015 by _Maxxx_
Quote:I have the SQL statement retrieved the rooms what have been reserved but my problem is retrieving those that have not been reserved. SELECT RoomNo FROM RESERVATION WHERE RoomNo ORDER BY HotelNoSELECT ROOM.HotelNo, ROOM.RoomNo from Room where ROOM.RoomNo Not In (Select...
18 Sep 2012 by _Zorro_
Hi,You can reference your external components by adding them to your .config file (I don't know if you're running asp.net or winforms) or simply by right clicking your project and selecting "Add Reference...".How do I add an assembly reference in the web.config file?[^]Hope it helps
16 Feb 2014 by aa00101
Hi AllI will appreciated if anyone can show me the issue in my code,because after inserting the query to my Griedview in vs 2012 using Access database it doesn't display anythingHere is my code
15 Nov 2011 by aakira_69
i'm trying to insert a hyperlink of a file into an access database from C# Windows Form application... Please can anyone help...
16 Nov 2011 by aakira_69
Can anyone help me i'm trying to create a hyperlink of an image being displaying in the picture box, that just came from a scanner and is being stored in the C drive... i want to create the hyperlink and insert that hyperlink into an Access Database table's Hyperlink Column... can anyone...
16 Nov 2011 by aakira_69
Can anyone help me i'm trying to create a hyperlink of an image being displaying in the picture box, that just came from a scanner and is being stored in the C drive... i want to create the hyperlink and insert that hyperlink into an Access Database table's Hyperlink Column... can anyone...
22 Nov 2015 by aarif moh shaikh
Try this..string CompleteDPath = "ftp://192.168.1.1:3113/YourFolderName/" + filephoto; string UName = "FTP UserName"; string PWD = "FTP Password"; //Filepath = CompleteDPath + MATBR + "/M_" + DIST + "_" + schlcode + "_lot_" +...
2 Nov 2012 by Aarti Meswania
this is actual problemPublic Function GetData(ByVal sSQL As String) Dim cnCustomers As OleDbConnection Dim sqlCmd As OleDbCommand = New OleDbCommand(sSQL) Dim myData As OleDbDataReader cnCustomers = New OleDbConnection(cnString) Try ...
6 Sep 2013 by Aarti Meswania
select * fromAttandence Where date(Att_Date)>=cdate('2013-09-23')Happy Coding!:)
16 Jan 2014 by Aarti Meswania
string constr = "Data Source =" + strPath + "\YourDBName.mdb;Provider = Microsoft.Jet.OLEDB.4.0;"Happy Coding!:)
6 Apr 2014 by Aarti Meswania
SELECT *FROM( select (SELECT count(*) FROM partymst WHERE pt.ID >= ID) AS sl_no ,pt.* from partymst as pt) as temptbl order by sl_noHappy Coding!:)
16 Sep 2010 by aayu
When changing the connection string of a linked table, you must then refresh the link. For example:Code:td.Connect = "MS Access;Database=C:\MyBackEnd.mdb;"td.RefreshLinkThe RefreshLink command commits the change to the connection string.Reply With Quote:rose::thumbsup:
21 Sep 2010 by aayu
Hi Friends i am trying to create Sub forms in access 2007 but it not happening. the step which i follows are :1. Form Design 2. i Active user control Wizards3. Then i select sub form option 4. But when i put button on that then i do right click potion bring front but its...
25 Aug 2013 by abbaspirmoradi
if you want convert your Access database to SQL Server database look at this articleshttp://support.microsoft.com/kb/237980[^]http://technet.microsoft.com/en-us/library/hh313039.aspx[^]http://sqlmag.com/database-administration/15-steps-convert-access-data-sql-server[^]
10 Feb 2018 by abboudi_ammar
I am a beginner at MVVM design patter and WPF I am trying to make a small example of connection to the MS Access database using the WPF and MVVM Light Toolkit patter design. but when i run the program it does not do anything and when i debug i find that the instruction stops at the instruction...
25 Aug 2021 by Abdelrahman-Dev
Hello, I have a C# winform application for selling books, And in my selling form I have some textboxes where the user can enter the name of the book, the amount, the price, etc... I have a button for inserting these values into an Access...
2 Oct 2013 by abdul subhan mohammed
Hi Guys,Today i'm trying to connect ms-access database,but unfortunately i'm unable to connect to the database,my connection string using web.config, like
20 Jun 2012 by abdul_wahid
Here is the solution....it great go through it carefully. http://www.vbdotnetheaven.com/uploadfile/mahesh/auto-complete-textbox-in-vb-net/[^]
11 Mar 2015 by Abdulnazark
solution 2 only to change group bySELECT GUEST.FirstName, Count(RESERVATION.GuestNo) AS CountOfGuestNoFROM GUEST INNER JOIN RESERVATION ON GUEST.GuestNo = RESERVATION.GuestNoGROUP BY GUEST.FirstNameORDER BY GUEST.FirstName
12 Mar 2015 by Abdulnazark
see the answer inhttp://stackoverflow.com/questions/1991643/microsoft-jet-oledb-4-0-provider-is-not-registered-on-the-local-machine
12 Mar 2015 by Abdulnazark
as you need the record not in table a use the below querySELECT a.* FROM Table1 aleft JOIN Table2 bON a.ID = b.ID where b.id is null
3 Mar 2014 by abdulrehman7621
plz help me in thismy data can't insertedit displaying error "syntax error in INSERT into Statement"try { OleDbConnection con; OleDbCommand com;string path = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\user\Documents\Visual...
16 Nov 2011 by Abhi KA
this link cam help youhttp://www.ehow.com/how_12388_define-default-value.html[^]
3 Dec 2013 by Abhijeet pratap singh
i have created a business application using sql servernow i want to make a application using ms access which can run on every computeron instalationthen what would we the connection stringhow to do this
26 Nov 2009 by Abhijit Jana
The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. When you are getting this error ? Are you doing some re
29 Dec 2016 by Abhilask kumar
Hi,I want to use ms access database to my asp.net but some error happened when use password protected ms access database. Work file when i use non-password protected ms access database. Error is "Cannot open database. it may not be database that your application recognized, or the file may...
30 Dec 2012 by Abhimanyu Rawat
HelloI want to import data from access database to sql server 2008 using c#.With some validation means,In Access we have varchar(10) and sql we have varchar(11) then not allow to import data. like vise if name is not match of the column than also not allow to import.Thanks
2 Jan 2010 by Abhinav S
RND will continue to return the same random number until the seed is changed. Try to use a function like GETDATE in your call to change this seed.SELECT RAND( (DATEPART(mm, GETDATE()) * 100000 ) + (DATEPART(ss, GETDATE()) * 1000 ) + DATEPART(ms, GETDATE()) );
3 Jan 2010 by Abhinav S
Voting for the answer always helps ;P .
19 Jun 2010 by Abhinav S
Maybe this post can help you get started.
9 Jul 2010 by Abhinav S
Make sure you are connecting to the database correctly and that your connection remains open.
15 Nov 2010 by Abhinav S
Check if your connection string is correct.
19 Nov 2010 by Abhinav S
While returning values from the database, you can actually union an all to your source.For e.g.select 'All', null UNIONselect emp_name,emp_age from emp_table
29 Nov 2010 by Abhinav S
There are many different tutorials provided here[^]. Some of them may be helpful to you.
2 Feb 2011 by Abhinav S
Have a look at the INotifypropertychanged interface[^].This can be used to bind data to the data source.
7 Feb 2011 by Abhinav S
In addition to the links mentioned already, seehttp://msdn.microsoft.com/en-us/library/aa213778(v=sql.80).aspx[^]http://msdn.microsoft.com/en-us/library/bb188204(v=sql.90).aspx[^]
9 Feb 2011 by Abhinav S
Make sure you have a record that exists for your no parameter.Put a debug point in your code on the TextBox1.Text line and see what values come in there.
12 Feb 2011 by Abhinav S
This[^] simple link should help you get started.
13 Feb 2011 by Abhinav S
This [^] discussion may be of some assistance to you.
19 Feb 2011 by Abhinav S
This[^] article might help you get started.
26 Feb 2011 by Abhinav S
You need to register vsflex (or make sure the dll exists) on the other machine.Try and create a setup that includes and installs this file automatically.
13 Mar 2011 by Abhinav S
Why dont you use an autoincrement column in the database itself?
30 Mar 2011 by Abhinav S
Submitting on the Asp.net form fires a post action[^]. Is this what you are looking for?
16 Apr 2011 by Abhinav S
This[^] or this[^] link could help you out.
30 Apr 2011 by Abhinav S
Try http://www.connectionstrings.com/[^]