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.)

Popular Tags

Browse All Tags