Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is global refresh possible in Access 2007?

Status
Not open for further replies.
MacroScope

MacroScope

Programmer
Jul 17, 2010
286
US
I have an Access 2007 db which has many different forms that are open simultaneously on the stations of different users. We constantly run into locked records because of it.

Is it possible to use the timer to send out a global refresh command to all forms on each user's station, say every minute? That way all records will always be current up to that moment.

I know it can be done for each form, but it would require each form to get the focus once a minute to run the refresh command, which would destroy productivity.

Any assistance would be appreciated.
 
Sort by date Sort by votes
I'm sorry if this sounds like a stupid question, but what do you mean by split?

I'm guessing the answer is no.
 
Upvote 0 Downvote
How are ya MacroScope . . .

[blue]Lilliabeth[/blue] means split into a [blue]FrontEnd[/blue] on all user machines and [blue]BackEnd[/blue] on the server. If its not, your headed for corruption of the DB under the secnario you've described!

[blue]Your Thoughts? . . .[/blue]



See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Upvote 0 Downvote
No, it is not split.

Is it possible to initiate a single command at each user's work station which would refresh that user's forms at regular intervals?
 
Upvote 0 Downvote
MacroScope . . .

Do your user each have their own independent DB or are they accessing a share?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Upvote 0 Downvote
Each is accessing a share. One db on the public drive, each user opening his own instance of Access on his station and accessing the public drive.
 
Upvote 0 Downvote
MacroScope . . .

No No No! I repeat:
TheAceMan1 said:
[blue] ... split into a FrontEnd on all user machines and BackEnd on the server. [purple]If its not, your headed for corruption of the DB under the secnario you've described![/purple][/blue]
Click to expand...

Have a look here Split a database

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
151
Xavierparkash
Xavierparkash
MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
210
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
234
PrimoSteve
PrimoSteve
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
758
JanaLNelson
JanaLNelson
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
263
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top