Is this normal Access behavior?

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

Hi -- I'd appreciate any help you could offer with this!

Scenario: Shared database, FE & BE both located on
server; users have shortcut on desktop pointing to FE on
server

User 1 enters a new record

User 2 cannot see the new record unless shift+F9
(requery) is pressed

Normal Access behavior or is there something I can do to
programmatically refresh the records?

Thanks in advance!
 
When a user starts the FE Application on their local
computer, there is no way for the FE to know that
something has changed in the database. The FE should
refresh when forms are opened, but you don't want to have
to close and reopen forms just to refresh the underlying
recordset. The only thing I can think of is to put an
ontimer event in your form to refresh (or requery) every
so many seconds. You could have a table in the backend
database with one Yes/No field in it. Yes (or -1)
indicates something has changed, No (or 0) means everyting
is the same. Then put a hidden form in the Front End. Have
an ontimer event in the hidden form. Requery the hidden
forms underlying recordset. Then check the value. If it is
set to Yes, re-query the other form. You don't want to put
this ontime event in the data form because you may run
into conflicts with other procedures trying to run on say
an afterupdate event.

One other suggestion I have, you might consider putting
the Front End application on each users computer. You
would have to map the linked tables to a specific drive on
the users computer, but that is not that difficult. You
could also create the ODBC link on the server, but you may
or maynot have the ability to do that.

I hope that helps!

Kevin
 
Thanks, I'll try that. I've considered making the FE
local to user's pc (they have a mapped drive to the dir)
but I didn't think that would do the trick since it seems
like the same scenario still. But hey, you don't know
until you try! My only other question is how do I create
the ODBC link on the server? Can I do this on a Novell
server?

Thanks again!
 
Thanks, I'll try that. I've considered making the FE
local to user's pc (they have a mapped drive to the dir)
but I didn't think that would do the trick since it seems
like the same scenario still. But hey, you don't know
until you try! My only other question is how do I create
the ODBC link on the server? Can I do this on a Novell
server?

Thanks again!
 
Scenario: Shared database, FE & BE both located on
server; users have shortcut on desktop pointing to FE on
server

User 1 enters a new record

User 2 cannot see the new record unless shift+F9
(requery) is pressed

Normal Access behavior or is there something I can do to
programmatically refresh the records?
Click to expand...

This is normal behavior. Avoid using the "On Timer" event to requery the form,
as it will interrupt data entry and leave you at the first record in the form's
recordset after the requery. You could place a "Requery" command button on the
form to allow the user to requery the form to show any added records. The
button's "OnClick" event procedure would consist of the following line of code:

Me.Requery
 
Back
Top