Shared users can't see other's records

[Guest]

howdy,
I am using a front end/ back end setup. Each person has their own front end
and share the back end. The problem is that if I enter a record, and my buddy
(just added to the database) enters in one on her computer, we can't see each
other's records unless we shut down Access and restart. All records are being
properly stored into the tables in the Access backend on the network. This
would not be a big deal except when either gets asked to look up a record to
see if it was ran, we will miss something the other ran. Can anyone tell me
what i'm missing?

 

[Joseph Meehan]

howdy,
I am using a front end/ back end setup. Each person has their own
front end and share the back end. The problem is that if I enter a
record, and my buddy (just added to the database) enters in one on
her computer, we can't see each other's records unless we shut down
Access and restart. All records are being properly stored into the
tables in the Access backend on the network. This would not be a big
deal except when either gets asked to look up a record to see if it
was ran, we will miss something the other ran. Can anyone tell me
what i'm missing?

You need to force a "Refresh." You should not need to exit Access.

How are you looking at the data now? Are you using a query, form,
report??

 

[Guest]

I am using a form which uses VBA with SQL/query commands to transfer data
to/from backend. Also, I have tried hiting the Refresh command in the Records
menu. This has not effect upon updating. Or are we needing a requery?

 

[Joseph Meehan]

I am using a form which uses VBA with SQL/query commands to transfer
data to/from backend. Also, I have tried hiting the Refresh command
in the Records menu. This has not effect upon updating. Or are we
needing a requery?

I think you need a requery.