Multiple Customers - Microsoft Access SQL Server Online


	Back to Access SQL Server Online Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multiple Customers

Ray White

13 months ago

I do have the Access SQL Server Online Seminar.
I am trying to setup a custom Access program, Access front end installed on computer with runtime for each customer and SQL server Back end.
The program will be sold to each customer with a monthly service fee to be used.
Each customer will need there own copy of the SQL back end.
This is where I'm having trouble.
Will I need to make a new copy of the SQL server Back end for each customer.?
Or would I just use one SQL server back end to support All customers.?
Like when they login to there account they would only access there Info.?
Any help would be grateful.

	Ray White OP @Reply 13 months ago
I guess what I,m trying to say what is the best way Design Multi-Client Databases.? Using SQL server Back end .

Sami Shamma @Reply

13 months ago

Regardless of the back end being Access or SQL-Server, the answer is the same and the answer is it depends.

If you do not fear exceeding file size limitation, then one SQL-Server back end is the better solution.

make each customer belong to a Company. Then at login control what data they can see. It is a bit more programing initially, but you gain time by not having to maintain multiple backends.

	Ray White OP @Reply 13 months ago
Database Multi tenancy for a SaaS application

	Ray White OP @Reply 13 months ago
Thank you Sami

	Ray White OP @Reply 13 months ago
Nobody would exceeding file size limitation of Access database. So I could find a company that Hosted Access database and just but Multi copies of the back-end for each customer. Then if I need to do any updates to the back-end I can do that thru code from the front-end. Any good idea on a Hosting company that host Access database.?

	Sami Shamma @Reply 13 months ago
Richard recommends Wihost.com. And I second that. I have two hosted SQL-Server accounts with them, one is shared, and the other is dedicated. I strongly recommend you see: Access SQL Server Online In there, Richard talks about his experience with hosting companies as well as show you how to set all this up.

	Ray White OP @Reply 13 months ago
Thank you Sami

	Ray White OP @Reply 13 months ago
Sami I do have the Access SQL Server Online Seminar. I need to go thru it all. I had retired my software business and access programing 3 years ago BUT really mess it LOL. So I'm back. I have been here with Richard for many years, I guess I need to renew my membership. Thank you Richard for all you do...

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access SQL Server Online.

Next Unseen

New Feature: Comment Live View