Is it possible to use microsoft access database for Windows mobile application and save this mdb file locally in the pocket pc?because im trying to make an application to connect to mdb database but this imports seems to be not working.
HTML
Imports System.Data.oledb
oledb is not a member of system.data. why?
How do I save my dataset ,that is being filled in runtime, to a Microsoft Access database file (.mdb)?
View 3 RepliesI am writing a program for a class and it needs to read/write to an Access 2007 database. Right now I am referring to it's absolute path when I use it in connection strings, something like:
Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersMeDocumentsVisual StudioProjectsProject1Database.accdb")
This is going to be a problem when I turn it in obviously, because the professor isn't going to have the same path. So I want to somehow include it into my project and then refer to it with a relative path or something so that it will work on his machine. When I imported it through the Data Sources it had an option at the end to copy the database into the project which I agreed to. It put the Database where all of the source files are on my computer, so I tried using Application.StartupPath(
i am doing project of Order Accepting system for five star hotels.Scenario is Waiter will accept order using Window Mobile which is Connected to WiFi present in hotel.I want to communicate to database(Sql Server) present on My Machine (Computer present in kitchen) through WiFi and Add order into table present inside database. This should notify my application present on Compter and should print order. After completion of Order Application from kitchen will notify to waiter about completion. My problem is How to Communicate with database present on Remote computer using WiFi from windows Mobile.
View 2 RepliesI want to access the Windows mobile SQLCE database from the desktop application when device is connected to my PC.
View 1 Repliesi would like to build an inventory manager application that would have two versions :1. Would run on the desktop 2. Would run on windows mobile 6 I would like to have both these versions store and read data from a database that can be stored centrally either on a webserver or somewhere on the LAN.
I would like to know can i use Access as my backend database or sql server ? will windows mobile app be able to access it and read and write to it Note : I would prefer to create only one database that will just store the details in the tables and do not need any other functionality. All functions such as save,edit,delete,search,filter etc with be done from the FRONT-END VB.NET interface ONLY If you suggestion involves the use of 2 databases such as one for desktop version and one for windows mobile then please also tell me how would i sync the data between them.
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesIs it possible to use Microsoft Access Database (.mdb) in windows mobile software development?
View 2 Repliesin my application, to get the path I use the following code.
Dim path As String
Dim asm As [Assembly] = [Assembly].GetExecutingAssembly()
path = System.IO.Path.GetDirectoryName(asm.GetName().CodeBase)
this gives path as Application Data, But i need Program Files to locate the .sdf file. how to get this path?
I would like to create a mobile application for Windows Mobile, how can this be done? I have Visual Basic Express edition.
View 4 RepliesThis is probably a pretty novice design question. I'm trying to work my way through a number of requirements and give the users the experience they're looking for.I've written a tool that does big calcluation-type things. It currently consists of a class library and command line tool (separate .NET projects.) We're using an Access database format as the file type because it can keep all the various tables together in one file. A few other items about the application: There are not many users. There are no concerns with scalability. There are not great concerns with updates. Desktop is desired. Not web.Using VB and .NET 3.5 SP1
I now need to develop a GUI front end that will allow typical File/Open and File/Save type operations.Users expect that they can open a file, edit it some, then either choose to save it or close it unsaved without any changes being written back to the file. Saving it would obviously save all changes affecting all tables back to the file.
Does it then make sense to use a temp file for something like a proxy then? To, when a user "opens" a file, copy the source Access file to a local temp file and then use that for the editing session? Then, if the user "saves", copy the local temp file back to the source path?
Update: [tagged with ms-access tag too] Also, I omitted the fact that users would expect typical File / Save As functionality too. I think the design I've put in question in this post is what is traditionally called the Proxy design pattern. Has anyone tried this (successfully!) with Access database files before? Words of caution or advice?
i am creating an ppc application
I need to create an Order Entry System, which enables the sales executive to take order from the customers and feed them into there phones, and at the end of the day those phones will be connected to the desktop pc and all the orders should be synchronized with the desktop application.
DataBase part, i.e what should i use to save the data in the phone (i.e xml, db or anything else) and how should i synchronize it with the desktop software
I'm doing a project with vb.net (smart device) on visual studio 2008 and I need to connect to a database on the device itself (I do not have a physical device to test, only emulation). How should I go about doing it? I would like the database to be in the device on start up.
View 1 RepliesIs there any possibility to access directly from a Windows form created in VB.net a protected Excel file? I mean, that the password for opening xls file to be stored in VB.net Windows form. I also have the same problem for a Microsoft Access protected file.
View 2 RepliesI'm creating a small application that will export the record from database to excel format (.xls) and import the record from excel as well. i have this code below i dont if this the right approach but im getting the error. Im using emulator btw. error :"The process can not access the file 'My Documents est1.xls' because it is being used by another process." Code: I'm still figuring out about import function any ideas?
View 2 RepliesI made a Microsoft Access Database on my old computer and it worked fine with vb 2008When i try to go to my form containing the tables from Microsoft access, I get this message
View 3 RepliesI'm developing a aplication to run in Windows Mobile 5 I was design the first form, but when I try run them in the VB emulator, only appear the PPC with the Operating System. In the emulator, how can I try the sotware????
View 2 RepliesI'm developing a aplication to run in Windows Mobile 5I was design the first form, but when I try run them in the VB emulator, only appear the PPC with the Operating System.
View 1 RepliesI'm using Visual Basic Express 2008 (VB.NEt). I've created a project which
connect to a Microsoft Access Database (OLEDB) & displays the records using textboxes in the windows app.
I need to add a button which exports the database to a fixed length text file. Does anyone know the code I would use to do this?
What I need to create Microsoft Access database using VB.NET? I was looking for microsoft ado ext. 2.7 for ddl and security but I could not find anywhere.
View 2 RepliesI encounter some problems when doing coding of backup file by copy and paste the database(Microsoft Access File) to another directory. Example, textbox1 will show the path of file that I want to backup, textbox2 will show the path I want to copy to. I need 1 button for browsing the file and another button for make confirmation of the path that I want to copy to.
View 2 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"";"
how to load a .bak file of database backup in sql server 2005 using vb.net 2008 windows application?
View 5 Replieswhere can i find this application,i search the www.google.com to find this but i cant see this application i want to have a program in my pocket pc.
View 1 RepliesI am having a windows application. That downloads files from server and write into the local directory. It works fine. When we try the same appliication in Windows 7. IT shows an error Access to the path denied (While writing to the local directory).
View 1 RepliesWindows form application Access database Is it best practice to restrict user entry via keypress event
then validate all info entered & show error control message
or use dataset partial class columnchange as cannot restrict user entry here Could an experienced programmer suggest best way i actually prefer restricting keypress then loop through and validate all entrys
but want to be right
I'm currently doing a project that includes access 2010 My question will be what driver can I use for an access 2010 *.accdb type file? For a *.mdb it works perfectly well with
ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
But, when I changed the mbd to accdb:
ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"
It resulted in errors:
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'
And then it shows me that my code for
If dsLogin.Tables(0).Rows.Count = 1 Then
IndexOutOfRangeException was unhandled
Cannot find table 0
I knew it must be the driver but I don't know what accdb driver I can use for the connstring.
I am trying to write a code to save and open data that is in my application. My application contains hundreds of text boxes, combo boxes and labels. I have created an array for each set of data, i.e.,
glist(0).store=combobox1.value
glist(0).cat=combobox2.value
glist(0).it=label3.text
glist(0).quan=label4.text
glist(0).total=label5.text
up to glist(89).
Is there a way to write a code to loop through the array and save the values so that they can be opened at a later time in my application? The array will contain Doubles and Strings.
The problem has been simplified for the purpose of clarity. I want to make a windows form application that uses an access database. The application will store the list of person's basic details such as name, age and country. The database contains two related tables ie person(id, name, age, country_id) and country(id, country_name) My windows form contains TextBox, DateTimePicker, ComboBox for Name, Age and Country respectively. Now I want to make CRUD operation Programmatically (Not using Visual tools) in the same form with some navigation buttons.
View 1 RepliesI'm having trouble figuring how to code the calculations for a Pocket PC application that calculates the cost of a cell phone bill. From a Pocket PC the user should enter the number of minutes used during the past month, in order to calculate the cost of the cell phone bill. The plan allows 300 minutes for $29.95 per month. For each minute over 300 the cost is $0.17 cents per minute. Tax and Fees are $4.85 a month.
1. User enters the number of minutes used during the past month.
2. Based on plan rate of 300 minutes for $29.95 and 17 cents for each minute over 300 calculate the cost of the bill including the fixed cost of $4.85.
3. The user must be able to initiate the calculation and display the individual charges and the total cost of the cell phone bill.
4. The user should be able to clear the number of cell phone minutes, the individual charges and the bill total
If negative number is enterd for the cell phone minutes, the user should be advised and asked for a valid entry If non numeric value entered for the cell phone minutes, or if left blank the user should be advised and asked for a valid entry.Application is deployed on the Pocket PC emulator built in VS 2008
Enter # of Minutes ________ (user enters)
Regular Minutes Charge ___ (29.95)
[code]....