[microsoft:access] Forum Topics

I went to a customers site and copied a MDB file and a MDW file to my stick and brought them here. When I attempt to open the MDB in Access 2007, I receive You do not have the necessary permissions to use the 'c:\desktop\file.mdb' object. Have your system administrator …

Good day to all. I have a database in MS access and i need to access it using HTML. Can anyone help me to do this. Thanks.

hello guys. Just want a little guide here.. because there's no error in program but the data is not inserting to database. Thank you and god speed!. <?php $conn=odbc_connect ('visitor_list','','') or die ("Error cant connect to database"); $sql = "select * from TEMP_LIST"; $rs = odbc_exec($conn,$sql); if (!$rs) { exit("Error …

Hi, Installed login script. Now get...Access denied for user 'root'@'10.24.3.4' (using password: NO) Can/should I delete the script/reinstall or try another script? Thanks!

In MS Access I am trying to append data from one table to another table that is identical. However, once I run the append query, I get a message telling me that "..it didn't add 2253 rows due to key violations". How can I identify the 2253 records that are …

MS Outlook 2007. The user account domain was accidentally deleted, then created again. I received new SID. on a local computer the new local profile was created. on exchange the new box with the same name (to it access is) was created. in exchange there are 2 boxes now. How …

Good day! I have a running code but I found it not very fast in terms of saving data. Is there a way to make it more faster? I am using msaccess as databse. Set RsTrandet = New ADODB.Recordset Sql = "SELECT TranDetail.AccountNo,cashflowcode, TranDetail.Narration, TranDetail.TranNature, " & _ "TranDetail.TranAmount, Acctmaster.Accountname …

I know to save records from database into listview, but how to save listview to database instead.. this is the code for showing record into list view..but can any help me how to change the code to save listview into database? Imports System.Data.OleDb Public Class Form1 Dim con As New …

Why am I asked for user name and password when I try to access an article?

Hello all, I have created a pharmacy application in vb6, i packaged that, itselt has an access database. it works well in my pc, but when i want to send it to another computer, it installs there but dose'nt work there and says: C:// desktop/main/pharmacy.mdb is not a valid path, …

I have a problem in updating my textfields in the table I posted in my form. For example for my inventory system, I want the QUANTITY of my products to CHANGE its value everytime SALES are performed. Hope you guys can help. THANK YOU SO MUCH.

Hi Guys, I am using the following codes to connect to MS Access database using vb.net code. I am providing the file path name and directory. This codes work fine in my computer. How can I make this codes as dynamics connection that can run to another computer that no …

Hi Guys, I have a Microsoft Access database in which my VB.Net 2008 application is posting the data. It is an inventory management application. I have managed to accomplish a lot of things with your help. And Now, I have reached a point where all my ideas have been exhausted, …

Hi, No matter what I do I get the Access denied for user error.I watched the video but still get it. Are there any common errors I should be aware of in setting up a db user? Thanks, duchaine

hi, I want to insert muliple textbox values to muliple column in access db from vb.net

