Re: Recommendation for database access



Hi,

Yes, it requires PC, but it has not to be dedicated just for it. Now you
store your Access database somewhere and why MSDE cannot be located on same
PC? Of course, it is not the simplest solution and it depends on your if you
would like to go this way or not

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"code3_brent" <code3brent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E63F1CDD-4219-4853-BABE-9C1C019472AD@xxxxxxxxxxxxxxxx
>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: what is MSDE apart from storing document in SQL server
    ... MSDE is the desktop version of SQL. ... > Totally how many ways are there to store and to access the documents ... > Please help me in this regard. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How to create image field?
    ... Image data type will ... > I would like to store some images in an msde table. ... > enterprise manager design table mode and pick image as a field type, ...
    (microsoft.public.sqlserver.msde)
  • Re: Is storing images in sql really that bad now?
    ... It is certainly feasible to store the images in the database ... Andrew J. Kelly SQL MVP ... > from storing photos images in sql2k and msde. ...
    (microsoft.public.sqlserver.server)
  • Re: Question about msde
    ... I would not store BLOBs in the database--even SQL Server ... Standard that has a lot more capacity than MSDE. ... > connect to the internet if there is a way to auto sync the data through ...
    (microsoft.public.sqlserver.msde)
  • Backing up
    ... How do I backup my sharepoint team services website and data, ... MSDE and not sql server to store all the info. ...
    (microsoft.public.sharepoint.teamservices)