2007 Microsoft Access Database with SBS 2003 Standard

Here is my question. I recently bought Microsoft Access 2007. My law firm uses just Outlook to store contacts and such, well it makes it a pain to go into different people's contacts. I want to create one big database on my SBS 2003 server. My SQL is already running another program called Softpro, which we use for real estate matters. This program, as well as, our billing program allows you to export the contacts from there and merge them to Access. My question is how do I set up Access to run on my server for everyone to use? I tried to set up a database in ODBC, but for some reason when I try to connect through Access on my workstation, it isn't working...any suggestions?

Solution: 2007 Microsoft Access Database with SBS 2003 Standard

You could use Access as the BE and share the server.

Install the BE in its own folder in the server. The folder should have a short name with no spasms and be one down from the root.

On each user's machine:
Create a mapped drive to the folder the BE is in.
Install the FE.
Use the linked table manager (tools, database utilities, linked table manager) to link the tables to the BE. (Do one FE then copy to other machines.)

Active

Search all fields in MS access table	Migrating Gmail contacts and calendar to exchange
while initializing device VKD-windows protection error- restart- computer shuts down	Problem: Active Directory Domain removal
Raise 2GB limit in Exchange 2007	Add radio buttons to word document
Problem: Restore deleted user account on Windows 2003 Small Business Server	error opening installation log file vista
Access form layout tips	Error message whilst trying to move mailbox from Exchange 2003 to 2007
Problem: how to delete highlighted colored rows?	Fixing - Cannot perform an aggregate function on an expression containing an aggregate
how to change Access 2003 runtime dictionary language "French"	Outlook 2007 keeps asking for password - pop3
Problem: active directory forest trust setup problem?	Problem: Cannot remove inherited permissions in Exchange
Problem: can you upgrade from server 200 to 2003?	Problem: What IIS security hole allows mIRC trojans?
Child domain users and Parent domain Exchange	Problem: No duplicate item in combobox item