I 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 Repliesjust 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?
i wanted to know how to deploy a simple program that is coonected to a access database.I have tried it many times but when I try to install it says that some file is mising. How can I do it so that I dont have to copy the database from one computer to another.
View 1 RepliesI 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.
The 32 and 64-bit versions (of the ACE OLEDB Provider) have now been released to support Office 2010:
View 2 RepliesI am writing an app in VB2010. My code parses a text file, assigns data to variables My??, and then attempts to store this data in an access 2010 (actually access 2007 format) table. Yet, whenever my code gets to MyRow.Item("Artist") = MyArtist I get an error 5 'Artist' does not belong to Table MyTable, but the field/column does exist in the table as do all the others.
01Dim tbl As DataTable = New DataTable(MyTable)
02tbl.Rows.Add()
03Dim lastRow As Integer = tbl.Rows.Count - 1
[Code].....
Basically, I want to design a strategy game, where most of the game will be spent in menu areas and making "decisions" (like a Tycoon style game), however, there will still be some graphics, and I would prefer 3D, but if not possible, can resort to 2D. The graphics aren't user controlled, but the moving objects will be the result of the "decisions" the players make.
I really just want to write it once, and have it run on the following Platforms:
Windows Desktop
iOS (iPhone, iPod, iPad)
Android Phones (not strictly required)
(any other platforms would just be a bonus, but at the absolute minimum, all i really want is Windows Desktop and iOS [iPhone, iPod, iPad]).
Now, I don't want to learn objective-c or any other languages which i may have no use for in the future, I really just want to be able to program in Visual Studio (VB.Net or C#, since I can convert from vb.net to c# I will just be writing it in vb.net).
Is it possible to write in vb.net/c# and deploy to all these platforms? I heard of MonoTouch, so i can convert from vb to c# but is this seemless or difficult to do? Do I have to learn and write in another language in order to make tweaks to make it work on the iPhone or Android? So, with MonoTouch, can I still use XNA or is there a different engine that I need to learn/use with Visual Studio?
Alternatively, if I cannot do this all in VB.NET or Visual Studio, what programming language and/or graphics engine should I learn in order to be able to write once and deploy everywhere that is relevant? (So, not fussed about Linux, Mac's or other less used OS's).
Right now, I haven't learnt XNA but am wondering if I should or need to, or if i should learn another engine & language. Basically, I don't really know what I need to learn/know in order to be able to write once and deploy on Windows Desktop, iOS (iDevice's) and maybe Android. So, my question really is, what do I need to learn in terms of both the programming language and game/graphics engine. Right now I know VB.NET and would prefer to use what I know, but if not possible, then am prepared to learn another language & engine combination to be able to achieve what I want, if this is what I need to do, I would like to know what language & engine I need to learn.
I 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]...
It 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 RepliesI'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"";"
What are the steps to build and deploy an application using VB2010?Were the deploy package and files are located after the deployment?My experience is deploying under the VB6 enviroment or Install Shield.
View 2 Repliesicant 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]...
How do you store data in the access database and also to retrieve it? and also a search engine for the database?
View 1 RepliesI finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path "program files" and this path is only read And my application crahed. I know how to installer put database in other path but I don't know how to tell my application to find this database,
View 4 RepliesI am trying to 1) write code in VB2010 that will get a JPG image from a Access Database field and write the image to a PictureBox 2) write code which will write a JPG file to an Access Database field. I have already sucessfully coded this in VB6, without fully understanding what I was doing.
Browsing the various forum's I have come across a few discussions on this subject, but due to my complete amerture status I don't seem to be able to follow the logic.
Below is the VB6 code
Writing JPG file to DataBase:
Dim bytBlob() As Byte
Dim intNum As Integer
[Code]....
this 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]....
I 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 RepliesI have a problem when writing to a ms access database file, here is my code:
My problem is I get the following error and I dont know why: ERROR : Syntax error in INSERT INTO statement. on statement " da.Update(dt)"
Private Sub cmdsubmit_Click(sender As System.Object, e As System.EventArgs) Handles cmdsubmit.Click
Dim con As New OleDbConnection
Dim dt As New DataTable
[CODE]...
I have a table in ms access. I need it to be imported to the Datagridview in vb 2010 in customized format . The below shown is my access table.
[Code]...
I am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 RepliesI made an app that uses a Access Db extensively(will be changed to sql later). I have hard coded the location of the db into the app,i use one click to deploy the program and then i manually copy the database into the location.
View 7 RepliesI 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?
Let's say I roll out version 1 of this project for many users. As time goes by I update the code, change the Access db strucutre here and there, and would like to roll out version 2.What is the best way to do this?Is there an easy way to get the differences between version 1 and version 2 of an access db?
View 6 RepliesI have an vb.net application that I want to install on client machine. The backend is SQL server. Could I make up a setup package that would deploy an application that includes the database with all the stored procedures and tables? The client pc do not have sql server installed there.
View 14 RepliesI connected my project to a sql database - i created the database in sql server 2008..
my project run ok in Visual studio but when i deploy it, it cant find the database
can anyone tell me how to deploy a database with my project?
Does anybody know how to deploy SQL server database using VBnet.(When you install application on user computer, application should be setled to use database, How?)
View 1 RepliesI coded a program to access a Microsoft Access 2010 database. The program is written using Microsoft Visual Studio 2010. I get the error message that the database I'm trying to access is in an invalid format. look at the code below to see what I missed. The error is in the datasource statement.
[Code]...
I created a database and table programmatically with this [code]...
View 4 RepliesI'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 RepliesI 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 Replies