473,326 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How do I open a database connection on an access file that currently open ?

THY
Hi,

I have create a connection to an access database, but before I close the
connection,
another user cannot run the web application correctly, I got the error
Operation is not allowed when the object is open.

is it the problem of my connection string ?

thanks
Nov 17 '05 #1
4 1112
access files accept only one connection (this is a file : when it's open
it's locked ) you have to use a server like MSSql,MySql,Oracle,...
Nov 17 '05 #2
THY
If it is locked, why we still can open the data file using ms access ?

btw, can we make the page to hold until the database is close then open it ?
so the user wont get any error if the database currently is opened ...
is this possible ?
"Gönen EREN" <ge***@gsu.edu.tr> wrote in message
news:uo**************@tk2msftngp13.phx.gbl...
access files accept only one connection (this is a file : when it's open
it's locked ) you have to use a server like MSSql,MySql,Oracle,...

Nov 17 '05 #3
THY
I don't know much about mysql ...
how do I connect mysql with ASP.NET ?

and can mysql import access ?

thanks
"Gönen EREN" <ge***@gsu.edu.tr> wrote in message
news:ud**************@TK2MSFTNGP09.phx.gbl...
yes you can try to make something like this
using

try{}
catch{}

but why access?
access isn't a database server
you can use for example MySql, it's free
www.mysql.com
i don't think you will get a good performance from your site with access...

Nov 17 '05 #4
no you have to use oledb

download mysql server and mycc or an alternatif to this mysql front ( last
two are gui 's)

then connect using a connection string


"THY" <th*@streamyx.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
mysql got own connection provider ???

"estafford" <estafford your pants @newmancom.com> wrote in message
news:eM****************@TK2MSFTNGP09.phx.gbl...
using OLE DB you can connect using
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"

Yes, there are utilities that will move your Access DB to MySQL, but you

may
want to look here first.
http://www.kitebird.com/articles/acc...ate.html#TOC_5

Ed

"THY" <th*@streamyx.com> wrote in message
news:OA**************@TK2MSFTNGP09.phx.gbl...
I don't know much about mysql ...
how do I connect mysql with ASP.NET ?

and can mysql import access ?

thanks
"Gönen EREN" <ge***@gsu.edu.tr> wrote in message
news:ud**************@TK2MSFTNGP09.phx.gbl...
> yes you can try to make something like this
> using
>
> try{}
> catch{}
>
> but why access?
> access isn't a database server
> you can use for example MySql, it's free
> www.mysql.com
> i don't think you will get a good performance from your site with
access...
>
>



Nov 17 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Andras Gilicz | last post by:
Hi VB fans I'm working on a relatively large project in VB6 with about a dozen forms, including graphs, labels, text boxes, etc. The software itself is actually a flow simulator with more or...
6
by: Kenneth Courville | last post by:
Hello, I'm looking for assistance with the Access object model. I know this is VB, but I'm building an Office Add-using C# directed at Access 2002. I'm literate in VB, so you can reply in VB... I...
4
by: mescano | last post by:
I am currently implementing a singleton pattern for accessing a database. Is it advisable to close the connection to the database at all -- thus leaving it open or should it be closed. If closed,...
2
by: AS | last post by:
Hi, I have a C# windows desktop application that will be used only by one user at a time. The database server (SQL Server 2000) also resides on that machine only. This application has three...
0
by: gm | last post by:
Immediately after generating the Access application from the Source Safe project I get: "-2147467259 Could not use ''; file already in use." If Access database closed and then reopened I get:...
0
by: bazzer | last post by:
hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in...
7
by: stan.kolker | last post by:
HI, I am just trying to open vss: try SourceSafeTypeLib.IVSSDatabase vssDb = new VSSDatabaseClass(); vssDb.Open(@"C:\Program Files\Microsoft Visual...
24
by: dancer | last post by:
Using ASP.net 1.1 and Microsoft Access. I received the following error message. Why? I have closed the Access file. I have another very small access file that opens with no trouble with the...
2
by: user | last post by:
Hello, I simply make some aspx web page to update data in a mdb access database..But when this database is open (not table, juste the mdb in access) with MS Access, i have an error with my asp.net...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.