Question Locked

Access Database on Server HELP!!!!

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi!

My employer is needing help trying to figure out if it will be beneficial for him to purchase a server or not. Hopefully someone can help us! We have a simple Access Database with forms and reports that we want to share with all of our other facility locations for those people to be able to view,add,& modify their information. We want to purchase the Windows Small Business Server 2003 and put the database on there. The only question we have is will everyone who needs to use the database in the other locations have to have MS Access installed on their computers?

3 replies

by tony hopkinson

You can get a toolkit to deploy an access application as an executable to clients without access installed.
http://support.microsoft.com/kb/842004

Personally I'd put access in a couple of these other locations (preferably the most problematic) and share the file where it is.

Give it a good hammering. Access is notoriously crap at scaling. If there's not many users and they aren't going to trample on each other in terms of locks etc, you might get away with it.

Also have you thought about exclusive access for maintenance functions and how you are going to deal with them.

by dryflies

There are a couple of ways you can go about this but neither one will leave your database application in the same form it is now. The first method is to do a frontend/backend split where you divorce the forms and reports from the underlying data. access has a tool to help you with this task. as for the prognosis for doing this, I haven't tried it.
The second way is to use replication. Acces has a tool for doing this as well. Put the master on a share that everyone can see and then create a replica for each user. Each user, after performing work on the DB must then synchronize the replica to the master. if they use the replica throughout the day, they should sunch periodically. I have had a few issues where changes do not take when performed on a replica and the master must be used. short of putting the application on sql server or some other "professional grade" db those are the two best options. Now, if there is a single point of data entry you can create data access pages so the rest of the workforce can view the database. hope this helps!

This discussion is closed to new replies.