i know oledb is not supported in 64b. I have read the application must to be compiled in x86. But it doesnt work.
As i said:
-windows 7 64b
-vb.net in visual studio 2008
-office 2003
i have design a window base application by using VB.NET 2008 and use database SQLCE 3.5 SP1. The application is working fine on all the window 32bits system, but if executive on window 64bits (like windows Vista 64) come out this error message.
[Code]...
I created an vb.net Application with microsoft visual studio 2008 and Access 2003 as Database. The application work fine in XP O/s but when i run the application in Windows 7 it gives error when connecting to Database. It works fine when i create an new Access 2003 database in Window 7.It gives error System.Data.OleDb.OleDbException: Operation must use an updateable query.
View 1 RepliesThis my code in VB.NET. My try catch says there is a syntax error in the instruction INSERT INTO. I don't know what happened to my INSERT. I searched for the error for over an hour... I'm not an expert in VB.NET, I'm better in C#, but I need to do this anyway in VB..
[Code]...
I'm wanting to alter a column in an acces database, to a Random AutoNumber I know how to do it for incremental e.g."ALTER TABLE MyField Counter(1,1)"but how do you do it for a Random Autonumber??
View 10 Replieshow to open password protected MS Access database using vb.net windows application?
View 2 RepliesA few years ago I created an application using VB6. It works fine on all OS but considering vb6 is no longer supported and it lacks lots of features, I've decided to upgrade to VB.NET. Plus I also want my software to run on all future OS correctly. I was using the ADODC control on many of my forms. In VB.NET, if I go to Tools > Choose Toolbox Items, I see ADODC under the .NET framework components tab. Can I still use this or is it outdated/no longer supported? If I use it, will my software work on 32bits and 64bits systems? [code]But in VB.NET when I write this I get the error As Any is not supported in Declare statements. How should I write this in VB.NET?
View 3 Replieswriting user info such as user, computer name, date, and time to an acces database using a button click event. Then use a query to check if the user has accepted the aggreement. If the user has accepted the aggreement then call a vb.exe that display the aggrement. I have a login script that runs the vb.exe and uses a button click that records the user info to a csv file, but if the user has already agreed to the policies I do not want it run again.
View 4 RepliesI have use VS2005, I have open windows explorer from code. when i click on search button it open New windows, and in this I click on All files and folders in Look in : combo by default C: and D: drives are set.
[Code]...
How do I open a Windows 7 Library like Documents, Pictures, Music, Videos and all other custom libraries from my app? I tried opening explorer.exe LibrariesDocuments but it doesn't work.
View 6 Replieshow we use inner join in oledb( acces ) ? this is false :
cmd = New OleDbCommand("select lesson_name as ,lesson_type from choice inner join present on choice.p_code=present.p_code inner join lesson on lesson.lesson_code=present.lesson_code
and this:
[Code].....
I can't seem to write to my database. No errors came up These is my code and declarations
Imports System.Data
Imports System.Data.OleDb
Imports System.Net
Imports Microsoft.VisualBasic
Public Class frmChange
[Code]...
My mdb file has all the tables set. The database isn't being copied to the bin folder
I have a windows service that connects to a database to read a few names of processes to control them.The problem I have is that if I run the service on the machine where I have the database works perfectly.However if I run it from other machine on the same network can not connect to the database.With the aggravating circumstance that an independent application with the same connection string is that machine if it connects to the same database. Shortly that an indepenciente application connects with this connection string but a service not[code]....
View 3 RepliesHow could you accese and other computer via localhost or internet wiht vb.net. Not controlling but something like a chat box.
View 14 RepliesI've made an app that first extracts an iso file to a folder. Say the folder is "ExtractedIsoDir", this folder is created in the same directory as the app.
Inside the iso are only folders, so you get a structure like "ExtractedIsoDirFolder1", "ExtractedIsoDirFolder2" etc.[code]...
I'm trying to get the first subitem's text from an item in my ListView. Here is the code I'm using[code]...
View 2 RepliesFor the application im writing i need to access files on a network server. I have tried different ways, but none of them seem to work.When i try using impersonation i keep getting logon failure (1326). I did try few solutions i found on the net but none seem to work.
View 1 RepliesMy program involves accessing a print preview dialog.
It works just fine the first time. However, when I close the printpreviewdialog and then try to open it again (through the button) in the same run
then I get a "cannot access a disposed object" runtime error. Hence, it can only work once during a program run.
in my project, when a new user register online on my website, then my project create a directory on server with the user name "abc" and copy a myDB.mdb file in it.this .mdb file contains predefined 2 tables.now my question is :1 is it possible to connect and use with Dataset.xsd in this task.2 how each user read and write data with there own myDB.mdb file
View 1 RepliesI have a database in MS acccess, in 2 of my fields put some dates (but not on all rows).In DateField I put date as "dd.MM.yyyy" and in TimeField I put hours as "hh.mm"Now, in my vb datagrid I want to be shown only rows that has a date and n hour on the columns with dates and hours , and the dates must be latest 24h
Private Sub ultimile24_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'NavsitDataSet.nave' table. You can move, or
[code].....
I just want to read some data from a database (a table) but I am not sure how.
View 10 RepliesIve made a code that will read a database but i need a button that will "Create an account" and save the details into the access database so it can log in.
Here is my code so far
Imports System.Data.OleDb
Public Class Form1
Private Property Form1 As Object
[CODE]..................
How to save a data i entered in vb form into .txt or acces db, for example i have a form, and there is some text box in that form, then i write a text in that TextBox then i save all into txt file or Access DB, and i can open or load that file into my aplication. i use SaveFileDialog but how to make i can chose a file type to save it?
View 8 RepliesI'm developing an application that controls the rest of the machines inside a local network and when i try to send a command to Shutdown remotely a pc in this LAN, i get the error Acces Denied, i've changed the Security Policies of that machine por testing purpose at:[code]Changed to this option "Classic - local users authenticate as themselves" as i read in other posts.But still getting the same error, i dont know what's wrong... all OS on my LAN are Windows XP Pro Sp2, and all of them boot Administrative user without entering any password.
View 9 RepliesI want to write data from a DataGridView to an MS Acces Table, BUT I want e.g. cell in DataGridView to be cell 1 in the Acces table.
View 4 RepliesIm trying to add an export import method in visual basic. Export from Access database to Excel Worksheet or .csv. And Import From Excel worksheet or .csv to Access database
View 3 RepliesHow can I make a progress bar that shows when I acces some items on a listbox. It fills only when I click on listbox items, and then gets empty imediately.
View 2 RepliesI am working on a signout system I have a good start but am trying to solve a small problem.Signing out equipment I fill part of a form with student data from the dataset with Fillby, fill the other half with equipment data using Fillby1 I then save this combined data to my Access 2007 Database using a OleDb.OleDbConnection.
[Code]...
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 RepliesO/S WIndows 7
SQL Server : SQL Express 2008 R2
VB 2010 Express
SQL Server is located on the workstation so the code and the DB are on the same PC
Created a DB connection using the wizard. Tried this with Windows authentication and SQL authentication using sa
Created a Dataset and dragged the grid onto the form1.vb.
In SQL Sertver Management Studio I can update update tables using the same credentials as in the VB connection string
WHen I try to update a record in the VB Dataset it returns the error cannot update database because it is read-only
I have checked the files and folder attributes in SQL Data folder. Nothing is set to read only
I have checked SQL Server Database > Properties > Option > State > Databse Read only = false
I don't what I'm doing wrong here but I cannot get VB to update data via the dataset.
Inotice in SQL Server that the DBname now includes the full path "C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL10_50.SQLEXPRESSMSSQLDATAPAYABLES.MDF" and not just the DB name. Is this becuase VB Express requires you to point to the physical DB file?