Search results

I have an Access97 DB which does not use security. Through code, is there a way to force users out of the app?

Ok, thanks Len. 'I'm buying the beer'

Mile-O-Phile This also gets rid of those annoying 'end of recordset' messages. When I grow up, I wanna be just like you :D Thanks a heap.

Thanks all. Yes, I can't actually 'grab' the users name using access97 and NT :confused: My workaround is courtesy our NT Team: A txt file populated with the name, computer name etc. is appended to each time someone logs on to the network. In my access app, I can look at the .LDB file to...

I have two forms: One form is for adding a record, the other for editing an existing record. I have some custom buttons for navigation on the form used for editing. When navigating to the end of the recordset in the editing form, the user is presented with a blank form (as in ADD mode). I...

Hi John Repaired the BE and now running with the backup version of the FE MDE and all looks good. Cheers Carl

Thanks for the reply :) Is there a chance that with Optimistic locking, two users updating the same object can cause DB corruption? Oh, and how does one turn off Optimistic locking? Can't seem to find anything in Access97 with any reference to this.

What is 'Optimistic record locking'? Can't find anything in the access97 help (even though it is referenced in an error). Can someone explain what it is, and how to control it (ie. can it be turned on/off)? Thanks

We are using a split database (access97). Both the backend(MDB) and frontend(MDE) reside on the network. We are experiencing corruption on a daily basis. Some records are ending up #ERROR and some #DELETE This requires a repair of the backend which rebuilds the index ok but now if you try to...

Hehe, beginning to have fun... Tried that but I do have a Close button running a DoCmd.Close of the form. This has a conflict: The error is something like I am trying to issue a DoCmd and Cancel in a dialogue at the same time. Oh, all window close 'x' buttons have been disabled so the only way...

I have a form which is opened in ADD mode. There are three fields (ImpDate, Group, Crit) which the users must complete before they can close the form. We are running with Validation rule set to 'Is Not Null' and having some Validation text prompt the users. Unfortuantely, this is no longer...

Hi Rich Sweet :) Private Sub ClosedDate_AfterUpdate() DoCmd.RunCommand acCmdSave DoCmd.GoToRecord , , acNext Combo141.Requery DoCmd.GoToRecord , , acPrevious End Sub Also do a refresh on the AfterUpdate of the CheckBox, just in case a user decides to uncheck it (this puts the record back in...

Hi Rich Tried that but same result. I'm doing a DoCmd.Save (is this correct?) If I do a Records/Save record from the menu, it works but the record still appears in the ComboBox.

On my form, I have an unbound ComboBox with a rowsouce of: SELECT DISTINCTROW [qryOverDue].[ChangeID], [qryOverDue].[ImplementationDate], [qryOverDue].[Group] FROM [qryOverDue]; Also on the form are a CheckBox (Closed) and a TextBox (ClosedDate). The underlying query displays records whose...

Sorted. :) Thanks Rich

Hi I am using a standard access switchboard (Access 97) On my main form I have several custom buttons for navigation, deleting, copying records etc. The first button on the switchboard opens my main form in ADD mode ie. a blank form. The second button opens the same form but in EDIT mode ie...

Thanks everyone. AWF saves my bacon (once again).

Hi Thanks for the reply. My Mum always said I was never really that smart when it came to making myself understood... after 36 and some years, nothing has changed... I can see who has used the DB and what fields they have edited etc. via an audit feature. No probs there. What I am after is a...

I have a shared database. Is there an 'easy' way to monitor who is using the database? Thanks oh, it's Access '97

Same result. Everything still disappears.