Re: merge multiple databases

From: YYZ (notapplicable)
Date: 05/12/04

  • Next message: DIOS: "Re: not check accents" 
    Date: Wed, 12 May 2004 11:01:14 -0500

    "DIOS" <sindizzy.pak@softhome.net> wrote in message
    news:U2ioc.75672$kh4.4353952@attbi_s52...
    > I think i stand corrected. Even though i have the databases opned
    > exclusively and as
    > read-only via a DAO database object, it must recognize this and let me do
    > inserts from
    > the databases using the following SQL

    Yeah, I dont know what's happening behind the scenes. I would theorize that
    possibly because you are reading from the db that is opened by you read only,
    but you aren't using that connection object, then it doesn't mind that someone
    else (even if it's you) has it opened exclusively... It's not trying to CHANGE
    that database, so maybe it doesn't care.

    I guess you could check this by trying to open up another connection in a
    different app to that database, non-exclusive and read only...

    Don't know.

    Matt

  • Next message: DIOS: "Re: not check accents"

    Relevant Pages

    • Re: Too many args when running a stored procedure
      ... Perhaps you have a duplicate definition of "AddAJob" in the master database schema. ... you don't show that you are associating the connection object with ... >> it with the command object. ... >>> @Rate money ...
      (microsoft.public.dotnet.languages.vb)
    • Re: SQLs
      ... the database ... 'Set an active connection to the Connection object using ... 'Create an ADO recordset object ... 'Initialise the strSQL variable with an SQL statement to ...
      (microsoft.public.frontpage.programming)
    • Re: SQLs
      ... Microsoft FrontPage MVP ... || Web Database Development Step by Step .NET Edition ... > 'Set an active connection to the Connection object using ... > 'Create an ADO recordset object ...
      (microsoft.public.frontpage.programming)
    • Re: Returning a closed recordset...
      ... >I have created a connection object to my sqlserver using the following ... > This SQLServer has many databases on it, ... > db is a variable that names the specific database that I wish to query. ... > with oRs ...
      (microsoft.public.vb.database.ado)
    • Re: ASP Newbie question
      ... The name of the database file is Guestbook.mdb. ... 'This creates an instance of an ADO Connection object. ... 'The Open method of the Connection object uses the connection string to ... 'This query will add your data into the database, ...
      (microsoft.public.inetserver.asp.general)
    Loading