[microsoft:access] Forum Topics

Hi all, I've a Microsoft Access query problem that need help. I'm accessing the database via Visual Basic 6 Jet engine let's say the string value in the field as following:- 1111 1010 1234 I wanted to write a query to return any records that have the value of "1" …

Hello everyone, I'm trying to connect to a access 2007 database with VB 9 and am having some problems. I went to Data and then selected add new datasource. Then I clicked on database and selected Next. I click on new connection, change the datasource to access database file and …

Dear Dani, i don't know how to link VB 6 into the data base MS Access would you please give me a simple procedure or just a simple instructions how to do that.. Thanks for Helping God Bless........

Hello All, I am trying to add data from a dataset to an access table(.mdb). I am getting this error when I try to insert the values in the table. This is the code [code]DataSet ds = new DataSet(); Console.Write("The NAME IS: " + FileName.Text.ToString()); ds.ReadXml("C:\\Dallas_Test\\Offense_7_1_2010\\" + FileName.Text.ToString()); ADOX.Catalog cat …

How to Connect VB.net 2003 with MS Access 2003?????????

Hi, i get the following error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. this is my code [CODE] import java.sql.*; public class DetOrderNum{ public static void main(String[] args){ Connection con=null; ResultSet rs=null; Statement stmt=null; int pkey=0; String itemn="jin"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MY-PIZZA","",""); String q="select order_num from Order where …

Hey team, i'm having a problem with this query, [code] "SELECT * FROM marketingDB WHERE company_name LIKE 'allied' & '*'" [/code] the program ive written runs fine and it doesnt show any problem with the query infact the exact same query works fine on access but when i put it …

HI this is my code.it uses access database.But givs me this error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. import java.sql.*; public class DetOrderNum{ public static void main(String[] args){ Connection con=null; ResultSet rs=null; Statement stmt=null; int pkey=0; String mn="jin"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MY-PIZZA","",""); String q="select order_num from Order …

I am having a problem with the SQL INSERT command in VB. I am trying in move data from one table to another. The problem is I am going from a table with duplicates to one with no duplicates. Since there are duplicates the SQL statement bombs. Here is the …

Hello, I have created a query as follow in ms access: [CODE]SELECT cont.id, cont.name, cont.mobile_num, cont.date_created, memb.group_id, grp.name FROM (contact AS cont LEFT JOIN contact_group_member AS memb ON memb.contact_id=cont.id) LEFT JOIN contact_group AS grp ON grp.id=memb.group_id WHERE cont.removed=False ORDER BY cont.id DESC;[/CODE] and I created a 2nd query to query …

I am trying to do simple insert, update, delete, select statements within VB .NET to access a MS Access database. I have tried all kinds of solutions offered on the web and while the code seems to work, no rows are inserted. Also, I have tried, unsuccessfully, to use the …

Hi team, I'm having some issues getting the results of my query to output on a data grid. I'm using an sql query to get the data from access, which is working fine, but then I want to output it onto a datagrid. My code is as follows just for …

Hello, I have been trying to migrate some code I have written so I can use the advantages of Collection items in several forms I programmed in Access 2002. I was using an array list to collect information from a machine part and its resulting defect, then display a small …

hi,i am it student,ineed to help to have a simple java of an on reservation system using jsp.i just need java souse code how to connect access data base using jsp,please can any help me

I have been trying to connect Database in Java for a quit time now. Following is the code. I have worked with .mdb extension, but this time I am using .accdb extension. Database File. [icode] import java.sql.*; class DB{ static Connection con; static Statement sta; static void getDBConnection(String path) { …

Hello, I am creating a page that displays sections of a database based on ClassTypeID, and using the following as my SQL statement: [code]"SELECT * FROM Classes WHERE ClassTypeID=" & request("ClassTypeID") & ""[/code] The user will select a category from the following menu: [code] <p><a href="class.asp?ClassTypeID=1">Care Management</a> </p> <p><a href="class.asp?ClassTypeID=2">Claims/Customer …

Hi!, when im trying to execute following code.i get this error.can any one help me to make it correct. java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) at SelectApp.main(SelectApp.java:18) this is my …

I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" …

Hi, i want to retrive data from a table which has a composite primary key. This is the query im using; "select price from Item_size where primarykey='"+pk+"'" But it does not work. Im using MS Access. can anyone help me!

I have set the textbox to public so that another form can access it but when i run it in debug mode with the following line it gives me exception so it doesn't store correct directory. For example: If I enter D:\newfolder it gives me D:\\newfolder. Why does it add …

i am using visual studio 2008,windows vista operating system,i put the ms access database inside "c:/windows/test.mdb",i also put in c:/test.mdb.but in both cases when i execute update query it gives error-"Operation must use an updateable query".But it works fine when i put database in non-window drive as E:,P: etc,also in …

I have this code to enter data of checked boxes to be entered in other table of access database. I have taken template field and added a text box in Item Template but how to enter the text box data in a database on a button click. protected void Page_Load(object …

Take line below which is in batch file and convert it in C# so that I don't have to create a seperate file. Thanks! Any suggestions? I have spent way too long on this. Odbcconf /a {CONFIGDSN "Microsoft Access Driver (*.mdb)" "DSN=NexTest_CDMA_2009|Description=NexTest_CDMA_2009|DBQ=C:\prod\database\nextest_CDMA_2009.mdb"}

[CODE] //copy database files to target directory string fileName = "test.txt"; string targetPath = StaticFormInstances.choose.txtbxTargetDir.Text; string sourcePath = @"\\il93fil48\3GSM\release\testapplication_REL_01_00_09\database"; //Use Path Class to manipulate file and directory paths string sourceFile = System.IO.Path.Combine(sourcePath, fileName); string destFile = System.IO.Path.Combine(targetPath, fileName); //Create a new target folder if it doesn't exist if (!System.IO.Directory.Exists(targetPath)) { …

My window application gives error-"Operation must use an updateable query" while run in vista.I used update and insert statements.How can I provide permission to write/update in Ms Access database.

I'm hoping someone can help me here. I have 2 tables in a access database. I'm trying to join certain data points from both, simple. I've done a few joins already for this site. But the problem I'm having is this one seems to be destined to annoy me. [code]sql …

Is there anyone know how to use LIKE statement?

i am writing an application on my pc considered as client, to insert record on a microsoft access database on another pc that u can consider it as server, that has static ip address remotely.i can ping the remote address of the pc that i want to access without problems.the …

I'm learning C# on my own (I know C, Pascal, and about 8 proprietary languages) ... I'm stuck with VS2005 Pro (no budget) so I can't upgrade and I can't use Linq. I'm using Access just for simplicity at this point. What I'm trying to do, is what I've done …

Hi all, I'm working on conference room booking software with MS-Access as the back end. I need to retrieve the records which doesn't clash with the already booked dates. I have a table called conference_room_status which has the fields Conference_Room_Name | BookedPerson | DateFrom | DateTo | TimeFrom | TimeTo …

Function selectDB17() Dim cn As New SqlConnection Dim cmd As New SqlCommand cn.ConnectionString = ("server=EKS-HQ;database=BGB;user id=administrator;password=admineks2005") cn.Open() cmd.Connection = cn cmd.CommandText = "SELECT KODSTATE,USERID,PASSWORD,KUMPULAN FROM USERID" Dim lrd As SqlDataReader = cmd.ExecuteReader() Try Do While lrd.Read() If lrd.HasRows Then a = lrd("KODSTATE") b = lrd("USERID") c = lrd("PASSWORD") d = …

Hi all I am trying to insert a record into MS-Access database using VS2008 as front end and this is my code i am using to connect to the database. login.mdb has two tables(login,schedules) [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As OleDbCommand Dim myquery As String Dim count …

hi guyz! I've recently finished a database project in Access 2003 and have been asked to deploy it to network machines with Access 2007. the prblm i have is that the users r unable to add and update the records at the same time. how can i ensure that simultaneous …

Please give me an example of combined use of iif and isnull in access query?

Hello everyone, I am currently doing a treeview control in asp.net. I want to [B]load the database from MS Access into my treeivew[/B], but I don't know what should I type in my .apsx.vb file. [B]Please help me with the codes [/B]to make my treeview connect to the MS Access! …

How to display data from an MS Access table by selecting the a corresponding fileld from another table using VB .NET 2005?

Hi I have a very simple database which lists students who have went on exchange both in and out of our university. I am able to do a simple user entered query along the lines of [Enter university] or 'between [enter year] and [enter year]' but here is where it …

am working on my project and the requirements are that i develop a web site and have it connected to an access database. the site is ready and the database the problem is how do i connect to the database.could someone help please.

Hi There Is There A Way To Make Access File As Exe File Thanks In Advance

SCENARIO 1 : I have 3 projects in my solution: 1) Web Project (Presentation Layer) 2) Class Library Project (Business Logic) 3) Class Library Project (Data Access Layer) Following are the dependencies among these 3 projects: 1->2->3 (It means I have referenced PL in BL and BL in DAL. In …

Hello, Im creating a programme in access. Its not going to be so i need a license software. Can you build them in vb? Like. If the user enters in a key it checks the server and if it allowed then it activates the software if not then it says …

A co-worker upgraded Microsoft Access 2003 to 2007 on three networked computers. The rest were not upgraded. On the non-upgraded PC's we are able to open the database. On the 2007 PC's the file path does not work. I checked the access Trust Center settings and they seem to be …

hi i am a new memeber of this group. i am developing a web application which inserts customers details into databse when customer inserts his details on the web page. i need help regarding code to connect MSAccess database in ASP.NET.means if user inserts the details the details should get …

I Want the Sum of column in textbox using vb6 and access After Entering Dates in FromDate And To Date The Sum Of Column BalanceAmount Between These Dates Should Appear in Textbox2

Private Sub cmdsummery_Click() Set wss = DBEngine.Workspaces(0) Set dbs = wss.OpenDatabase("Gagedetails.mdb") Set rss = dbs.OpenRecordset("tblGage") 'Set rss1 = dbs.OpenRecordset("tblopeName") Do While Not rss.EOF OSQL = "SELECT DISTINCT OpeName1 FROM tblGage WHERE Date =" & SQLDate(txtdate.Text) Set rss = dbs.OpenRecordset(OSQL) MSQL = rss("OpeName1") NSQL = "INSERT INTO tblOpeName (name)" & " …

Hi, I have an access databse, but the data is link to excel, so i cant changes the data inside access database. However, i just want to retrieve the data inside the access database using VB datagridview, but the system pop out an error said 'cannot find the input table …

Some background: I'm a programmer, not a network administrator, who has been asked to migrate some accounting software ([url=http://ioasoftware.com]Integrated Office Accounting[/url] version 3.2) from an existing domain (OLD_NETWORK) to a new domain (NEW_NETWORK). No-body at the office knows how it works under the hood. It is a split Access 2000 …

Can I require the entry to be +-5 mintues of the current time? Thanks

Can you give me a sample registration module ? Please. Badly Need It.

Hi all I have Created a software using Vb.net and Ms-Access using VS2008. I am using ADVANCED INSTALLER to create a .exe Package and get its deployed. It works well in my machine but in the Destination machine , I get an error as shown below: [CODE] System.IO.FileNotFoundException: Could not …