Database class for MS Access

[Tee]

Hi, can anyone show me a sample database class that suitable for MS Access ?
I can't find it over the internet, what I found is only SQL, which is not
what I want.

Anyone have any ?
Thanks,
Tee

[Shankar]

Hi -

Use the OleDB classes with namespace System.Data.Oledb.

Shankar

Hi, can anyone show me a sample database class that suitable for MS Access ?
I can't find it over the internet, what I found is only SQL, which is not
what I want. Anyone have any ? Thanks, Tee

[Tee]

No, I don't meant this. Perhaps you can't understand what I am trying to
ask.
I need a database class that suitable for Access, and then my web
application will use that class to access database.
And maybe in the future, when the database is upgraded to SQL, then I just
modify the class instead of update every page to change all Oledb to SQL.
Anyone have such class can share ?
Thanks.


"Shankar" <js*****@hotmail.com> wrote in message
news:OW**************@TK2MSFTNGP12.phx.gbl...

Hi -

Use the OleDB classes with namespace System.Data.Oledb.

Shankar

Hi, can anyone show me a sample database class that suitable for MS

Access ?

I can't find it over the internet, what I found is only SQL, which

is not

what I want.

Anyone have any ?

Thanks,

Tee

[Brian Lowe]

You're asking for a complete middle tier for your n-tier application
tailored to your Access database. Don't expect anyone to provide it for
free. You also seem to expect someone to provide a SQL oriented middle tier,
also for free, at some time in the future.

Let me know if you find someone willing to do all that for you. I have loads
of work I'd like someone else to do without having to pay them.

Bran Lowe
---------@

"Tee" <th*@streamyx.com> wrote in message
news:OI**************@TK2MSFTNGP11.phx.gbl...

No, I don't meant this. Perhaps you can't understand what I am trying to
ask.
I need a database class that suitable for Access, and then my web
application will use that class to access database.
And maybe in the future, when the database is upgraded to SQL, then I just
modify the class instead of update every page to change all Oledb to SQL.
Anyone have such class can share ?
Thanks.


"Shankar" <js*****@hotmail.com> wrote in message
news:OW**************@TK2MSFTNGP12.phx.gbl...

Hi -

Use the OleDB classes with namespace System.Data.Oledb.

Shankar

Hi, can anyone show me a sample database class that suitable for MS

Access ?

I can't find it over the internet, what I found is only SQL, which

is not

what I want.

Anyone have any ?

Thanks,

Tee

Just take the class examples you have found for sql server
and replace all the occurances of SQL with OLEDB.

[dave]

Tee,

Just store your connection string in the web config file.. then you
only have to change 1 line to update entire application..
<appSettings>
<add key="connString" value="data source=localhost;initial
catalog=Navigation;integrated security=SSPI;persist security
info=False;workstation id=DRDAVE;" />
<add key="connectionstring"
value="User Id=dave;Password=slappy;
Data Source=oogly_boogly" />
</appSettings>
then in your code something like:

Dim Strdbcon As String

Strdbcon=ConfigurationSettings.AppSettings("connec tionstring")
conn = New OracleConnection(Strdbcon)
conn.Open ()

4 guys explains it..

http://aspnet.4guysfromrolla.com/articles/053102-1.aspx
HTH

Dave

"Tee" <th*@streamyx.com> wrote in message news:<OI**************@TK2MSFTNGP11.phx.gbl>...

No, I don't meant this. Perhaps you can't understand what I am trying to
ask.
I need a database class that suitable for Access, and then my web
application will use that class to access database.
And maybe in the future, when the database is upgraded to SQL, then I just
modify the class instead of update every page to change all Oledb to SQL.
Anyone have such class can share ?
Thanks.


"Shankar" <js*****@hotmail.com> wrote in message
news:OW**************@TK2MSFTNGP12.phx.gbl...

Hi -

Use the OleDB classes with namespace System.Data.Oledb.

Shankar

Hi, can anyone show me a sample database class that suitable for MS

Access ?

I can't find it over the internet, what I found is only SQL, which

is not

what I want. Anyone have any ? Thanks, Tee