Form Data not showing in Table

[disneygoof via AccessMonster.com]

Greetings All...HELP HELP HELP

I am having a very sporadic problem and not mater what I try it keeps coming
back. First I will set the stage…
1. Front end/back end database (each person has the front end locally, linked
to the server where all the tables reside).
2. This form I am referring to is a project time tracker interface.
3. There are 12-14 people accessing it at anytime, clocking in and out of
projects.
4. Been using this for over 1 year...and having this same sporatic issue
5. Office 2003, SP3

Problem: Every once in a while the form captures system time and current date,
the data does not show up in the table for a person…could be anyone. When
this happens anyone trying to “clock in†after that, get a “locked†error
message and the table added blank rows.

Tried: I have added many me.refresh, if me.dirty statements and even tried
me.repaint. I can go weeks or even months with no issues then all of a
sudden three or four days of this mess. And its does not matter which record,
sometimes it’s the first person, the 10th person the 4th person…no trend. I
am looking to use this for payroll and job cost, but I can if this continues…

A Solution: If I close the form and open it, the data is written, then we can
move on. But the people accessing the form do not anways close the form, not
do they or show they need to. So this is not a solution I an looking for....
HELP!!!!!

Current code: I just keep adding crap, with no result…I tried all these in
many different locations throught the code...but maybe there's a combination
I did not try...

Sub begin
Me.lblProcess.Caption = "Capture START Date and Time"
Pause 300
Me.StartDate = Date
Me.Refresh
Me.StartTime = time
Me.Refresh
If Me.Form.Dirty = True Then Me.Form.Dirty = False
Me.lblProcess.Caption = "Setting Buttons Status and Locking Detailing
Options"
Pause 300
Me.btnStopTrack.Visible = True
Me.btnStopTrack.SetFocus
Me.btnStartTrack.Visible = False
Me.Frame25.Locked = True
Me.lblProcess.Caption = "Tracking Time"

Me.Refresh
If Me.Form.Dirty = True Then Me.Form.Dirty = False
Me.Refresh
Pause 100
Me.Refresh
Me.Repaint
If Me.Form.Dirty = True Then Me.Form.Dirty = False
Sub End

Could this be a Microsoft Update issue? Is there some other code to ensure
the data is written to the table?

 

[Jerry Whittle]

Do all users have Read, Write, Create, Delete privileges to both the BE
database file and the folder that holds the file?

 

[disneygoof via AccessMonster.com]

Yes they do

Do all users have Read, Write, Create, Delete privileges to both the BE
database file and the folder that holds the file?

Greetings All...HELP HELP HELP

[quoted text clipped - 56 lines]

Could this be a Microsoft Update issue? Is there some other code to ensure
the data is written to the table?

 

[Jerry Whittle]

That was my best WAG. I'd worry about network connections next. Has the
database ever become corrupted? That could also be a symptom of a network
problem.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Yes they do

Do all users have Read, Write, Create, Delete privileges to both the BE
database file and the folder that holds the file?

Greetings All...HELP HELP HELP

[quoted text clipped - 56 lines]

Could this be a Microsoft Update issue? Is there some other code to ensure
the data is written to the table?

--
David (Disneygoof)




.

 

[disneygoof via AccessMonster.com]

Never. Infact so far today I had one instance. Yesterday it happened on/off
all day...

Ya Iam perplexed also...My last resort is to make the table local to each
front end, instead of linking it to the back end and then use SQL to move the
data to a destination table on the backend...???

That was my best WAG. I'd worry about network connections next. Has the
database ever become corrupted? That could also be a symptom of a network
problem.

Yes they do

[quoted text clipped - 5 lines]