Can Front End and Back End be on one computer?

[Bob W]

We have 2 computers, each running Access 2007 on Windows Vista OS. Computer
A and B both have an Access Front End in a local folder and the Back End is
in a different folder on computer A.

The program runs fine from each computer if run alone. The problem is
computer B locks up if computer A has a bound form open at the same time
computer B attempts to open the program. Default open mode on both computers
is set to Shared and default record locking is set to Edited Record.

Is this due to the fact that Front End and Back End are on the same computer
or am I missing something else here? I would like to keep this split into FE
and BE if possible but we really can't afford a 3rd computer just to hold the
tables.

 

[boblarson]

It is fine to have the backend on one computer and then a frontend on each
users computer. Your users should have READ, WRITE, DELETE security access
for the applicable folder.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________