[microsoft:access] Forum Topics

Ok so I have made ASP.NET website I have used Access database 2010 but I am having problems with one particular thing when I try and run the website I am getting this error which says OleDbException was unhandled by user code and Could not find file 'C:\Program Files\Common Files\Microsoft …

hello! i'm trying to implement an audit trail in my system and what i wanted is that when the user click the login button, infos like username, level of access, time in and date will be save in the database and fortunately i have done it and here is my …

For a lack of words, I'm confused with my server at the moment. I moved an old site on ASP/Access over to ASP/SQL Server 2008 Express, and now some data appears, while other data does not. This one is an odd ball to me. I have data cells of the …

Hey there i have a problem with a program that works on other pc's but not on my laptop. (it connects to access) When i try to run it it gives me the error "AAAjava.sql.SQLException:[Microsoft][ODBC Driver Manager] data source name not found and no default driver specified" I already reinstalled …

HI, i want to store the text present in the text area in ms access database when user clicks submit button.....i am using macromedia dreamweaver..........pls kindly help me for doing this............

Hey all, I'm working on a login screen and have an MSAccess database that stores the userName and password. I am currently using JtextField and String to access the username and password located in the MSAccess database, but now I want to hide the password when it is being typed …

All, Is it at all possible to have a 'multiple items' form based on a query, plus have a combo box added to it, with the control source of a field already on the form. Issues: 1. When the combo box is given the control source of a field already …

hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and …

can anybody help me.i got an error while searching a rec from table error @ 2nd line after connecting with access [code] Dim src As Integer src = Val(InputBox("enter rno:", "rno")) Data1.Recordset.FindFirst "rno=" & src [/code]

Hello please can anyone help me with microsoft access. I work as a software support consultant for a medical software company and we have an sql server database with all the bugs etc but the website is awful. I have made myself a small access database with bugs that i …

Hi everybody >> Thanks to this forum >> I need your help please .. My problem in the Combo Box and SQL query .. I have three comboboxes linked to an Access 2007 database first one "Department" second one "Year" third one "ClassRoom" in third combobox I need display the …

I have a screen with a Datagridview. This is linked to a table from my access database. On this screen there are also numerous text boxes that are bound to columns in the table. The problem i am having is that when browsing the grid values seem to vanish and …

