Re: how to get both old and new value for a changed text box



Moving forward...IMO, I would develop 2 versions of your app. 1 for
Access clients and another for SQL Server clients.

Not to fuel any fires, but.... We have all our db I/O go through a
middle tier class. The front end knows nothing of the backend. The
form sends requests for adding and updating records to the middle tier
class and that class knows what db to send things to. I can easily
accomodate ANY db this way, and in fact do. We have a mixture of DB2
(IBM iSeries), Oracle, and SQL Server. I could just as well accomodate
Access if I had to. I also have my audit trail here since all updates
come through this class.

Just my 2 cents.

.



Relevant Pages

  • Re: how to get both old and new value for a changed text box
    ... Access clients and another for SQL Server clients. ... form sends requests for adding and updating records to the middle tier ... accomodate ANY db this way, ...
    (microsoft.public.dotnet.languages.vb)
  • How do I convert datasets?
    ... The business logic needs to reside in a COM+ middle tier. ... for SQL Server: ...
    (borland.public.delphi.database.ado)
  • Re: Speed Improvements With SQL Server?
    ... the configuration for Access clients currently recommended by the Access ... Can anybody speculate on why? ... On the several apps where I was forced to stay with ODBC against ... tables migrated to SQL Server, response time went right down the ...
    (comp.databases.ms-access)
  • Re: Balancing security needs in ADO.NET applications
    ... Create Views that return focused subsets of the tables as needed by the applications, but do not grant "write" access. ... Hitchhiker's Guide to Visual Studio and SQL Server ... It's simple enough to give the user logon credentials on ... Or maybe write a "middle tier" that alone interacts with the SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: distributed transaction problem
    ... > Could you give us some more details about your middle tier code? ... > connecting to SQL with enlist=true in the SQL Connection String or are you ... >> server to a SQL Server. ...
    (microsoft.public.dotnet.framework.component_services)