My company has a small Access database on our server that needs to be accessible by multiple users (10-15) on the network. Since most of the workstations do not currently have Access installed, the database can only be accessed by the few stations that do have it installed.
Is there any way to run Access or access the database from a workstation that does NOT have MS Access installed? I was told that a similar situation was achieved through using a Sharepoint portal on the server and accessing the database through that, but I am skeptical of that solution.
The workstations need to be able to access the database and add records to the database via forms that have been configured. Additionally, the database was designed with Access 2003.
The workstations are configured with XP Pro and the server is running MS Windows Server 2003 with Sharepoint installed.
We are trying to avoid purchasing 10+ MS Access licenses from MS at $200 per license. Please let me know if there is such a way.
Thanks,
Paul