Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Access vs. SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-29 : 21:22:25
Duke writes "I have been using MS Access to as my database so far, however, when I release my site I would like it to be as optimized as possible. I plan on having somewhere around 10k-20k records per table.

I would like to know is does changing databases really change the preformance that much?

Also, how do I go about making my SQL database online? I've heard that I need to use DSN. If so, how would I make the initial database without having the server accessable to myself? Thank you and please respond as quickly as possible.

Duke"
   

- Advertisement -