I'm ready to split my access front end and expand into a SQL server. I'd like to host the tables at a webhosting company, so I can access them over the WAN. Can anyone recommend a good webhosting provider for this service?
My current webhosting company shows that it will actually host Access databases. If I only have 5 or less users, but they'll all be on at the same time and probably using the same tables, will this be sufficient? Here's what they say:
As a customer hosted on the Dotster Windows platform, you can automatically connect to any Access database stored within your web directory. To do so, you'll need to embed a connection string in the body of any script that needs to talk to a database. Here's an example:'Database connection info and provider
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_
Server.MapPath("database\dbname.mdb")
The only other thing is that I want the user level security that I can get with SQL. I could work around that, but it would be nice.
My webhosting company also offers MS SQL hosting, but they state:
MS SQL restrictions
There are several restrictions on MS SQL database connections:
- You cannot connect to your MS SQL database remotely; we only provide online database access through theManage MS SQL tool and myLittleAdmin. Learn how you can access and manage your MS SQL databases
- Dotster does not support DSN connections
So it doesn't look like they'll work for hosting the backend... Am I correct in that understanding?