Database Engine and Jet SQL

[Brogrim]

I have an access file on a network, I want 2 users to be able to update the records at the same time.

I have made the folder that the file is in writeable. This allows me to open the file on both machines. When I change record on 1 machine it is not reflected on the other machine. Does the file need to be constantly refreshed.

I cannot use a Front and back end as I am only usinf File Sharing.

Please help I am cracking up with this.

 

[dhookom]

Only using file sharing" doesn't keep you from setting up front and back end mdbs.

Changes in records on an open form won't be seen unless the form is refreshed or requeried. User 1 won't see changes made by User 2 if they both have a form open with the same basic record source. Refreshing should show changes to records and a Requery will display new records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Brogrim]

Thanks

How can I force teh file to keep refreshing

Thanks alot, I am very inexperienced a this

 

[dhookom]

If you are using the same "file", it is always "refreshed". How about you describe your setup and what you are experiencing as symptoms?

Are there forms involved?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]