Re: Diamond Access

From: Rohit Dhamija (rohit.dhamija_at_teleatlas.com)
Date: 07/13/04

  • Next message: Rohit Dhamija: "Re: Diamond Access" 
    Date: Tue, 13 Jul 2004 09:06:22 +0530

    Thanks, but at the current moment we are not in a position to shift from Access
    to MS SQL 2000, we are in search of a component.
    Rohit

    barry clark wrote:

    > Use MS SQL 2000.
    >
    > Barry
    > "Rohit Dhamija" <rohit.dhamija@teleatlas.com> wrote in message
    > news:40F23DDD.76386AAA@teleatlas.com...
    > >
    > > Currently we are focussed on MS Access 2000 only, so what do you suggest,
    > which
    > > component to use (on basis of performance)
    > > rohit
    > >
    > > Del Murray wrote:
    > >
    > > > If you are that concerned about performance, you should probably be
    > > > considering a real database manager, not Access. The MSDE if you cant
    > afford
    > > > sql server
    > >

  • Next message: Rohit Dhamija: "Re: Diamond Access"

    Relevant Pages

    • Re: Using SQL in Sub to fill box on mouseclick
      ... try the listbox. ... This is because the first " character in your SQL string will ... >> specific shift to show. ...
      (microsoft.public.access.formscoding)
    • Re: New to SQL server
      ... you're arguing that Access DRI is more powerful than SQL DRI ... I think that if you hold down shift then it ignores RI ROFL ... most SQL products have the concept of VIEWs - ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Picking only first record from records - QUITE BIG and COMPLEX
      ... > Machines identified by Query1 whose SQL looks something like this: ... > INNER JOIN ... > This third query would have to assume that the combination of IDN, Shift, ...
      (microsoft.public.access.queries)
    • Re: SQL parameter query not returning values
      ... I changed mt SQL to the following and it seems to be working well. ... FROM Shift INNER JOIN (((Department INNER JOIN Production ON ... ' Define the parameters clause. ...
      (comp.databases.ms-access)
    • Re: form provides and/or params to query
      ... >shift I still get the OR's results included. ... The criteria need parentheses. ... It may be easier to see in SQL view; ... When you go back to the design grid, ...
      (microsoft.public.access.queries)