Re: Recommendation for database access

I never thought of using MSDE, since it has fairly small data requirements.
It's not a data-intensive application, just stores information on users, etc.
in a few tables for retrieval only. And from what I can find, MSDE still
needs some machine to be a "server", correct?

"Val Mazur (MVP)" wrote:

> Hi,
>
> I do not think using ADO.NET will help. I would try to switch to MSDE
> database from Access. First of all it is more stable. Also it is more
> scalable and has much more functionality. Of course it depends on if you
> could do this or not.
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
.

Relevant Pages

  • Re: Changing the location of MSDE
    ... > site setting, it could be quite difficult to edit the site settings). ... > Microsoft MVP - SharePoint Portal Server ... >> I have installed SharePoint Portal Server and MSDE. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Attach DB > 2 GB
    ... Microsoft MVP ... > MSDE Manager SQL Tools ... >> databases can't be created or expanded past 2GB. ...
    (microsoft.public.sqlserver.msde)
  • Re: Where are the documents stored
    ... Microsoft MVP - SharePoint Portal Server ... The standard MSDE itself does have a 2GB limit, ... >> Microsoft MVP - SharePoint Portal Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Row cannot be located for updating... error.
    ... > procedures that have a table with a self join on a foreign key that get ... > "Val Mazur" wrote: ... >>> MSDE Database ... >>> self join is the common thread. ...
    (microsoft.public.data.ado)
  • Re: SQL OLEDB Unreliable
    ... What is your connection string to MSDE? ... Val Mazur ... "Mark" wrote in message ...
    (microsoft.public.data.ado)