Re: DAO 3.51 problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

Sorry, I misunderstood what you were doing. So it's the lock on the back-end that's the problem? That's odd.

I just looked at some old code that does the same thing as yours does, and the only thing I did differently was that I didn't have a password, and I put the SourceTableName before the Connect line. I don't believe either of those would've made a difference, but it's been 7 years since I last used DAO to link tables programmatically, so I'd try both removing the password and changing the order of your code, at least to test and see if either makes any difference.


Rob

"Rick" <Rick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4E7FAE5C-7B64-40DA-A8C2-7E8EDD8C2D3F@xxxxxxxxxxxxxxxx
The linked table is not created on the source file, but locally on a temp file.
So, each user should have his/her own link.


--
Thanks,

Rick.

.

Relevant Pages

  • [RFC][PATCH] a revised job patch (with jobfs)
    ... To Chris Wright: ... > Why not simply lock the table in here? ... And, jobfs_create can fail. ... > This is and odd interface. ...
    (Linux-Kernel)
  • Re: Unable to modify a specific SQL table
    ... I'm sorry, I misunderstood, plus I didn't give you the full list of the ... results from sp_lock where the objectID equals to a non-zero: ... at a time to see where the lock is coming from. ... then kill it using KILL 54. ...
    (microsoft.public.sqlserver.server)
  • Re: Many
    ... misheard, misunderstood, or are misremembering. ... I find it odd that an American, of all people, would thrice accuse ...
    (alt.usage.english)
  • Re: FOR UPDATE cannot be specified on a READ ONLY cursor
    ... Sorry I thing you misunderstood my ... Actually I'm trying Select a record and lock it. ... Using ms sql server jdbc driver I'm getting the following ... >Mohamed Ismail wrote: ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Passing Statement Block as Parameter?
    ... NewOperation? ...  Either I've misunderstood your question or you've misunderstood   ... When invoking lock(), you can invoke it as follows: ... delegates / lambdas, which Peter has shown you how to do. ...
    (microsoft.public.dotnet.languages.csharp)