Networking Glitch

[JPW]

I have a split database. I hope I can explain this well....

I have a network mapped drive on all computers (win xp pro) of G:\ I have obviously a front end that was created when it was split.

I keep that fornt end file in same folder of the backend side of things, and I simply copy that exact tile (the front end) and place it on to the desktops of the workstation PC's and my database seemed to work, obviously I do rename the front end file on all PC's to Workstation 1, Workstation 2 and so on.

The front ends on workstations all do connect to the backend and the data does appear in the front ends and new records can be added and edited.

However I have a few issues:

1) If Workstation 1 was editing record 1 and workstation 2 was on another record say '232' and workstation 2 wanted to view the changes made to record 1 then he/she would have to wait till the the user edits the edited record and wait 5 seconds to see any changes. It would appear there is a slight delay in seeing the updated data.

2) If for example the user on workstation 1 adds a new record then it does update it in the table on the backend no problem at all, but it doesn't appear in the other front end databases form until the users exit the form and go back into it - it doesn't update live.

Is there a soloution to this.

 

[pbaldy]

For starters, I'd recommend linking using a UNC path (\\servername\sharename\filename.mdb) instead of a mapped drive, so you don't have trouble if someone's PC isn't mapped properly. I've not seen the delay in viewing edited data. The new record problem can be solved by requerying the form. The code would look like:

Me.Requery

Where to put it depends on the specifics of your situation, but candidates include the timer event, a button to manually do it, or the form's after update event.

 

[JPW]

I need abit more assistance.

I've tried that and so far not working.

I need the form on workstation 2 for example to update when another user on another workstation adds a new record to the form. At the moment the user has to exit the form and go back into it.

The name of my form is Details.

When a new record is created the user has to enter a Job Number such as 7689, then on a new record after that 7690 and so on..Then the user fills in some fields and check boxes.

I have put on my form a few macro buttons for navigation and adding a new record.

I would prefer an option either all the forms refresh themselves ever few seconds or something.

Hope that's clear.

 

[pbaldy]

What is "not working"? I gave you the code and 2 places to put it. If you want it to requery every few seconds, then the timer event is the place. The person on the other workstation isn't adding records to the form, they're adding them to the underlying table. Therefore the first workstation has to requery their form to see new records in that table (which is what happens when you close and reopen the form).

 

[JPW]

I have this in the form's after update

Private Sub Form_AfterUpdate()

Me.Requery

End Sub

I put that code in and still the same problem.

I still have to exit the form and then go back into it to see any new records that have been added to the underlying table. However, I have no problem with viewing current records that get edited - those get displayed on all workstations when they get browsed.

The record selectors at the bottom tell you how many records they have.

For example, say if my database holds 500 records and workstation adds a record and fills in the form then that will take the database to 501 records, but on workstation 2, it will show on 500 records till I exit that form and go back into it then it is updated.

I'm sorry for being anoying, it's just a problem that's proving frustrating.

 

[David Eagar]

Is it the network not performing rather than Access?

 

[JPW]

Is it the network not performing rather than Access?

No, because I've just come home and tried it at home and not working.

If I posted the database (or just a striped down version without queries/reports and just the table and forms) would you or someone have a quick look at it, if possible?

 

[pbaldy]

Sure, post a sample. The Requery should find any new records added. You realize that only runs when you add/change a record where you have it?

 

[JPW]

Here it is...

I have removed some forms and many reports and a few queries to reduce file size to arond 320kb.

Thank you for your help, time and patience.

http://rapidshare.com/files/101018731/TestDatabase.MDB.mdb.html