Beacon:

If you would have fully read my post then you see that the solution that we are going to is SQL Server! But that will not happen for several months. Along with Client/Server, if you would have fully read then you would understand as well. If you know what Two Tier application is then you should kow what I mean. I do not mean to be a jerk about your reply but please read completely and if you do not understand then ask.

Two Tier applications are applications that have two pieces to them. Normally there's a piece that is on the server, and then the local workstation (the users pc) has the other piece. This is as refered to as Client-Server application. So with MS Access what you would have is this: A data file that has only the table structure and data. The other piece is on the users pc and has the GUI. It also has linked tables from the data file on the server. Also, I never said that Access was client-server.

By the I have found a solution other than SQL Server.