StudioWorks was originally designed to operate on one computer only so:

When using StudioWorks over a network, the copy on the file server should be run as a local connection.
(Don't click the Remote Connection checkbox)

If more than one user is entering data, the system operates on a first come first saved basis.

If more than one user has the same screen opened, changes made by the other user will not be seen until the
screen is closed and re-opened.

To allow network connections, follow these steps:

Since Microsoft has to be more concerned with security issues than user friendliness, the SQL Express install defaults to operating with local data only. If you need to access the data over a network from more than one computer, there are quite a few necessary steps to follow. Otherwise, click OK at the logon, and you’re good to go.

1.	Install StudioWorks on your file server.
2.	Install SQL Server Management Studio Express.
3.	Restart the file server. (The SQL Server Manager won’t work properly without a restart.)
4.	There should be a new folder on the Start Menu called “Microsoft SQL Server 2005”. Under this, go to Configuration Tools and click on SQL Server Configuration Manager.
5.	Click on SQL Server 2005 Services. (on the left)
6.	Double Click on SQL Server Browser. (on the right)
7.	Click the Service tab and set the Start Mode to Automatic.
8.	Click OK.
9.	Set the Start Mode of Sql Server (SQLEXPRESS) to Automatic also.
10.	Click on SQL Server 2005 Network Configuration. (on the left)
11.	Double Click Protocols for SQL Express.
12.	Double Click TCP/IP.
13.	Set Enabled to “Yes”.
14.	Click OK.
15.	Exit the Configuration Manager.
16.	The Windows Firewall will block access to the data across the network by default. To allow data access over the network, navigate to the Security Center from your Control Panel.
17.	Open the Security Center and click on Windows Firewall.
18.	Click the Exceptions tab.
19.	Click the Add Program button and then the Browse button.
20.	Browse to C:\Program Files\Microsoft SQL Server\90\Shared
21.	Double Click on sqlbrowser.exe
22.	Click OK and follow the procedure to add another program, but browse to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn and Double Click on sqlservr.exe. Click OK.
23.	 Now click the Add Port button.
24.	Name the port STUDIOWORKSPORT.
25.	Enter 1434 as the port number.
26.	Click the UDP button and then OK.
27.	Click OK to exit and then close the Security Center.
28.	 Under the Microsoft SQL Server 2005 Start Menu, click on SQL Server Management Studio Express.
29.	Connect using Windows Authentication.
30.	Right Click on the Server (at the top on the left) and select Properties.
31.	Click on Security.
32.	Select the SQL Server and Windows Authentication mode.
33.	Click OK and OK again in the message telling you that the server will need to be restarted.
34.	Right Click on the Server again and choose Restart. Answer Yes.
35.	Click New Query on the upper left.
36.	The default administrator (sa) must be enabled. In the window that opens, type the following replacing PWD with a password of your choosing. Be sure to enclose your password in single quotes.

ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = ‘PWD’ ;
GO

37.	You will now be able to access the database remotely with the user name sa.
38.	If you want to add other users, click + next to Security, right click on Logins and select New Login.
39.	Select Sql Server Authentication and enter a name and password for the user. Uncheck ‘Enforce Password Expiration’ and ‘User Must Change Password at next login’. Keep ‘Enforce Password Policy’ checked.
40.	Click Server Roles on the left. Select sysadmin and click OK.
41.	Install StudioWorks on the other computers on your network.
42.	Change the firewall settings on each workstation as described above.
43.	When running StudioWorks on a workstation other than the file server, select Remote Connection in the logon screen. Enter your user name, password and select the file server from the dropdown. (It will be prefixed with the File Server’s name, followed by \SQLEXPRESS) Next select the database. (It defaults to being called C:\Program Files\M&M Studio\StudioWorks.mdf)
44.	All the workstations will now access the same data on the file server. If Remote Connection is not selected, the program will point to a unique local copy of the database.