Shawn
asked on
setup advice with DBs
I will soon be setting up an account for a client and need a little advice. We have chosen sqlserver as the company db and will be building an internal app with MSAccess as the front end. We would like to use the same db to display certain information on the Website (shared hosting at Hostek). The website will use the cf cms Mura.
I suppose the main question is where should I put the database(s)? In the past I have actually had 2 DBs, one on the site for simply website related content and one in our office servers use for internal purposes but accessible also via the website. Is this scenario feasible/advisable?
I suppose the main question is where should I put the database(s)? In the past I have actually had 2 DBs, one on the site for simply website related content and one in our office servers use for internal purposes but accessible also via the website. Is this scenario feasible/advisable?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx myselfrandhawa. reassuring.
If the data on the web is intended only as a read only or very limited input (7-10 fields), then you can have two DB's and the web facing would be a a reporting service type DB with either replication or the IIS connecting to the actual DB.
If the web facing one has significant input then I would look at building a web app and not invest in the Access app beyond what is needed.
Also what level of security do you need?
There is no straight answer that any of us can say nay/yea on.