«

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

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,...

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" <> wrote in message
news:...
> 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,...
>
>

I don't know much about mysql ...
how do I connect mysql with ASP.NET ?

and can mysql import access ?

thanks


"Gönen EREN" <> wrote in message
news:...
> 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...
>
>

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" <> wrote in message
news:%...
> mysql got own connection provider ???
>
>
>
> "estafford" <estafford your pants @newmancom.com> wrote in message
> news:eM%...
> > 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" <> wrote in message
> > news:...
> > > I don't know much about mysql ...
> > > how do I connect mysql with ASP.NET ?
> > >
> > > and can mysql import access ?
> > >
> > > thanks
> > >
> > >
> > > "Gönen EREN" <> wrote in message
> > > news:...
> > > > 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...
> > > >
> > > >
> > >
> > >
> >
> >
>
>