Cross: Access speed

  • Thread starter Thread starter Igor
  • Start date Start date
Pretty much *anything* is better than Access in a web environment.
However, why do you need more than one database?

I am planing to develop one program and sell this but it will be asp.net
aplication on my server and customers will not buy the program. They will
buy subscription for using this program. When someone wants to use my
program, he pays money to me and I put this program on web hosting account
and then he can redirect his domain to my hosting. If I can put many
programs (for many customers) on one hosting, I can save lot of money!
 
If I can put many programs (for many customers) on one hosting, I can save
lot of money!

Obviously - I do exactly the same!

Let me repeat my question - why do you need more than one database...?
 
If I can put many programs (for many customers) on one hosting, I can
Obviously - I do exactly the same!

Let me repeat my question - why do you need more than one database...?

I will not put one asp.net aplication with many logins for many users. It
will be separate asp.net program for each users and every user have his own
domain. One one web hosting account I can put many domains and then I have
directories (like www.bmw.com, www.mercedes.net, www.cars.org etc.) In every
directory I will put copy of this program and every customer use his own
program on his domain. So I need many SQL Server databases... or maybe I can
put one database on this hosting and add field "CustomerID" which make
difference between data of every customer? Can I use one sql server database
on mutiple programs/domains?
 
One one web hosting account I can put many domains and then I have
directories (like www.bmw.com, www.mercedes.net, www.cars.org etc.)

I do exactly the same - my ISP calls this a "multimap"
http://www.hostinguk.net/services/multi_mapping.asp
In every directory I will put copy of this program and every customer use
his own program on his domain.

That's right.
So I need many SQL Server databases...
Why?

or maybe I can put one database on this hosting and add field "CustomerID"
which make difference between data of every customer? Can I use one sql
server database on mutiple programs/domains?

That's right.
 
Access MDB is a decent database.

But I sure as **** wouldn't use Access forms and DAO against MDB.
that's just plain unreliable.

MDB is a pain in the ass..
Using SQL Server would probably be easier.

-Aaron
 
Back
Top