i was wanna to ask if i use ms sql database
by the same way we use access there will be the big defferant they talking about or i must use spacial server and spacial set up to see the differant and what is the maximum abbilty of access 2000 i hear that it can't work with more than 10 user togather plz help me in that.

Hello,

Access 2000 has a limit on users at the same time, still is sure can handle some good things. MS Sql Server is what you should use if you have more then 10 users at the same time around the clock. If you would have less then 10 users at the same time you are better, and cheaper off with Access 2000 since MS Sql Server Standard Edition is very pricy. The max use of Access 2000, good question, i don't know where it really stops but i have handled more then 10 users at a time with no problem, so i think you'll have to look at your whole framework. For example, what connection you have, what hardware you have, what is your target audience. Then you'll find out fast how much you'll be spending. Hope i could help you in someway, and if you need any further assistance, please let me know !

Greatings,

Dave Joosten
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
i was wanna to ask if i use ms sql database
by the same way we use access there will be the big defferant they talking about or i must use spacial server and spacial set up to see the differant and what is the maximum abbilty of access 2000 i hear that it can't work with more than 10 user togather plz help me in that.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Dave Joosten

thank u very much about ur help but i am still new in this and i wanna to make a good big site all my data bases r simple with our relationship but i am sure there wil be more than 10 on the same time coz i design music search engine but i afrid from sql coz i did never use or see it before and i think it need spacial setup and admin ,not so easy like access and i try to upsize access data base but i can't do it so i wanna one tell me r there is big defferant in connection and setup sql database and no problem with the design vcoz i tell u i need simple data base with one table only .....thanks alot

thank u very much about ur help but i am still new in this and i wanna to make a good big site all my data bases r simple with our relationship but i am sure there wil be more than 10 on the same time coz i design music search engine but i afrid from sql coz i did never use or see it before and i think it need spacial setup and admin ,not so easy like access and i try to upsize access data base but i can't do it so i wanna one tell me r there is big defferant in connection and setup sql database and no problem with the design vcoz i tell u i need simple data base with one table only .....thanks alot

Do you have SQL Server Enterprise Manager? If so, create new DB in it and start Import Wizard. Choose Access as source and SQL as destination. Follow answer to few questions and that's it. Your DB is imported. You'll need to ask you hosting for IP address, port... in order to connect to their server. Also, you'll need to make some changes to DB once it is imported.
You can contact me through mail or ICQ and I will help you.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
thank u very much about ur help but i am still new in this and i wanna to make a good big site all my data bases r simple with our relationship but i am sure there wil be more than 10 on the same time coz i design music search engine but i afrid from sql coz i did never use or see it before and i think it need spacial setup and admin ,not so easy like access and i try to upsize access data base but i can't do it so i wanna one tell me r there is big defferant in connection and setup sql database and no problem with the design vcoz i tell u i need simple data base with one table only .....thanks alot


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>