public partial class Form4 : Form { private OleDbConnection connect = new OleDbConnection(); public Form4() { InitializeComponent(); connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Bino Unity\Desktop\user1.accdb;Persist Security Info=False;"; } private void Form4_Load(object sender, EventArgs e) { } private void login_button_Click(object sender, EventArgs e) { connect.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connect; command.CommandText …

hello I am trying to show Data in CrystalReport from Ms Access 2013 In button_click event String Cnstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\parth\Documents\test.mdb;Jet OLEDB:DataBase Password=hello123" using (OleDbConnection Cn = new OleDbConnection(CnStr)) { using (OleDbCommand Cmd = new OleDbCommand("select * from Table1", Cn)) { using (OleDbDataAdapter Adp = new OleDbDataAdapter(Cmd)) { using (DataSet1 …

hi. Experts I'm developing a monitoring student in and out of residential college using RFID My problem is i can scan the RFID tag but i did not know how to save it into database access. here is the code i found on internet to connect detect rfid tag no …

hi all i have ms access procedure for importing dbf files into ms access but i face a problem with corrupted files is there any code to detrmine if DBF file is corrupted or not to make exception for it ?

My tables in MS Access doesn't have any change which it did not update the record that I entered in Visual Studio.. This is my code. Private Sub btnSubmit_Click(sender As Object, e As EventArgs) Handles btnSubmit.Click On Error GoTo saveErr RequestSoftwareBindingSource.EndEdit() RequestSoftwareTableAdapter.Update(FYPDataSet.RequestSoftware) MessageBox.Show("Your request has been submitted.", "Thank you", MessageBoxButtons.OK, …

Hi guys, I am trying to update a single column in an already existing record with a value in a textbox in Access database using VB.NET 2008 express edition. This is how it should happen, combo box is drawing product IDs from the table and two textboxes display product description …

I tried to make a setup file wherein i want to install and unistall the application/system that i made but when i try to run the application and i tried to save, edit, order and other stuff in the application it says "Operation must use an updateable query" i use …

HI I have vb.net with ms access database application. I want to create log in form Here is my code but when enter the details and hit Login button it says"datatype mismatch error" Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim rd As OleDbDataReader con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data …

Hello everyone! My Access MDB file has "disappeared" from his documents folder. I haven't deleted it, I have checked recycle bin, system restored, searched and so on. No luck! Any suggestions on what else I could do to recover the file?

To any who can help me familiarize my self with daniweb, I say hello. My name is Nathan and When I first logged into Daniweb.com four or so years ago I didn't know much about the website and that kinda made me fall of the site. But now I back …

Hi everyone, I have been strugling wit the "INSERT INTO" statement. I intend to insert the items that are in a datagridview into An Access Database when a button is clicked. I am using VB.NET 2008 express and Microsoft acces 2007. At first, I tried to use the listview, but …

Hi, I am having trouble with dropping a temp table. I was using it so many times in other projects but this time it went bad. The only thing different now is that I referred a string value from the main form to another form.The other form populates a dgv …

Hi i need a validation rule for MS Access so that only a time can be entered that is between 18:00 and 23:00 The validation rules must allow for the above numbers inclsuively Please Help

hi guys I need assistance with SQL insert statement to an access database. I want to insert values to a particular table if the text box value is less than 0. below is the sample code. dim value4 as integer if integer.try parse(textbox4.text) then if value4 <=0 then dim cmd …

hi everyone i have 5 labels 1 textbox 1 button 1 timer and database im actually making some sort of a timer .. i managed to put the value of the 5 labels (which is my timer) to the textbox. now id like to put and save the value of …

Hi All,I am coidng a movie database using vb.ebt (VS 2013) and using access (2013) I am trying to code my save button, but every time i run the program and try to save my data I get the below error An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll …

Hi guys, I am a new member to the group. I am trying to build an inventory management application using VB.net 2008 express edtion and MS access 2007. I have managed to load the Combo box (cmID) on form(frmSales) with product Ids from tblProducts. I have two textboxes on the …

Plz anyone help me .... I created the database in access with fields type is date/time and text... But I try to get the value from datetimepicker and combobox.. My struggling code was cmd=new oledbcommand(insert into sample (doj,designation)values(" & datetimepicker1.value &","&combobox1.text&")",con) note:- database connection is successfull!...

Imports System.Data Imports System.Data.OleDb Public Class Chemical_Details Dim MyConnection As OleDbConnection Dim MyDataAdapter As OleDbDataAdapter Dim MyCommandBuilder As OleDbCommandBuilder Dim MyDataTableChemical As DataTable Dim MyDataSet As DataSet Private Sub Chemical_Details_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load MyConnection = New OleDbConnection 'Creates OleDB connection MyConnection.ConnectionString = "Provider= Microsoft.ace.oledb.12.0;Data …

I have been trying fruitlessly to populate my datagridview using multiple tables from my ms access database. My code is shown below. Thanks in advance for your help. Imports System.Data.OleDb Public Class Stock_Check_Options Dim MyConnection As OleDbConnection Dim MyDataAdapter As OleDbDataAdapter Dim MyDataAdapter1 As OleDbDataAdapter Dim MyDataSet As DataSet Dim …

Hi guys, I want to create a window application from VB, so that a user can enter the **OLD Power** value in table. Then **line chart** will be created in that windows application. My **Old Power** data already obtained and recorded in Excel. So, in that window application, 1) The …

Hi, I am a new member in this site. I am also just learning VB6. I made some progress in programming a report generator for my farm. However, after having designed a report using Data Report designer, I keep getting the same result or reports repeatedly although I have changed …

I would like code to display ms access database dynamically in a jframe . here is my database.**[img]http://i.imgur.com/PtuGLnX.png?1[/img]**.I tried searching a lot but i think i need personal help in this area as this is a suppose to be dynamically updated Jframe.on the other hand i am open to suggestion …

I worked on a program a few years ago that takes data from a series of text files and loads an Access database. I added to the code from a program started by someone else, so I did not write the imports and declarations. They used an ADODB.recordset, addnew and …

i need to connect the data grid to access db using ado code and vb6 (without using adodc control)and diplay the result of a select statemet on it and here is the code that i am using (it give me a run time errorr 3705 : the operation is not …

i am in need of coding for retrieving data from access database using combo box, which means retrieing the stored particular details that for eg, retrieving particular students details using the students id that is retrievied by combo box.

i am a student college ,we have a project that covers the inventory and pos i need help for giving me some advise to create this project using vb.net and ms acces

Hey everyone here. I want to start this topic by saying Thanks to Shark 1 who helped me with my previous code. I need some help. Searching on google was not useful. I need to create new Microsoft Access file located at this folder "C:\ProgramData\MyNewSoftwareFile" Is it possible to put …

How do i retrieve an ID with an AUTONUMBER as DATATYPE and has alphanumeric format ex(ER001)? Can some genius programmer out there help? :P? im using Access for backend and VB 2010. My code so far only returning the last number of the ID Column ex(1 instead of ER001) Dim …

i want to add another function for level of access in this code. admin=3 artist=2 client=1. like that. but need some help to to that :( thankyou in advance (: <?php include('password.php'); class User extends Password{ private $_db; function __construct($db){ parent::__construct(); $this->_db = $db; } private function get_user_hash($username){ try { …

if i insert the new studadmin and the admincard and it Successfully Register but when i look at the access it not go the correct row is go to the timein and timeout i not sure which part wrong: Public Class Student_Form Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e …

Hi there, I am running a small business and want to build a database in Access. To keep record or my stock, invoice and payments (inward/outwards). Can you guys help me with it. I am not expert wih access but know a little of it.

if i insert the new studadmin and the admincard and it Successfully Register but when i look at the access it not go the correct row is go to the timein and timeout i not sure which part wrong: Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles …

i am using eclipse to write code that allows me to take a text file containing data (in my case it looks something like this :20 30 40 50 etc).i want to write the code in java and i am using eclipse as my IDE.i need the database to be …