Hi,
Please tell me if my query is suitable for this group or should I post this to the appropriate one. I am trying to find out if it is possible to create a new connection to an already opened database. I am using vb to create the user interface for my application.
I have programmed in a connection to a database file, which will display the file in the main window of the app. Through another form, the user can key in certain criteria which will be used generate a new qeury result of the already opened database file and display the query result in a new window. For this purpose, I have tested this by creating a new connection for the diplay form but I receive this error message :
'C:\MITalong\Project\test'. It is already opened exclusively by another user, or you need permission to view its data."
What is the correct way of doing this, ie. doing queries on an opened database file to generate result on another window. I am utilising the oledb as I wish for my app to work with microsoft access files.
Thank you.
Hi,
are you sure you are in the right group ? That sounds like a Access database file ratehr than a SQL Server file ? if you are using a Access database file you will have to tweak in the settings page, the lock status of an access database file which shouldn′t be then exclusivly locked if someone opens it.
Or are you using SQl Server Express userInbstance functionality ?
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Oops,
Thanks for the feed back. I final realised I have posted this to the wrong group.
Once again thank you.
|||Hi again,
I have rechecked all the groups desription in this forum, and this is where queries on oledb connections can be directed.
Yes, I am using access for my project using the oledb thing. I forgot to mention I am quite new to vb.net way of things so some terms used might be lost to me. Regarding my starter thread, does anybody have any ideas? btw, I am working on a window app, so there is no web usage.
Thanks.
No comments:
Post a Comment