Access Syncing on table

[AccessThomas]

I am really new to Access, so I have what may or may not be a simple question.

We are having an annual meeting and we want to use 6 laptops to sign people in by looking them up and putting a checkmark that they showed up. I have the form built and it appears to be working fine, but my question is about syncing. If we have 6 laptops all looking at the same table at the same time, is it possible for this to be real time? So if user 4 checks off Tom Jones, then user 6 sees that Tom Jones is checked.

Thanks for any help.

[ranman256]

1. Only use 1 laptop and project on the screen
2. Put a timer on the form that refreshes every 10 secs.
3. Only have 1 person do the checkin, so the table doesn't lock.

[ItsMe]

It sounds as though you want to Split your Database. This is where Front End files are distributed to the Users and a single Backend file resides on a server where it is shared.

There is a wizard that can help. Under the Database Tools tab, select Access Database to launch the wizard.

Afterwards, you can copy the FE file and distribute to users. The trick is to get the links to tables to use the Universal Naming Convention (UNC). When navigating to where the BE file resides, go through the server via "Entire Network".

\\ServerName\FolderName\Filename.Extension

[AccessThomas]

Yeah, I'm thinking I will have to do a split. Thanks.