Re: Newbe Question

Microsoft and many of us recommend that new designs not include Access/JET
databases. MSDE is being upgraded to SQL Express this fall. It's going to be
far easier for you and safer for your customers to use. Data stability,
backups, scalability and performance make the use of SQL Express a given.
Stable betas are available now for download. If I were you and wanted to
keep my skills up to date, learn how to deploy SQL Express. It's far easier
to use now that the deployment issues associated with MSDE have been
addressed.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"RichG" <RichG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E91E7356-E677-4928-962F-F0EF45E86A64@xxxxxxxxxxxxxxxx
> 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: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • RE: SBS NTBackup VSS Errors
    ... your SQL is 2000 edition and you can perform the steps. ... the steps on their database before you perform them. ... Microsoft CSS Online Newsgroup Support ... | Thread-Topic: SBS NTBackup VSS Errors ...
    (microsoft.public.windows.server.sbs)
  • RE: Linking to an SQL Database
    ... workaround you can implement the following code after linking your ODBC ... | Subject: RE: Linking to an SQL Database ... Produced By Microsoft MimeOLE V5.50.4910.0300 ...
    (microsoft.public.access.externaldata)
  • Re: Prevent Viewing on worksheet
    ... and run MSDE as a server. ... been on the market for what.. ... MSDE changed the friggin database market... ... i really reccomend using sql authentication.. ...
    (microsoft.public.excel)
  • Re: Get all stored procedures
    ... For SQLSERVER, we can use the following SQL statement to query the SP ... objects of a certain database: ... Microsoft Online Support ... | Thread-Topic: Get all stored procedures ...
    (microsoft.public.dotnet.framework.adonet)