[microsoft:access] Forum Topics

hi can anyone plz tell me how to create a ms-access database with table in run time i mean i want to create a database when user run the application thanks

can someone help me how to connect database from ms access to vb.net?????? please help me.. :(

Hi, I have posted a question regarding this but no one has ever had the will to help. Maybe it was too long so I'm cutting it down to this more simplified question; How do I create subtables in MS Access 2007, or is it possible in the first place? …

Hi I am having trouble with how to access my documents. So I did a bit of research and says that I should change the way I save and access my documents templates. Any tips of where I should save my document templates and how to access them? I thought …

Hi everyone.I m new to vb.net and i m presently working on a project "Telecom Billing System".I have two different forms for "Adding New Connections" and "View Connections", Firsty i m unable to add new connections.... Moreover on "view connection" form,i can navigate the records but i want that when …

hi everybody i need some code for auto inncrement in msaccess database file and in form textbox and if we add any data the number should increment automatically please help meee thanks in advance

Hi All, Im trying to Insert a new row into a database and refresh the dataset. This is what I have so far: [CODE]void ButtonInsert(object s, EventArgs e) { string connectionString = null; OleDbConnection connection; OleDbCommand cmd = new OleDbCommand(); string sql = null; connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;data source=Book.mdb"; connection = …

Hi all.. I have made a database in Mcrosoft Access 2007. In my Database there are four tables. ORDER, ORDER DETAILS, CUSTOMER & ITEM. I have made order and order details combine form from Form Wizards. When flling the form of any order when i give the Item_id in the …

Hi Guys need a bit of help. I right a c# program that connects to a database and do various things. One of them is to delete a record. currently I can delete a record that i specify but i want it to delete a selected row in the dataset. …

Hi Everyone, Ive been messing around the OLEDB in C#, What im trying to do is create a program that would read from a Access Database, and then the user has the right to add,edit and delete a records. So far i can get the Database to display and are …

I have written a program to track the membership of a local gym that works perfectly on every computer EXCEPT the computer at the gym. I am pulling out my hair trying to figure out what the difference is any why ONLY that machine throws an error. Background: The program …

dis is my first page regpage.jsp where i am filling all data when i click on submit it calls insertreg.jsp i can see in browser but it doesnt display anythin.Please help me. Thanks, Sarika [code]<%-- Document : index Created on : Nov 4, 2010, 9:32:00 AM Author : sarika.sharma --%> …

Hi I have this form which works well when it is in list box. but when I change the list box to combo box, the form does not works and I will be stuck at "record does not exist" even though i choose the record from the combo box. this …

Good day! Im a new programmer in vb.net and it seems that i cant update my table in access 2007 here is my code. [code] Try con = new oledb.oledbConnection("Provider = Microsof.ACE.OLEDB.12.0"; data source = |DAtaDirectory|\Attendance.accdb; Persist Security Info = False;") con.Open() sql = "INSERT INTO tblProf VALUES('"&txtEmpNo.Text&"', '"&txtProfName.text&"','"&txtProfLname.Text&"')" cmd …

can anyone tell me how to use if else statement using c# and MS Access database..this is my code.. [CODE] protected void Button2_Click(object sender, EventArgs e) { string path = Server.MapPath("App_Data\\dnis2010.mdb"); OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path); //con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\keOn_kAyFar\\Documents\\Visual Studio 2008\\WebSites\\DNIS\\App_Data\\dnis2010.mdb;Persist Security Info=False"; conn.Open(); string str …

hi to everyone! I have requested microsoft through their customer service email if it is possible to increase the size limit of the database. I noticed that ms access 97 limit is 1 gigabyte and ms access 2000 to 2007 is 2 gigabyte. I talked to our country's local microsoft …

Hello Frnds, I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a [I]MS Access Database[/I] from where I have to read some data and feed it into ASP.Net form and then save it to [I]MS SQL …

Hi Guys, I just want to ask you if you have any GOOD and EASY to understand Ms Access Tutorial. Since I am new in VB.Net, I would really want to know how to do that. I wish to have a tutorial how to ADD,EDIT,DELETE,VIEW I hope you can give …

I'm probably overthinking and been staring at this too long, but I'm having a huge brain fart and need help. I have 3 fields on a form: EMPLOYEE (visible), EMP NUMBER (not visible) (from a seperate table) and EMP NUMBER ENTRY (visible). I want the employee to choose his/her name …

I have quite a long list on my listbox. And when I wanted to search for words like "Boy", I need to go through all the letters before 'o', for example, 'bacon', 'banned', 'because' and so on. I know that the listbox allow the user to search for the first …

i working with msAccess right now.. i studying how to build a query. i wonder what is the use of the relationship thing.. im new to this. i want to learn more, what should i focus in the part of the database. can someone talk to me?

I'm trying to join two tables and group the results. The tables are joined on an EventID field. The basic query gets all upcoming events for the following month: [CODE]SELECT StartDate, EndDate, StartTime, PresentedBy, EventDescription, AdditionalInfo, VendorEventID, FeaturedText FROM EventCalendar, Events WHERE EventCalendar.EventID = Events.EventID AND StartDate >= NOW() AND …

The question I am going to ask involves Mircrosoft Access and VB and I am stuck with it. This is the question: I have 4 peoeple: L, M, N, O, P there are 4 object: a, b, c, d, e L has: a, c, d M has: a, d, e …

Hello Everybody, I'm new to this and kind of new to programming. I can't stay long because I'm at work. I was looking for some help on updating a table from another table while using a variable for the table name in access visual basic when I can across your …

I'm trying to create a tree with the following very small access database. I'm still getting a few errors, 'rdr' is a 'variable' but used like a 'method' and trying to get tree to actually populate.. If you find any other errors or recommendations, they're greatly appreciated. Thanks a lot. …

hai! every body. please correct this coding. vb.net with access table name : Sample.mdb My Error mistake is : [COLOR="Red"]"The Microsoft Jet database engine cannot find the input table or query 'sample'. Make sure it exists and that its name is spelled correctly."[/COLOR] my coding: Private Sub btnsearch_Click(ByVal sender As …

Ok here's what i want to do. I woul like to disable the toolbar and menubar in my main form depending on the usertype that was logged in. My dbase field is UserType and record type can only be User and Admin (Depends on the registration). When a user log …

I am quite confused how to encrypt the password store in the database so that if the database found by pupil it cannot take password from the table .Anyone can show me how to encrypt password .I m using microsoft acess as the databese. please help ....thx

Hello, Here is my dilemma and I hope someone can help me: [ICODE]Table1 [B]First Last Dept[/B] Dan Smith Accounting Joe Doe Admin Mary Boe Accounting[/ICODE] [ICODE]Table2 [B]Contact[/B] 068097110032083109105116104 (for ref. this is Dan Smith) 074111101032068111101 (for ref. this is Joe Doe) 077097114121032066111101 (for ref. this is Mary Boe)[/ICODE] I'm using …

It involves ASP ADO for connecting to database..I'm using microsoft access table... I'm a novice to web-development field... :( I know how to make table choice and display it through VB-Script,but don't have a clear idea for display of only desirable coloums,PLZ HELP..with it's ASP-code ,I tried a LOT! ITS …

Hello, Im creating a application in Microsoft access. I need to protect it with a license manager. I have built one but works from the computer. Whats i realy need is that i puplish my license database on the internet and in the application when you press active software it …

Hi ,I work with vb.net 2005 . I want to know if I want to connect to data base with Ms Access which data source i can use (ODBC or OLEDB) I write the following code in form load event (by OLEDB) : [COLOR=#0000ff]Dim[/COLOR] conn [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] OleDb.OleDbConnection([COLOR=#800000]"Jet OLEDB:Global Partial …

Hello Frends, I have an application where I am trying to connect MS Access DB with a ASP.Net(C#) Page and the same application also connect to the MS SQL Server (Working Fine). While connecting I am having following [B]error:[/B] _____________________________________________________________________________________ [B]Server Error in '/manager' Application. The Microsoft Jet database engine …

Can anybody help me in on how to connect my VB interface to a database. I have already designed the interface but I do not know how to connect it to Dbase. Damson

I have 1 desktop comp at home running xp pro. Then I have 3 laptops. 1 with 7, 1 with xp pro and 1 with vista. I was always able to access the desktop from all the laptops until.... The desktop was not allowing me to upgrade to internet explorer …

Hello, I am new to Access and VB, but I have used C# and C++. I am trying to update a whole bunch of records in a table, only one field. For example [CODE] [Employees] [ EmpCode ] [ FirstN ] [ LastN ] [ 019871 ] [ John ] …

i am trying to connect to an MS Access database but i am new to C#. I have looked at, amongst others, Paladin's response to dark omen about connecting to a database and since i have connected to a database before in Visual Basic most of it makes sense to …

I've looked at this from every angle, but can see nothing wrong. The MS Access table "LocationLinks" contains only 6 fields. LocationLinkKey - autonumber, primary key. LocationKey - long integer, required, indexed, duplicates OK LocationType - string length 4, not required, not indexed RelatedLocationKey - long integer, required, indexed, duplicates …

Hello all, I have msaccess that I use to insert data into a mysql database on a local in house server. Now what I would like to do is I have the below query [CODE] INSERT INTO User_logins ( GroupWiseID, ConnexLogin, [Password] ) SELECT NewHireIDs.[GW ID], NewHireIDs.[LIC ID], NewHireIDs.[ACD ID] …

I'm an intermediate vb programmer, i need help . I wrote a code that'll fetch a particular employee id (EM_ID) and print the report but its saying this whenever i compile and run. Runtime Error 2147217904 [80040e10] [ODBC Microsoft Access Driver] Too few parameters The code is below rs.Open "SELECT …

Hi All, I am in a process of trying to concatenate related fields field in Access. eg: consider the following table Awarded to On Date Emp1 01/01/1990 Emp2 02/01/1990 Emp1 03/01/1990 Emp3 04/01/1990 Emp2 05/01/1990 I want my query to return something like: Awarded to On Date Emp1 01/01/1990, 03/01/1990 …

I am using microsoft access as my database. When i click on the button Enter Details nothing happen. Please suggest where the mistake is. The doGet method contains the following code [CODE] super.doGet(request, response); String Name = request.getParameter("txtName"); String Designation = request.getParameter("txtDesignation"); Connection con = null; PreparedStatement pstmt = null; …

Hello, I am a current Java student and am having a problem when I run my compiled program from an in chapter lab assignment called "Stock Tracker". I receive a message from a dialog box "Cannot locate sun.jdbc.odbc.jbcOdbc Driver. Class not found exception creating database object. Following are a list …

I am using Visual studio 2005 and Access 2007. I get the following error "System.InvalidOperationExceptin: The ITransactionLocal interface is not supported by the 'Microsoft.ACE.OLedb.12.0' provider." Is this because transactions are not supported by access? Here is my code. [CODE] using (TransactionScope TransacScope = new TransactionScope()) { //insert and update operations …

Hello to all, I am always mad about this problem. If I type a name with two words in a textbox like "google corporation" it will be registered in the database ms access as "Google Corporation" now that is okay. What I want is, there should be no duplicate of …

So I have a small database for managing stationery orders (internally with my company - I order from the stationery dept). In the orders forms i have a subform with the list of items being ordered. I have the Item_ID, description, UnitsOrdered,UnitPrice, TotalPrice. What a code that will lookup the …

hi, how could i can connect C# with ms access 2007 as i want to use the data in a form of table in my C# program.As im creating a system to input the marks of the student and the list of student is in ms access so need to …

I'm new to Access 2007 need some help in regards how to build expression for the following - Product Price $: * Product Quantity - % (any number). Started with the following expression: Total Cost $: [Product $:] * [Product Quantity:] - [Discount %:]

[code]Private Sub Command1_Click(Index As Integer) If KeyAscii = vbEnter Then If Len(Trim(txtlogin)) > 0 And Len(Trim(txtpwd)) > 0 Then If CheckPwd(txtlogin, txtpwd) = "ok" Then MsgBox "Password ok" Else MsgBox "Wrong password or Login not found." End If Else MsgBox "Login and password should not be blank" End If End …

were i work has an access they use to record customer details which has been running forever and just uses a access macro form to enter the data. i am wanting to try viewing and editing this using vb,net which i have a little bit of experience with. can you …