Newbe Question



I'm starting a new project for a local company and need to be sure I'm
heading in the right direction coming out of the blocks. There will be 10
users, all in house, with light pounding on the backend.
The last major project used VB5 and DAO 3.51 hooked up to an Access 97
database. It was in use at about 100 locations around the country. We
experienced corruption of the database if the location had a flakey network
or bad power conditions. The database was always repairable, but I would
like to use something a little more forgiving if possible.
Is ADO the newest technology for an in house application?
Has MSDE proved to be stable and a decent platform?
Are there third party tools for working with the raw MSDE data, like Access
does?
(I've never used MSDE)
Would I be better off using an Access 2000 database as a backend?
Thanks for any suggestions in this area.
Rich
.



Relevant Pages

  • Re: Data corruption with SQL server installed
    ... I noticed that the rogue Primary key that appeareed with the .AddNew method ... The installation of MSDE comes after the installation of MDAC 2.8, ... you could create an empty database and import everything into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Connect to Access Data from various regional locations
    ... Backend and use MSDE as the BE instead of Access. ... There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Access Data from various regional locations
    ... Backend and use MSDE as the BE instead of Access. ... There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)