[microsoft:access] Forum Topics

Hey, I've been working with a company which basically works with vb6 and now we're trying to re-write the applications they developed using vb.net any recommendation for where i should start searching , what we're thinking of is to create application programmatically and then loading forms from access then looping …

Hi everyone I am writing a program using c# and connecting to microsoft access. I get this Data type mismatch in criteria exception and cant find the problem. Can anyone help me please? My Code: > try > { > myCommand = new OleDbCommand(); > myCommand.CommandType = CommandType.Text; > myCommand.CommandText …

Hi Guys, **<-- Newbie Here!** I seem to have an issue with an INSERT INTO statement when trying to add some textbox data into a DataSet and then update the backend table called 'cashOrders' in a Access Databse. The Following code is being run from the 'Save Button' private void …

how to print selected item from your database ms access using visula basic 6.0...

Hey There, I'm a beginner when it comes to VB.net. I can do all the basic stuff, but I'm having issues with connecting to a database I've created. Ultimately, I need to feed data from a few text boxes to one table within the database, but I can't even get …

Hi Guys... I seem to be having an issue when trying to create a new row in a Dataset. Below is the following Connection Details to the Access DB. private void radioButton3_CheckedChanged(object sender, EventArgs e) { cashCustom.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Orders.mdb"; cashCustomerDS = new DataSet(); cashcTable = new DataTable(); cashCustomerDS.Tables.Add(cashcTable); cashCustom.Open(); …

have a Problem in C# windows program that is I can't work with 2 database those are simple database in tables and Data. in this Project I want to open Access DataBase and Create New Access DataBase with another Name But with Same Tables And Columns And Rows and fill …

A Example for OLE DB I Compiled. Put back together for fun maybe. # Someone convert this to ASP.Net plz with a splash screen. # # Required Materials # 1. a vb.net compiler(visual studio vb.net express perhaps?) 2. Libzplay dll(your search engine will help) Imports System.Data Imports ESO.libZPlay Imports System.Data.OleDb …

I need some help with the following. I have a form called frmMain that has a couple of icons, one of the icons when clicked loads frmNotes within a Panel, frmNotes has a ListView and i want to load data from a Microsoft Access Database Table into the ListView I've …

[FONT=Comic Sans MS]Hi everyone, I'm shreya. I'm doing my bca (bachelor in computer applications)-4th sem. I'm required to do a mini project on dbms using msaccess and backend as vb. I'd be glad if you can suggest a project. I have 3 months to complete this project. I hope I'll …

I need some help with the following. I have a form called frmMain that has a couple of icons, one of the icons when clicked loads frmNotes within a Panel, frmNotes has a ListView and i want to load data from a Microsoft Access Database Table into the ListView I've …

im working on vb.net 2010 and ms access database, i was able to create new crystal repot and new connection for my report but when i place password on my database i received errors. both on creating and opening my previous reports can somebody teach me how to deal with …

I need help, please how can I export my database from access to mysql. I do not want to start creating the tables one after the other ĩ̷̊ñ mysql. Thanks

so i have a form with 4 textbox; idnum, lname, fname, dept 1 button i need help about when I type in the idnum.Text there will be results based on the database table (ms access)and auto fill lname.Text... and if it doesn't exist there'll be a prompt.

hi everybody, i want to read data from Ms Excel 2007 . So i used this connection string string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;"+"Data Source="+txtFilepath.Text+";"+"Extended Properties=Excel 12.0;"; but it display error :Could not find installable ISAM. i also installed AccessdabaseEngine.exe but still display the same error. please help me

I am trying to insert data into a batabase table (Microsoft Access 2010) But i keep getting a problem it sais"Could not find installable ISAM." the table names are all right. any help would be appreciated  

hi im back with the new problem and the same problem..huhuh first is the same problem which is why does the data is not being inserted to the db..below is my full code for the custhome page 'Imports WindowsApplication1.LoginForm1 Imports System.Data.OleDb Imports System.Text.RegularExpressions Public Class Custhome Private _OrderID As Int32 …

hi friends i am new in vb coding. i have two tables in ms access table 1 containing location column and id and table 2 containing id, name and date1, date 2...date 30 i have made form design in visual basic with "name" label with combo1 that selecting data from …

I have written a program which allows agents of a call centre the ability to access a database (ms access) containing names of solicitors to allocate to. the database is stored centrally and i need a way to update the local dataset on the agents machine when a change is …

Good day! I just want to ask on what is the best ADO connection string to connect to MS Access fast? and what is the fastest way to create it? And also, where in the project to best put it so that all forms in the project will use it …

This may not be the best location for this thread, but it's 5 am, I've been working on this for almost a day and a half straight, and I'm pure stumped. For a custom MS Access .mdb program, the database properties are locked out. In order to fix the database …

please someone help me..im doing my final project and below is my code for the registration form..after i fill up all my form and it will appear a msg box that i can only register once...the data is not being inserted in the database..im using ms access...please2....do help me...i dont …

how to use checkbox in accessform that will ouput a text on accesstable?

Hey All! I have created a database application which read and write data in Ms Access. It works well on my computer but when i try to install the same application via installer package to another computer, and run it, it gives me error that i dont have the database. …

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Database { public partial class Form2 : Form { public Form2() { InitializeComponent(); } int baseExp = 200,currentExp,lvl=1,str,intel,dex,armr,min=10,max=25,minimum=2,maximum=3; public void levelUp() { min += minimum; max += maximum; str = int.Parse(strength.Text); …

Hello guys, I made a simple program that Add, Saves, Edit & Retrieves Data from a MS Access DB... Dim arrImage() As Byte Dim strImage As String If Not IsNothing(Me.ImageBox.Image) Then Me.ImageBox.Image.Save(myMs, Me.ImageBox.Image.RawFormat) arrImage = myMs.GetBuffer strImage = "?" Else arrImage = Nothing strImage = "NULL" End If myqry = …

this is my code for the login form using ms access would someone please help me? Everytime I run the program, it usually says connection cannot be used. If I would debug the program it will highlight "rspassword.Open "Select * from table1" I also used a module here Public rs …

I want the btnLogin_Click event to verify the username/password from the ms access database, if it matches it will take them to a certain page, if not it will give a message that user/password is incorrect try again. I really don't know where to start, can you please help first …

This is my code that i put inside Form 1....(for ur info, im using microsoft visual c++ 2010). #pragma endregion private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { char szDSN[256] = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=C:\Documents and Settings\user\Desktop\dbtesting.mdb"; } i try to compile my code and here I get hundreds of …

I have a thesis proposal which is an enrollment system for high school..my back end would be ms access and i'll use VB6.0 as my front, but the problem is im not very much knowledgable about data reports.the reports to be generated are:**report card(form138),permanent record(form137),form 18 or the promotion form** …

I have a website for a painter where the painter uploads a picture. The picture name is added to a mdb (access) database table, the picture is added to the end of a table called galleries, and the file is uploaded. It is also then resized to a small image. …

i have created a billing softwate using vb.net and ms-access database. Now i want to make crystal report in which i can display last bill number and it's item how to do this. Because i used lot of things but i get confused only. so if you have any basic …

i want import Excel work sheet into ms acess existing table try { string conn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filename + ";" + "Extended Properties=Excel 12.0 Xml;"; OleDbConnection con = new OleDbConnection(conn); OleDbCommand cmd = new OleDbCommand(); con.Open(); cmd.CommandText = @"SELECT * INTO [MS Access;Database=" + adb + …

Hello, I m new in asp. I need to run asp website with access database. Pls help me to do this.. i got problm with connection string i think. Broswer reply : ------------------------------------ Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a …

Access 2010 Compact & Repair drops indexes in descending order. The database is ~700MB and the table affected has 190 columns, 228,000 records and 13 indexes and runs on Windows 7 with 4GB of memory. The same file compacts without incident using Office 2007 on a Window XP machine with …

I have created a database in ms access and a form, in which i want to add some records, it is updating correctly, but when i close the form and restart the application and started to add new records the previous records are deleted automatically. please help me in this

I'm creating a program where the user can search items in an access database and results are displayed in a listview. When I click search all items are displayed but when I enter an item in the textbox then search nothing is displayed. This is my code Private Sub cmdProdSearch_Click() …

hey..m a student of last year of BCA...i m making my project on crime management system...i had made my database in ACCESS 2003 n using the C# language...in database i hd taken the auto number as datatype in my serial number column. bt when m accessing my code in C# …

I want to insert a "words file" into "ms access" which has a column with data type "attachement". Can anyone suggest me what the sql statement look like?

I am trying to create a "simple" c# windows application for adding data from textboxes to a MS Access database on the local machine. I am new to C# and have not found a good tutorial on how to do this. I have viewed multiple sites and this is my …

Hello, I would like some advices with my program, i having issues I have a program in visual basic that is linked to access database using the connection wizard. in access i set the number field to autonumber but in visual basic i putting as a text because it would …

Acronis responds to DaniWeb questions regarding a leak of customer data which, [as we exclusively reported over the weekend](http://www.daniweb.com/hardware-and-software/microsoft-windows/viruses-spyware-and-other-nasties/news/427455/breaking-acronis-blames-technical-issue-for-customer-data-leak), resulted in some information being indexed by search engines and accessible to anyone on the Internet.  Although the leak itself was identified by Acronis on Friday 29th June, the …

**I am facing some problem in updating ms access with parameters. I succeeded to insert the data in access with parameters. My code for inserting the data is:** Dim dbPath As String = "C:\Users\Abhishek\Documents\ToolDatabase.mdb" Dim connStr As String ="Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" & dbPath & ";Jet OLEDB:Database Password=agupt80;" Using …

Hello all, I need to know what tool or language i can use if i want to link(integrate) between the data entered(filled) in online forms by end users (visitors) with my database (access) . Thanks in advance.

Hello all, I need to know what tool or language i can use if i want to link(integrate) between the data entered(filled) in online forms by end users (visitors) with my database (access) . Thanks in advance.

HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable …

First I am new to C#. I attempting to build a simple windows form where you can send textbox info to an access database on the machine. When viewing online tutorials and book, I notice their is a step, form missing from my Visual Studio 2010 program when I try …

I am doing a project in Visual C# and trying to insert data into MS Access database but whenever I press the insert button in the C# Windows From a message box appears and its written "Microsoft Access Database Engine". I have installed Microsoft Access Database engine but still the …

Hi all, Can someone please help me. I'm writing a VB5 app that connects to an Access 97 database using a data access control with the following parameters: Connect = "Access" DefaultType = 2 'UseODBC Exclusive = 0 'False Options = 0 ReadOnly = 0 'False RecordsetType = 1 'Dynaset …

Hello people, First of all, i'm not an experienced ASP coder at all, i usually do php/java so i'm still kinda puzzled by this language. For my current project, i need to update a piece of an intranet, written completely in ASP. since it can't be reached from my position, …