Disappearing records on split database

[andymartin3186]

Hi,
I have a database that has a split back and front end.
The back end resides on my NAS drive and the front end is an executable which resides locally on 2 computers.
I am having a randomly recurring issue where when I create some records on one PC, they are saved, I add information to them etc without issue.
I then open my laptop, which has been in sleep, with the front end still open. It reports network access interrupted and I close it and reopen it.
When I reopen it the records I had made on the other PC have gone, and when I check the back end it is in an inconsistent state, I repair it, but the records do not come back and I have to manually create them again.

Can anyone see anything obvious here with what I am doing wrong? Is the database somehow locked by the laptop before sleep and the PC is adding records but because of the lock they aren't saved? If so why doesnt it notify me?

Is the solution to prevent sleep when lid closed?
Is there a setting I can change to stop this? Its not all the time but is frustrating.

 

[RonPaii]

Unless the NAS is Windows based, the BE will be unstable on a SAMBA emulator. Move it to a Windows Share.

 

[tvanstiphout]

It is a best practice to close applications when you're not using them anymore.
You can even write code to do this automatically for you after a certain amount of idle time.

 

[Minty]

Apart form the advice above, in your Laptop Power settings you can control what it does when the lid is closed.
Sleep or Hibernate are both bad, as one of the first things that happens is it turns off the network connections to save power.
That will leave connections hanging, or the file in a unstable/unknown condition.