I am getting the following error in my application: Quote:
System.IO.IOException was unhandled Message=The process cannot access the file 'C:UsersSimonDocuments3Categories.wsp' because it is being used by another process.I understand what it means, but am not sure why it is happening. It happens after I open a file and try to save it to the same name. Here is my
[code]...
I am trying to open an Access file but so far I am not succeeding. [Code] I receive following error: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. I am sure the file is not open and I tried already to add in the connection string: ;User ID=User and / or Jet OLEDB:System database=C:SYSTEM.MDW; at the and but without result.
View 8 RepliesI have some coding which edits my text file and saves two versions, the first version removes all multiple space with one space and saves it as a text file and the second replaces the spaces with a comma and saves it as a csv file. The problem I have is however later on when I run other code using the saved text and csv files, it looks like the processes are in use. I get the following error:
The process cannot access the file 'Path' because it is being used by another process.My actual coding:
Private OpenFileName As String = IO.Path.Combine(Application.StartupPath, "TextFile1.txt")
Private SaveFileName As String = IO.Path.Combine(Application.StartupPath, "TextFile2.txt")
Private SaveFileName2 As String = IO.Path.Combine(Application.StartupPath, "TextFile3.csv")
[Code]...
I am using following code to add my application to StartUp of Windows. It works well in XP but gives error in Vista that you donot have permission to edit registty file.[code]
View 1 RepliesSyntax error (missing operator) in query expression '''system time'''.this is the error that appears
this is my code:
Dim sqlCmd As String
Dim x As Date
x = Format(Now(), "General Date")
[code].....
the fields in the tables are all text fields.is there any way to fix this error? perhaps it is in my query but i really cant find a solution.is there an alternative to get what i want my program to do?it is basically entering an ID number and finding the record with the same idnumber and putting the system time on the timein field for that record.
I am using net 2010 net framework 2 & w7 In windows explorer I want to move or rename a file but I get a windows message with a heading "File Access Denied" you need administrator permission to do this In my vb code I want to move the same file but get an error, the security on the file is "Read & execute" and "Read" How do I detect this before the code for moving & also set the permissions so I can move it with vb code.
View 6 RepliesI am using the following
Dim folder As New DirectoryInfo("C:windows")
Dim files() As FileInfo = folder.GetFiles("*.*", SearchOption.AllDirectories)
[code].....
I am new to this forum. I have win 7 OS. I have VB5 installed and runs no problems. I just installed Visual Studio 2010 Express for VB2010 use. Installation OK no problems. Today I tried to do the first tutorial to create a VB project and get error "Requested registry access not allowed". I have tried a internet search for fix but nothing is fits or works so far.
View 2 RepliesIs it possible to check the Application Type(Console Application, Windows Forms Application) at run-time.I have been looking for 2 days, most of the happy application info has been made available with my.application.info but where is the application type?
View 1 RepliesI reproduced the following code to update a database and I get the error" Operation must use a updateable query"
[Code]...
I am using Visual Studio 2010 Ultimate, I developed an application in Visual Basic and that is running successfully when I copy this application to other system then it does not run and .Net framework is installed on other system.
View 3 RepliesI am trying to do an insert into an Access 2007 DB but keep getting a syntax error even thougt I can get the generated query and run it in Access and successfully add to the table.
Code....
Private
Sub
ButCommit_Click(ByVal
[code]....
Been reluctant to drop this on anyone as I wanted to resolve it myself but alas it has got the better of me. I am trying to do an insert into an Access 2007 DB but keep getting a syntax error even thougt I can get the generated query and run it in Access and successfully add to the table.
PrivateSub ButCommit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButCommit.Click
con.Open()
[Code]......
How to allow duplicate,orif I enter a duplicate, to display Msgbox.
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].....
I am totally new to Microsoft Access and VB, what i am trying to do is i have a form with unbounded textboxes which i would like upon clicking a button save the text in each textbox in its unique field.[code]...
View 2 RepliesI'm trying to import data from a VB form into a database; 5 fields, 1 being an auto number, 2 getting information from two text boxes, and the final two being data and time stamps. I've inserted the code, it runs fine but when I press the button to insert, I get the following message;
System.Data.OleDb.OleDbException (0x80040E14): Syntax error in INSERT INTO statement. [Code] If anyone could point out where I'm going wrong, or if its my database connection that is incorrect, that would be a great help.
The following code worked on my 32 bit XP system. On my 64 bit Windows 7 System I get the follwing error.
'A 32 bit processes cannot access modules of a 64 bit process.
I have also noticed that the Platform is x86, and I have no option for any other platform?
Dim sw1s As String = " /C/Y/E/H/R/I"
If Not cbIGN.Checked Then sw1s = sw1s.Insert(1, "/M") Else sw1s = sw1s.Insert(1, "/D:1-1-1901")
'define command
[code]....
i have this code that should update my data base but i kep gething an error saying: its not possible so change or delete the regists Because the table 'MembrosCompasso' has relating records
[Code]...
I'm trying to download a simple text file from a web server. It's easily accessible from the web browser and I can download it from the web browser. However, whenever I use a WebClient to download the file, I get a 403 Access Forbidden Error! I'm not sure what I'm supposed to do. I haven't come across this kind of error in programming before and I'm not sure what I'm supposed to do to get around it.
View 2 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.
What i've written opens an Access database and one can read and write into it (on a table called Journal)It does indeed work for newly made Access files. However it doesnt work with a specific Microsoft Access database (again .mdb) which was made with a very old Access, like Access 2000 or something.The error message is: Syntax error in INSERT INTO statement.Inside the zipped file below you will find the source code of the program, along with an access file that the program CAN read, and the one access file that i NEED the program to reed but it cannot!
To see what i mean run the program one, try to add a new line to the database. you get an error!now rename the Journal.mdb to "journal.bak.mdb. And the journal_working.mdb to Journal.mdb try to add a new line to the database again without altering the source code at all. it succeeds now!!
NOTE: the program can READ data from both files. but it CANT write data to the old access file
this is the code:
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim dsNewRow As DataRow
dsNewRow = ds.Tables("AddressBook").NewRow()
dsNewRow.Item(1) = txtFirstName.Text 'or .Item(1) =
[code]....
File Access Error (by another process)
View 5 RepliesI am trying to create a ListBox in which every item can have it's own context menu. To do this I have created the classes as shown in the code. Now when I test this, I get the following error when adding an item to the collection using the 'Add' method:
INTERNAL ERROR:
Unhandled exception in Debugger::HandleIPCEvent.
Event ID=0x246.
[code].....
I have a weird XP only error. When i distributed my application to XP user it said right after he clicked the .exe without the GUI of the form "Application has encountered a error and program needs to close".
View 12 RepliesI need to check and see if I can access a file(the file is in use) So When I try to access it the application crashes. When I can access the file without the application crashing I would like a msgbox to pop up.
View 3 RepliesWhy is it that when I'm trying to run my program i always see this error>>>> syntax error in insert into statement.....i declared everythingin this function has an error:
if inc <>-1 then dim cb as new oledb.oledbcommandbuilder(da) dim dsnewrow as datarow dsnewrow=ds.tables("ryan").newrow() dsnewrow.item("ID")=textbox1.text dsnewrow.item("Password")=textbox2.text ds.tables("ryan").rows.add(dsnewrow) msgbox("data added!")
I 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 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 trying to insert data from a text file into an Access table. However, when I try to execute the command, I keep getting the following exception:A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll.And my Catch block throws me the "Unable to read file" error that I placed.[code]
View 4 Replies