Re: Simple Database

From: Craig (chester_at_theantons.co.za)
Date: 05/21/04

  • Next message: Jeremy Collins: "Re: Simple Database" 
    Date: Fri, 21 May 2004 11:11:10 +0100

    Thanks people.

    I think ADO is the way to go then, with an Access database.

    Great!
    "Jeremy Collins" <jd.collins@ntlworld-not.com> wrote in message
    news:IVjrc.4$XG2.1@newsfe6-win...
    > Maarten Wiltink wrote:
    >
    > > At work, we do full SQL queries on Access (through DAO). Or perhaps
    > > MSDE, the desktop's SQL Server?
    >
    > I'd recommend Access too.
    >
    > A couple if comments here: DAO is now superceded by ADO,
    > and MSDE is as much of a memory hog as a full SQL Server
    > installation (it *is* SQL Server, without the GUI tools
    > and limited client connectivity).
    >
    >
    >
    > --
    > jc
    >
    > Remove the -not from email

  • Next message: Jeremy Collins: "Re: Simple Database"

    Relevant Pages

    • Transmitting/Receiving Data via MS Access/ADO
      ... Can someone give me a brief primer on data encrytion/security when ... transmitting data between SQL Server and an MS Access database via ADO. ...
      (microsoft.public.sqlserver.security)
    • Re: how to attach Access database to MSDE
      ... You can not attach a Access database to SQL Server MSDE. ...
      (microsoft.public.sqlserver.msde)
    • Re: SOMEONE PLEASE ANSWER. NEED ADVICE. Was: Is MSDE what I need?
      ... I would use ADO no matter what the back end to be honest. ... And the answer depends on how many people are going to be connected, MSDE is ... I suggest if you are just getting started with SQL Server that you buy the ... developer edition for $50 as it will make working with MSDE and SQL Server a ...
      (microsoft.public.sqlserver.msde)
    • Re: Connection between MDB and SQL Server
      ... According to your code,table2 is on Access database but I ... don't need to specify that it is Access table. ... How can ADO judge this is not a SQL table but Access ... >> data from Access into the table on SQL Server. ...
      (microsoft.public.access.modulesdaovba)
    • Re: cant upsize from access to MSDE 2000 (urgentish :p)
      ... > Having a problem with MSDE. ... I'm trying to upsize an Access database to ... > line - if I don't, the installation just seems to die half way through. ... Andrea Montanari (Microsoft MVP - SQL Server) ...
      (microsoft.public.sqlserver.msde)