Dunno. But I have an update.

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #147,081 by acagle 3/19/04 1:32:06 PM Reply	Dunno. But I have an update. The .ldb file is not being deleted when she closes. ANd she got this message from a tech support person: "I have looked into your in accordance with the log database files it is telling me that you are not closing your record set and connection object. Please review this code this is where the problem lies." Something is not closing the ODBC connection apparently. That doesn't explain the lack of ability to add records though.
Post #147,091 by ChrisR 3/19/04 3:31:15 PM Reply	Depends on the kind of a lock Some transactions require the whole table to be locked for update. That is, you don't want to have the set change on you in the middle of the read - unless you want dirty reads.
Post #147,115 by FuManChu 3/19/04 5:02:59 PM Reply	That 'something' is the developer. Explicitly close connections instead of letting them just fall out of scope. Goes double when errors are raised.

Damsel in distress! - (acagle) - (11) - March 19, 2004, 01:02:38 PM EST

I assume a repair has been done? - (ChrisR) - (3) - March 19, 2004, 01:07:41 PM EST

Dunno. But I have an update. - (acagle) - (2) - March 19, 2004, 01:32:06 PM EST

Depends on the kind of a lock - (ChrisR) - March 19, 2004, 03:31:15 PM EST

That 'something' is the developer. - (FuManChu) - March 19, 2004, 05:02:59 PM EST

Need more detail - (JayMehaffey) - (4) - March 19, 2004, 01:36:11 PM EST

That'd be my guess and GACK. - (mmoffitt) - (2) - March 19, 2004, 01:47:04 PM EST

You'd be suprised - (JayMehaffey) - (1) - March 19, 2004, 03:38:04 PM EST

I've seen some of the very same stuff. - (mmoffitt) - March 19, 2004, 04:42:48 PM EST

Re: Need more detail - (acagle) - March 19, 2004, 02:01:43 PM EST

Does filesystem say .mdb file is writeable for all users? -NT - (bbronson) - March 19, 2004, 06:06:57 PM EST

Re: Damsel in distress! - (qstephens) - April 9, 2004, 02:36:07 PM EDT

If you're going to be paranoid, don't stop at half measures.
40 ms