Several Users---One Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JWeaver - 30 Jun 2008 21:41 GMT

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?

Signature

JWeaver

Reply to this Message

KARL DEWEY - 30 Jun 2008 21:58 GMT

You could add a refresh button to your form.

Signature

KARL DEWEY
Build a little - Test a little

> 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?

Reply to this Message

John W. Vinson - 01 Jul 2008 01:34 GMT

>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.

Signature

John W. Vinson [MVP]

Reply to this Message

a a r o n _ k e m p f - 02 Jul 2008 07:13 GMT

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

-Aaron

> 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
[quoted text clipped - 4 lines]
> --
> JWeaver

Reply to this Message