Quiz Engine - Using Database To Retrieve Question
Jul 7, 2009I have been visual basic for sometime now and I want to develop a quiz engine that uses database to retrieve question. I also want it to be able to save users name.
View 1 Replies
ADVERTISEMENT
VS 2010 - Store And Retrieve Data / Search Engine For Database?
Jun 12, 2011How do you store data in the access database and also to retrieve it? and also a search engine for the database?
View 1 RepliesAccess Database That Has Nested Queries And Jet Database Engine
May 4, 2011I have an access database that has nested queries. For example, the querydef below is called qs_Pedon_type: SELECT qs_Pedon_basic.peiid, metadata_domain_detail.domain_id, metadata_domain_detail.choice, qs_Pedon_basic.siteiidref FROM qs_Pedon_basic LEFT JOIN metadata_domain_detail ON qs_Pedon_basic.pedontype = metadata_domain_detail.choice_id
[Code]...
DB/Reporting :: Which Database Engine To Use
Nov 12, 2010I am developing a software that connects to a database and manipulates product and user data. It works on my computer but it will have to be used by many computers maybe even world wide (who will access the same database) so I have no idea what kind of systems people will have. I still don't know how to ensure that they will be able to connect to the database for I have already had problems in Windows 7 computers which don't have jet oledb.4.0
I am a bit lost here because I don't know if I should first try to do a connect, or if I should first look for a jet oledb engine on the computer where the software is installed. And in case they don't have it installed should I prompt them to install it before running the program further? Or should I pack the engine along with my program? What is the line of thought here to make the program run on (almost) any machine?
Critical Bug In Access Database Engine 2010?
Aug 3, 2010just if you are using Microsoft Access Data Connectivity Components 2010 in your application to read data from mdb access files, you might get unexpected exceptions and your application will crash!To reproduce this behavior the best way is to run my sample application which will allow you to see the bug directly in no time.This behavior may occur at any time, any where, but I found if you use Application.DoEvents, you increase the chance to run your application to crash.To reproduce ::
1. You should not have any Office version installed on your system (I am using Windows 7 x64).
2. install the Microsoft Access Database Engine 2010 x86 (or x64 and you'll have to set your project to x64).[URL]
3. Download and run my sample application in VB.NT 2010, and press the button, you will get it [URL]Where is Microsoft going, do you think?Should I hope to receive an official response?
Database Engine Cannot Find Input Table
Feb 15, 2011I created a database and table programmatically with this [code]...
View 4 RepliesMicrosoft Jet Database Engine Cannot Open File
Feb 7, 2012I'm using old DAO 3.6 to connect Access database (with mde extension). App works fine on XP and on Win7/Vista when UAC is low/disabled. But when UAC is on I get following error: The Microsoft Jet database engine cannot open the file 'C:ProgramDatacompanydb.mde'. It is already opened exclusively by another user, or you need permission to view its data. [code]
View 1 RepliesQuery Engine Error When Change Database?
Jul 29, 2009I have an error to go mad. My vb.net application makes a report that runs fine in my local machine (with vs2003 and SQL Express 2005). My problem occurs when I execute this using an external database (SQL-Server 2000). Then my app returns the error "Query engine error: "c:....".The actually data origin for report is a dataset, and I've compared the two datasets fill
View 4 RepliesThe Microsoft Jet Database Engine Cannot Open The File ''
Nov 9, 2010i'm pulling my hair out on this one. the error i'm gettting is: The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.
[Code]...
The Microsoft Jet Database Engine Could Not Find The Object?
May 12, 2010I'm trying to import data from an exel sheet to a data grid but I keep on getting the following error "The Microsoft Jet database engine could not find the object"
Here is my code
Imports System
Imports System.Data
Imports System.Data.OleDb
[Code]....
Access Database Engine 2010 Crashes Application
Apr 8, 2011I have a vb.net 2005 application that connects to an access database. I use Access Database Engine 2007 to connect to to this database.
Everything worked fine until i install MS Office 2010. After this, the application started to crash, returning the error 'application has stopped working'.
I've a Windows Seven Enterprise SP1 32bits.
When i debug the application, visual studio also crashes. I get the following error, closing an OleDbConnection: 'vshost.exe stopped working'.
I decided to run some tests. I installed my application on 2 virtual machines: a windows xp sp3 and a windows 7. When i installed ACE 2007 everything worked fine, but when i installed ACE 2010, thats when the problems began. This behavior ocurred on both machines.
Installation Include 2007 MS Access Database Engine?
Dec 16, 2011It used to be that the VB6 installation tool automatically recognizes a MS Access dependency and includes the appropriate DLL(s). In VB.Net (2008) I am struggling with the concept of having to have two different installations, one for my tool and one for the 2007 MS Access Database Engine... Can you tell me if there is at least a way of manually including the appropriate Database Engine Files in my application installation?
View 6 RepliesMicrosoft Access Database Engine 2010 Redistributable?
May 10, 2010The 32 and 64-bit versions (of the ACE OLEDB Provider) have now been released to support Office 2010:
View 2 Replies.net - Syntax Error In INSERT INTO Statement - MICROSOFT JET DATABASE ENGINE?
Mar 9, 2011I developed a simple Access database and I create a VB .Net user interface. can't INSERT data into the Table here's my sample code..
Dim con As New OleDbConnection
Dim cmd As New OleDbCommand
Dim da As New OleDbDataAdapter
[code].....
Deploy A VB2010 Programme That Uses The 2010 Access Database Engine?
Nov 3, 2010I am trying to deploy a VB2010 programme that uses the 2010 Access Database Engine. The programme falls over when starting, with an error trying to access the Database. If I Install the programme on a machine that has Office 2003 installed - still installing the 2010 Database Engine - then it runs OK.Does the Database Engine work?
View 5 RepliesMicrosoft Access Database Engine - Failure Creating File?
Jul 12, 2010I've installed the Microsoft Access Database Engine in order for an app to read and update and Excel file using OLEDB on a 64bit operating system. It all still works fine on 32 bit however i get a "Failure Creating File" error on a 64 bit machine.I'm using the following connectionstring(VB.Net) as per [URL]:
lstrConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C: empexcelfile.xlsx;Extended Properties=""Excel 12.0;HDR=YES"";"
Import Data From An Exel Sheet - The Microsoft Jet Database Engine Could Not Find The Object
Jun 22, 2010I'm trying to import data from an exel sheet to a data grid but I keep on getting the following error "The Microsoft Jet database engine could not find the object"
Here is my code
Imports System
Imports System.Data
Imports System.Data.OleDb
Public Class ExellFrm
[CODE]...
Error "The Microsoft Office Access Database Engine Cannot Find The Input Table Or Query 'Puna'
Jun 6, 2011icant conect to database with visual basic i get this error "The Microsoft Office Access database engine cannot find the input table or query 'Puna'. Make sure it exists and that its name is spelled correctly"
Here is my code :Public Class dataLayer Private Shared connection As OleDb.OleDbConnection Private Shared Sub connect()connection = New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & IO.Path.Combine(My.Application.Info.DirectoryPath, "Fiskal.accdb") & ";Persist Security Info=False;")
[Code]...
Error "unspecified Error Microsoft Jet Database Engine" When Connect To An Access Database
Oct 29, 2010I am using VB .Net to connect to an access databse when using several connection sometimes i get this erro "unspecified error microsoft jet database engine" even though i am an administrator on my local machine.
View 1 RepliesIDE :: Failed To Retrieve Data From The Database, Database Vendor Code 9421?
Jan 17, 2011I have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error: Failed to retrieve data from the database. Details: [Database Vendor Code 9421]
Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.
Make A Database Application That Can Write/retrieve Cells/datasets From/to A Database
Apr 8, 2010i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
Error: Microsoft Office Access Database Engine: Syntax Error In INSERT INTO Statement
Sep 16, 2011this is my code for adding users in my database but it has an error on the INSERT INTO statement.here is the error: Microsoft office access database engine: syntax error in INSERT INTO statement.
vb.net
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
Dim conn As New OleDbConnection(cn)
Dim check As Integer
[code]....
Connect To Local Server - Error "The Microsoft Jet Database Engine Cannot Open The File"
Jun 22, 2009have this code to connect to local server:
[Code]....
Correct SQL Query: Error "Microsoft Jet Database Engine Cannot Find The Input Table Or Query 'IF'?
Aug 27, 2010The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
Correct This SQL Query: Error "Microsoft Jet Database Engine Cannot Find The Input Table Or Query 'IF'?
May 29, 2009i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
Best Way For Creating Quiz
Jun 21, 2010I would like to create a quiz and wonder what is the best way.
1. Using a textfile to read in the questions/answer
2. Using radio buttons
3. Or something else you suggest?
Make Quiz System Using .net?
Mar 31, 2011I make a 2 questions and then 4 choices for each question..and the 4 choices is made up with radiobutton.. and 1 of the 4 choices is only the right answer..Computing of right answer in each question is the thing that I want to know, how to do..
View 1 RepliesMaking A Quiz Using Access?
Aug 11, 2009I have created my own quiz for my aplication, but, a lot of people asked me , why can't the programe count right or wrong answers and one of them told me can you make a quiz that randomly selects questions?ok, I told them its all posible to make , but I actually coulndt make it working.So, usualy for a classic quiz I got the code to make a button go red if the answer is wrong, but I need the code line for the random question selection and the counting.I found some code but it didn't work,
View 3 RepliesVS 2008 How To Make A Quiz
Mar 11, 2011I want to make a quiz that generates score and save in access 2007.
View 4 RepliesCould Not Retrieve Schema From Database
Jul 27, 2011I am using microsoft access 2003 and visualbasic.net. I am trying desperately to add a database using the wizard, and it lets me go through with it, testing the connection is good, but when I try to finish it gives me an error: "<customers>Could not retrieve schema information for table or view customers." What am I doing wrong? I've added databases in the past without this problem using the same Access.
View 12 Replies