Question access file in use problem

[E_Gold]

I have an Access 2007 database file that should be used by two programs simultaneously.

Program 1 should insert and update the table;
Program 2 should only run queries to show the data.

The problem is, when program 2 opens the file - program 1 cannot insert or update rows.

What can I do?

 

[Galaxiom]

What are the programs you refer to and how are they connecting to the database?