Hi Everyone,

First I apologize if i have this in the wrong catergory. I was given the task of creating a searchable & editable db for multiple users (16-20), who are spread all over the country (User in AZ, User in Fl, User in WA, etc), where there are a few tables with 1M records in each one. What I am trying to figure out is the best way to deploy it, so that it doesn't seem painfully slow for the end user.

I am thinking the best approach would be to use a SQL server. The problem with that.. If the IT group at my company doesn't feel a project warrants SQL server access, they won't grant it, however this a while ago & I have attempted to request access again, just haven't heard anything back yet


Does anybody have ideas of how they deployed their multiple user, tons of records db to multiple users?

Has anybody tried using Sharepoint to host their data? Would that be faster then just having the BE db on the network?

If my only resort is to do the FE on the desktop & BE on the server, are there any tips or tricks to make searching faster (besides indexing the few fields that I would allow the user to search by)

Thanks

Having the backend in either an MDB or ACCDB file and accessing it via the WAN is a sure-fired recipe for disaster!

Take a look at what Albert Kallal has at Using a wan with ms-access? How fast, how far?

I currently use SharePoint to host the tables for a single-user database. Moving tables to SharePoint Tlhe concept is pretty much the same if you have a properly designed table structure and well designed Access FE for multiple users.

However, note that the size of my tables and the type and number of transactions does not tax the system. Your experience may vary quite a bit. I can't really say whether my good results would scale.

Is a VPN solution not on the table for you? That's something you could also consider.

This post has been edited by GroverParkGeorge: Feb 25 2012, 08:11 PM

I should add that we are using Access 2007 & I have access to Sharepoint 2007, which I should be upgraded to Sharepoint 2010 in the next month or so.

I assume when you mention VPN, that you mean a virtual desktop (terminal server) which the user has a "desktop" on a server. If that is what you mean, then yes I know about 1/2 of my group has access & I would need to see if the other half does have access. A while back, I deployed a decent size db this way, which seemed to respond pretty fast to a couple of users, however there are the users that don't like to take extra steps (having to login to the terminal server).

I just wasn't sure if there was other or better ways to deploy.