Navigation skips records ? (1 Viewer)

Does your comment count in the case where the record is autonumbered AND has non-zero / non-blank defaults?

Click to expand...

Pat Hartman said:

Jet/ACE are quite unstable on a wireless connection. If you are not using a wired network, you really need to switch to SQL Server ASAP. You will still have problems with the FE becoming disconnected but you are much less likely to have data issues.

Is there criteria that is preventing this?

Be very careful when dirtying a record. You do NOT want to dirty a record before the user does. That means that any code you have that dirties the record needs to go into either the BeforeInsert event (if you only want to do it for new records) or in the on Dirty event (if you want to do it for all records). Code in the form's BeforeUpdate event does not dirty the record since it is already in the save process so this is where you put code that logs changedBy and ChangedDate.

Click to expand...

Im just now weighing up what is going to be less headache, having ethernet cable wired everywhere or moving the backend to sql....

Click to expand...

CJ_London said:

@ahmed: you have never clarified whether users are using the same front end located on the network or they each have their own local copy. If the former, moving the backend to sql will not solve the problem since users sharing the FE will cause corruption in the front end.

If you go the wireless route, use a sql backend for definite (sql server express is free) and each user must have a copy of the FE on their local machine.

If you go the wired route, you can stick with access as a backend but each user must still have a copy of the FE on their local machine.

Click to expand...