Hi there I was wondering if their is anyone who can convert this statement from 'INSERT' to 'UPDATE' as I cannot seem to do is. Code can be seen below: [CODE]public static void COUNT2( ) { try { ResultSet res = stmt.executeQuery("INSERT INTO TABLE2 (VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT) SELECT VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT FROM TABLE1" ); …

Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely …

hello :) i'm developing an app in VS 2010 C#, linked with an MS Access Database. i want to use a table name as variable. i have tried: [CODE] string tblname = students; string query = "select * from '" + tblname + "' where rollno=123"; [/CODE] but it's not …

Any1 here i just need help regarding my System. In Log In Form. I need to be able to terminate/locked the account in vb.net if the user input wrong username/password in my Log In form like 3 attempts is good. and be able to enabled the account also as an …

My problem is for postItem.aspx and giveComment.aspx, users cannot access without login. Can i use the nested-if method? Then how to use it? Thank you... In Login.aspx.cs if (temp == 1) { string cmdStr2 = "Select Password from Reg where Username= '" + txtUN.Text + "'"; SqlCommand pass = new …

can u help me plz people with this problem? i have 2 checl boxes bol1 and bol2 and i stored a record after ticking one of them and now i want to make a function to retrive what i stored in the access data base in check boxs as well …

how to create a short summary form in Access Database? I have created a database in which I have created 4 tables 1. Pregnant Women Data 2. Feedback of Pregnant Women Data 3. Traditional Birth Attendants Data 4. Villages Data I have registered 3397 pregnant women, and issued some women …

I am creating a shared database to record requests entered by a team of 30. I need to record the Order Number, Reviewer Name, Date, Action Type(Order Type), Client Name, and a comments box for each order entered. When creating forms, Currently Reviewer Name and Date are auto-input so the …

Hi, I have a strange problem on a computer. I use a program that connects to a database that is located on the server. When I run the program, it can not always find the database and it returns an error. When I open windows explorer and go to the …

How to save all the items in listbox in MSaccess table. Pls help me this is for my thesis thanks.

Hi everyone, Its weird. Only UPDATE sql statement cannot process and others like INSERT, select can work.. i used UPDATE sql statement in c# but the record that i wanted to update isnt update at all.. here my code.. i am using ms access [CODE] OleDbConnection connDBString = objDB.GetDatabaseConnection; connDBString.Open(); …

Note: I'm very new to everything so please bare with me. Say I have a form on a website which asks for your first name, last name, and email address. Upon clicking submit, I want the data to be transferred and saved to a Microsoft Access Database. How do you …

i have a dynamic table whose values came from the database. the user will select records from the table then save the result to another table. i have the following code: <?php echo "<form method='post' action='save_result.php'>"; $subjects="table1"; $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data.mdb").";"; $conn=odbc_connect($connstr,'','') or die("connect error: …

Hello all , I'm designing a Database which is for students & Their degrees I have Two Tables One for students one for their Degrees & 2 forms Main One & Sub form . What ever I want to make a way to search for a student name like the …

Can anybody help me in filling an Access database table in one field from a serial port using VB 6.0.Data coming from the serial port can be seen in the VB text box line by line.I want to store every line under a field and can manipulate.How can i use …

hi! i'm having a project in school regarding vb.net and i badly need your help! it is about connecting vb.net to access. i need to be able to add, delete, edit, and save data to a table in access using a form in vb. i am also required to view …

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\xampp\htdocs\xampp\display.php on line 5 Connection Failed: php is working fine, ran other simple php scripts... but this is the error when i connect to a ms …

Hi all I need help with connecting to and manipulating a microsoft access 2007 database using code in visual basic 2008 express edition. It's for a project I'm doing for University that's due on the 12th of October:S. Please help me out in whatever way you can - links to …

Hello, I am trying to populate a spreadsheet using Access data, however I am having trouble with the line noted below, which is giving a run-time error. I am not familiar with the Excel Object Model, so not sure how the "selection, range, etc" should be used. Any help and …

Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in …

I have a proble. How can i call andd compute all the record in may database(MS Access) Please gave me some idea or Code Thx

I know this might be a very simple one, but yet I can't figure that one out! How do I get data from one table that are not in another? Let's say Table ServerA has: IP, User, Password, Table ServerB has: IP, CanConnect. If ServerA has 20 rows and ServerB …

is it possible to access an access database without ms office or just using references or .dll

Hi, I recieve the following error message: "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression'name '" when I run this statement: [CODE] sql = "INSERT INTO empDetail VALUES("; sql += txtName.getText()+ ", "; sql += "'" + txtAddress.getText()+ "', "; sql += "'" + txtSuburb.getText()+ "', …

When I add a NEW row to the datagridview, it for some reason freezes the datagridview. That is, it adds the rows pulled from the database to the grid. But you can't add rows to the datagrid by some a click button event. Nor can you select a row in …

please i need help on making data report which the database is access 2007 with accdb format. what connection will i use and how and sample codes. thanks a lot in advance.

Hey guys! I have created an Access 2010 database. On one of the tables, there are fields [Start Time], [End Time] and [Total Time]. The user will input the start and end times but and the total time will be the difference between the two. I cannot figure out how …

Hi guys!I'm currently making a database project and I want to update an access database. I connected the database using this sql command 'select*from word' And I tryied to update the database using this code ds.tables('word').rows(0).item(1)=”cat” Dim cb as new oledb.oledbcommandbuilder(da) da.update(ds,”word”) da is a data adapter ds is a …

I have a simple vb.net app and I'm trying to update a one row Access table with data from some textboxes. This is a learning exercise for me as I am coming back from not programming for almost 10 years, and know there are lots of other ways to manage …

hi I have MS Access Data Base with tow tables table 1 has relashiship with Table 2 when I try edite tabe 1 error message shown tell me I can't edit table 1 do you have examble for this ?

I want to update some record in access data base, but the update command is not updating the table... Insertiion is working fine.. the code is: com = new OleDbCommand("UPDATE ServerAuthorisation SET Permissions=@permission WHERE UserName=@user_name", conn); conn.Open(); if (conn.State == ConnectionState.Open) { com.Parameters.Add("@user_name", OleDbType.Char, 100); com.Parameters.Add("@permission", OleDbType.Char, 100); com.Parameters["@user_name"].Value = …

Hello guys, I'm currently trying to rework an older project. It uses the Dao interface to connect to a MS-Access database. It now needs to connect to a SQL CE Database using the ADO driver. However, I keep getting the IDispatch error, see below. CJapRecordsets is a class with membervariables …

Hi guy, would you help me, how to create table (ACCESS) with primary key in visual Basic 6? Set catNewDB = CreateObject("ADOX.Catalog") catNewDB.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & sDatabasetocreate & _ ";Jet OLEDB:Engine Type=5;" ' Engine Type=5 = Access 2000 Database ' Engine Type=4 = Access 97 Database Set …

Hello All, I have starting using Visual Studio Pro 2010 and I understand the very basics in programming. Currently I am trying to create a login system where users enter their usernames and passwords. I have been experimenting with trying to link Access database to MySQL but im having no …

Hi!I'm currently trying to make a language translation tool using vb.net 2008 and access 2007. For that I want to do these... 1.There is a textbox,a command button and two labels in my form and I have a database named 'dbwords.mdb' with one table 'word' and two fields named 'word' …

Hi! I'm having a bad time on learning how to store and retrieve image files on MS Access. This is some sort of uploading profile picture thing in my software. The open file dialog stuff and the storing of image file in the MS Access Database are taken care of …

Hi, I have a database with lots of fields, some of which are still empty and are to be filled in at a later stage. Is there any way of writing an IF statement (or any other method) that will allow these empty records to be 'shown' in my textboxes …

Hi Guys well what I want to do is instead of within my writeString to set my PLAYCOUNT to '16' what I want to do is every time the statement is executed my PLAYCOUNT is increased by 1. Any help you can give would be appreciated: My code is below: …