Multiple connections with commits

[Daniel Knueven]

I've got 2 forms in the same application looking at the same table. Each form
has its own connection and is preforming commits and rollbacks. When one form
commits its connection, I want the other form to update itself. The problem
is, the commited data doesn't show up in the other form when it is refreshed.
The first form commits its data, then calls a method in the other form to
refresh its view. I have to hit the commit button twice to make the data show
up. I'm working against an access database. When I switch it to a SQL
database the problem goes away. Any ideas?

Thanks in advance.
-Daniel