By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,795 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,795 IT Pros & Developers. It's quick & easy.

Database class for MS Access

P: n/a
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
Nov 18 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 18 '05 #2

P: n/a
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

Nov 18 '05 #3

P: n/a
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


Nov 18 '05 #4

P: n/a
Just take the class examples you have found for sql server
and replace all the occurances of SQL with OLEDB.
Nov 18 '05 #5

P: n/a
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

Nov 18 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.