Access newbi here

[Kroghr]

I have a database with a table named TblAcftLog. The table has on field named logdate

I have a form with the RecordSet of TblAcftLog.

When I enter a date on the form in the logdate field abot 10 subforms are synced to allow me to enter unrleated to each other data in datasheet format.

This has been working fine for me for a year, but if two people update the databse at the same time it creates tow records in the TblAcftLog table which screws up some reports/querys that i run also based on the date entered in the logdate field.

Does anyone have any ideas how to better structure my databse? My goal is to have mulitiple users (3)

 

[Vassago]

Anytime you have multiple people using a single database, you must have a front end/back end setup. This is a must. The back end will store the data and the front end will use linked tables for the stored/shared data. This avoids a lot of problems with multiple users.