Access to SQL. good idea?

[Paul11]

at the moment we run a small access database but need two users to access it from different locations.

i have tried a VPN, but its not ideal (althought ive not tested it since the host officed move to BE from talktalk)

i can have the system moved to an online SQL type system. with a custom built front end , web based.

what are the pros and cons of doing this ?

do companies run online systems as far as losing net connection, means you lost access to all your info ?

how slow will it run on a hosted/SQL system compared to a local access app ?

thanks

 

[Paul11]

thanks daz,

i was trying to work out how much slower will it run using a web based system ?

compared to running access on a local pc ?

 

[Paul11]

thanks.

sounds like a no brainer then.. i wasnt sure if it would be very slow to constantly update ..

 

[Paul11]

do you mean use access as the front end linked to the SQL server ?

would that be quicker than web based, or no difference in speed ?

 

[Paul11]

thanks

im going to look in to all the options

 

[Paul11]

You could also (if you haven't already) split the access database, keeping the data itself on the network and all the forms/queries etc running locally on each machine, which is much faster than keeping a single access database with everything in it.

that is what we have.

and the remote office just links in via VPN to get to the Data file whilst having the app locally

it s just not very snappy and feels a bit laggy at times

i was hoping to upgrade our system to add more functions so thought it might be a good time to make the transition to SQL and web based as long as it was quicker (hopefully) than what we have now

 

[Paul11]

That sounds like a web application with a SQL backend - this would be much faster than Access, as the only speed bottleneck would be your internet connection to the site itself (rather than running queries across your VPN) if they are hosting the site.

Sounds like a much better solution to me (and one I was going to suggest in a similar thread to this last week).

we are looking at the option of keeping our access front end on local pc's and linking the backend to a MSSQL on a web server.

will this be as quick as a web based system ?

any downside to doing it this way ?

thanks

. But yes, you could use your access front end to a SQL back end over the net with relative ease, we use it a fair bit with old access apps that we still need to maintain.

adren, does this system work at a decent speed ?

 

[Paul11]

sorry i meant MS SQL

edited post.