.net - The Microsoft Jet Database Cannot Open The File '...' It Is Already Opened Exclusively By Another User
Sep 1, 2011
I have a WinForms application that I have taken over support for and it was build using Visual Studio 2005 with VB.Net. The application makes use of an Access database. It runs fine when it is installed as a standalone application, but the install cd for the application also allows for a network install and this is where I am currently encountering issues.
To test the network install I created a folder on my server (Windows Server 2003 SP2) and copied the Access database to this folder. I created a share for this folder and gave everyone full permissions to the share. Then on the workstation I installed the application and gave the path to the database as follows:
\myservermysharemydb.mdb
(The install steps here are as per the instructions given on the installation cd)The workstation that I installed it on is Windows 7 Ultimate. When I run the application, I get the error message given in the title when the application tries to read the database file. I have confirmed that I am able to write to the shared folder on the server, so I don't think this is a permissions issue. Also, the database file is not in use at all, so it is definitely not opened exclusively.
UPDATE:I have tested the workstation installation on a computer with a fresh install of Windows XP SP3 and it is able to access the database file without a problem. So it seems that this error that I am getting is somehow specific to Windows 7. Is there maybe a known issue with Oledb drivers on Windows 7? My version of Windows 7, btw is 32 bit.
View 1 Replies
ADVERTISEMENT
May 14, 2010
The fact is I'm making an application, which users can install by using a Setup file...once installed the data in the database can be updated by a centralized server. To do this, they can insert a DVD/CD-ROM and export the necessary data towards it. I need to do it that way, because some of the users who really need this data will be using stand alone computers.The application gets it's data from a mdb-file and the connection remains open as long a person works with the application (maybe not the best way to do, but I know :-) )...when the user uses the application, he can perform an export...this exports the .ini-file and pictures (which works fine), but he also needs to export the mdb behind the application...I already tried connection.close() before and connection.open() after the System.IO.File.Copy...but that doesn't seems to work.
View 2 Replies
Feb 7, 2012
I'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 Replies
Nov 9, 2010
i'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]...
View 6 Replies
Jul 14, 2011
How to upload text file and microsoft office file to mysql database using open file dialog.
View 1 Replies
Mar 15, 2012
I made a quick search program so when I browse for a text file, it adds that text file to a listbox1. And then when you search result will be placed in listbox2 Now I'm wondering how to force the program to automaticly load last opened text file on startup.I tried with this and then I stuck.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim reader As IO.StreamReader = _
New IO.StreamReader(winDir & "system.ini")
[code].....
View 19 Replies
Jun 22, 2009
have this code to connect to local server:
[Code]....
View 6 Replies
Jun 5, 2009
Is there a better way of finding the path of a file that was opened with the open file dialogue? This is what I did. It works, but it seems like there should be a way to get the path through one of the open dialogue options.
Code:
'm_PicSource = OpenFileDialog1.FileName
'm_PicSource is a global var
Dim strCnt As Integer = m_PicSource.Length - 1
[Code].....
View 6 Replies
Jan 10, 2010
So I open files and do whatever with them right. I've set the initial directory to equal the last directory, but whenever I open multiple files, it never sets the directories properly. It acts as though nothing was opened there, so it takes the previous directory as the last one. Thoughts on what's not working? Here's the code.
Code:
With FileOpenDialog1
.InitialDirectory = LastDirectory
If .ShowDialog = DialogResult.OK Then
[code]....
I have multiselect enabled earlier and everything else works but this. When you open a single file, the last directory works fine. It only happens with multiselect.On another note, does anyone know why it freezes when I try to do a lot of files and use another program? I opened 700+ files to see what would happen. When I switched to a IM convo, it froze. When I left it to run, it worked.
View 3 Replies
May 4, 2011
I have a couple of files which I have to update periodically through a process written in VB.net . These files are on a server and part of a domain that many users can access. These files should never be written to as they are for reference only. I need to be able to overwrite some of them even if a user has them opened. Is it possible to do this? Presently the files permissions are not set as read-only but I can do this as long as the user under which the process runs will still have permission to overwrite them.
UPDATE: thx for your responses. The files are pdf and are opened by clicking on them from windows file explorer. This also happens when a user simply has the file selected in windows explorer.
View 2 Replies
Apr 26, 2012
My program opens 4 excel spreadsheets updating info. I update one at a time and then close it before opening the next one.I want to add code to my program to test if the file is already open, before trying to open it. Occasionally someone will have one of the files opened and it causes a crash. If I test to ensure it is not open, then I can avoid this.
View 7 Replies
Oct 14, 2010
[URL] to create my sqlite db file. I created it as a sqlite db version 3 file. When I go to open the connection
[Code]...
View 1 Replies
Feb 20, 2010
I can't connect to my database now, although yesterday it was perfectly fine. An error message comes up saying "...A database with the same name exists, or specified file cannot be opened, or it is located on UNC share" this has never happened before. Why can't I access my database?
View 2 Replies
Aug 25, 2009
Is it possible to open a .sdf file in Microsoft Access?
View 2 Replies
Jun 25, 2011
I have downloaded and installed Visual Basic 2008 Express Edition today, as my hard drive that had Visual Basic 6.0 is getting old and was nearing the end of its life cycle. I have a new CPU as of yesterday.Anyway, now that I have Visual Basic 2008 Express Edition installed, I am working on converting the code from my Price is Right game to VB2008 Express code.When I used this code in 2008 Express...
Private Sub GetNames()
Dim x As Integer, tmpstr As String, tmpstr2 As String, tmpstr3 As String, tmpstr4 As String, tmpstr5 As String, tmpstr6 As String, tmpstr7 As String, tmpstr8 As String, tmplng1 As Long, tmplng2 As Long, tmplng3 As Long, tmplng4 As Long, tmplng5 As Long, tmplng6
[code]....
I got a message saying "Open is not declared. File I/O functionality is available in the Microsoft.VisualBasic namespace."
View 10 Replies
Apr 4, 2012
Currently i'm opening childforms like this:
Dim backupform As backup
backupform = New backup()
backupform.MdiParent = Me
backupform.Show()
MenuStripFix()
backupform = Nothing
How can I make it so if the menubar is clicked and if the childform is open, the open childform is showed and not a new one.
View 2 Replies
Dec 3, 2009
I've been working on an application for awhile that, basically, allows the viewing and printing of a maintenance database. It allows the user to view basic information for the object and then view the maintenance history. My approach for the maintenance history is simply to have unique tables per object since a history has to be kept for each, however, I'm running into a problem in the application that allows the user to view the general information from one DB and the Maintenance history from the other DB.
Say you have Object ID BG1. I can enter the object ID into a search field, pull the data from the general DB and display the data, but I also need it to pull the information from the maintenance history and display. If maintenance history for this object is not found, then create a new table within the DB, fill the columns with the required fields and allow for the user to edit the history.
View 6 Replies
Feb 2, 2010
I have multiple tabs opened in 'any browser' and one of it is titled 'LAME', how can i make links open(by buttons) in that tab? I have a simple form with two buttons,
Button one:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Process.Start("http://www.google.nl/sub1")
End Sub
[code]....
View 2 Replies
Aug 7, 2009
I'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?
View 22 Replies
Mar 22, 2011
I 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 Replies
Jul 12, 2010
I'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"";"
View 1 Replies
Aug 20, 2007
I have a method that allows a user to open a file. The InitialDirectory property is set at the beginning of the method. If the user selects a file in a different folder, the next time the dialog opens, it opens to the last folder used insted of InitialDirectory folder.
View 9 Replies
Aug 17, 2009
How do I save my dataset ,that is being filled in runtime, to a Microsoft Access database file (.mdb)?
View 3 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 1 Replies
Jan 8, 2011
I have a application which reads from ini at startup, What i want is a vb code that will block the user from opening the ini file manually, program could be running as service eg: C:config.ini. program should block the user from opening the file.
View 1 Replies
Oct 8, 2009
i am stucked with a procedure in my app. this procedure do monitor application.startuppath folder. if this folder is opened by user my application should close it.i have tried it to be done with system.Diagnostics.process. but wont be able to make it possible.
View 9 Replies
Mar 31, 2010
I have a excel file place on server. I am using a application which written by VB.NET to open file in read only mode. User 1 open file in read only mode. How can user 2 detect that file is open or not status?
View 2 Replies
Jul 31, 2011
I want to create a small application in VB.Net which will zip the file such that when user will unzip this file, a url will be opened in user's default browser. Is there any way to create such files?
View 4 Replies
Nov 6, 2009
Open a pdf file with user password in vb 2008
View 6 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP.I created a database on my local PC HDD. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service.The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 10 Replies