Database class for MS Access

  • Thread starter Thread starter Tee
  • Start date Start date
T

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
 
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.
 
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
---------@
 
Just take the class examples you have found for sql server
and replace all the occurances of SQL with OLEDB.
 
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("connectionstring")
conn = New OracleConnection(Strdbcon)
conn.Open ()



4 guys explains it..

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


HTH

Dave
 
Back
Top