When go to SQL

[DougAtAvalon]

I develop Access databases but i need to know its limits or when it will start to slow down if I have a back end and front end.

Is conversion to SQL when it splits like this time consuming. I know it depends on how complicated the DB is dy I guess I am looking for some experienced guidance on this.

-Doug

 

[tlbroadbent]

Doug,

There are a lot of factors involved. In my mind, two of the most obvious factors are number of concurrent users and database size. More subtle factors but important factors include; types of queries involved, need for security, data reliabilty and recoverability, remote accessability, etc.

Microsoft offers some guidllines in the article, "When to upsize a Microsoft Access database to Microsoft SQL Server" at

http://msdn.microsoft.com/library/officedev/off2000/acconWhenToUpsizeMDBtoSQLServer.htm.

Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot