Several Users---One Database

[JWeaver]

We have several people who enter information into a database. I have to go
in and add information to these records. If I have a Form open and someone
adds a new record, I have to exit out of the Form and then open it back up
again to see the new record.

Is this the best way for our database to work or is there a better way?

 

[KARL DEWEY]

You could add a refresh button to your form.

 

[John W. Vinson]

We have several people who enter information into a database. I have to go
in and add information to these records. If I have a Form open and someone
adds a new record, I have to exit out of the Form and then open it back up
again to see the new record.

Is this the best way for our database to work or is there a better way?

You can hit F9 to requery the form and see the currently added records. BUT...
It's not required, but it's REALLY recommended that you split your database
into a "backend" containing the tables (stored on a shared drive), and a
"frontend" containing links to the tables and all the forms, reports, etc. Use
Tools... Database Utilities... Database Splitter Wizard, and distribute a copy
of the frontend (the database with the original name, the wizard will create a
backend with a _BE appended to its name) to each user.

See http://www.granite.ab.ca/access/splitapp.htm for details.

 

[a a r o n _ k e m p f]

if you just moved to SQL Server, it would probably work-- just as you
expected-- rigth out of the box

-Aaron