i am in a very different problem. i have to create a website with a database at backend. total number of records to be inserted into the database 3,00,00,00 in different table i am willing to use SQl Server but my Client want that data should be in MsAcces i think it is very difficult hold this much data in MsAccess.so i am thinking to break the database according to region therfore there will be 30 databases.
 any body can suggest me how i can switch to different regions to use different databses. i mean to say that i want to write single page for all the database use of a particular databse depend upon his user name and password. will my site works normally when all the regions are doing dataupdation at same time





dinesh Rana

__________________
dinesh Rana

Well I guess switching between DB wont make much diffrent, BUT! u should aware some problems.
Will u Count or Sum them, SPECIALLY using in groups. That would be much difficult in handling I guess!

Keep in touch.

Always:),
Hovik Melkomian.

Hey,

When updating the databases, you may encounter a problem with your app, stating that another user or resource has the database locked exclusively, it is opened by the process that updates them. There is a setting that allows multiple users to access a single database. With that many records, you may run into performance problems with retrieving the data from the databases. Splitting them will help, although storing it in SQL Server will definitely be your best avenue.

Brian

thanks brian, thanks Melkomian i know Sql server is the best option but the constraint is Client. he dont want to go for sql i dont know why but i dont want to loose my client.please help me in finding outthe problems i have to face when 30 different MSAccess database
running simuntanously on the webserver. and if i use single database i calculated that the database size might increase to the Size of 1.75 GB. i have a database of ms Access with 35 MB of database but never tried on such a huge volume in Msaccess please tell me weather MsAccess can hold this much Volume or not


:)

dinesh Rana

Using Access with this much data is, quite frankly, absurd. You should do the right thing and explain to your client why using access is the wrong solution. Not only is the data outside of a realm that Access can easily proccess- the database is *not* multi-user. While this is fine if you have one or two people reading from a database on a site.. it's not OK if you have any kind of volume of users.

Now- assuming you can't change your client's mind.. You could use an additional access database that lists what data is in what database. then have the page query the database for which database to use.. then connect to the proper database.. You could create the dataconnection to the right database after determining which one you needed to connect with.



Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Hal Levy is right: clients dont have technical info & its ur job to talk to them, they should accept u since no1 want to lost its information & DataBase.

But again u dindt answered my question ?! if u have to use Access there should be a way.

Always:),
Hovik Melkomian.

Dear Hovik i talked to the clients several times they have a it team which is not very much professional once they tried something on sQl sql server but when actually they implemented it there server crased and they are not able to extract the data of that reason they lost there repute and know they dont want to go for sql server basically they are event mangemnet company and whole there working have only one or two days in this time any thing happen then there is a total loss there professional says that they can handell asy thing if the back end database is MsAccess what in case of sql server they are not able to do any thing. secondly they have to make many inhouse application on the same database and there team is in quite confident in Msaccess. there simple reply is we are not willing to carry out with technology and fall in ditch. if you can do it in Access based do it otherwise leave it so i have a simple one go

dinesh Rana

Well we all have to do what clients want, clearly what ever they wish is our goal as a Developer. So as u said there is two way, but if u ask me, choose first & dont give up!
Its seams u wont need all data together, so creat ur 30 DBs & go on.
As I told before only ur Connection string will be changes so First make a XML file to store what data u save in witch DB & then set its connection string & ...
Its not too difficult in theory, go on & see what u can do!;)

Always:),
Hovik Melkomian.

I would find a way out of this contract or make sure your contract protects you against data loss. What your building will result in lost business and data due to their choices- you shouldn't be responsible.

Sounds like the IT staff of this client doesn't know what they are doing.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

dear hovik
     i started building application as you suggested this is the only way i think to do so. so the client dont require all the data togather except once at the end of whole show and that is too there head ache not mine.

dear hal
          i have cleared each and every thing to the client. as Clients It staff is concerned they are only protecting themself from the hazard's that they faced when there Sql server Crashed last time. i also told them that there are many options in the sql by which we can retrive the data from sqlserver also showed them replications and all that we can do in order to secure sql server. but all ---------- .so i am proceeding according to there requirement.

if i came out sucessful out of this i will definatly write back to you thanks for you suggestions , your concern it was really great. i really thanks to wrox Prees for making all this



dinesh Rana