COnverting from Access to SQL Server

[AJordan]

Hey all,

I was just doing some forward thinking and I was wondering if there was some kind of guide or previous post that deals with when to consider switching from a simple access database to SQL server. None of the things I do now need anything more powerful but I was just wondering what are some triggers that would click to say " Hey access can't do it anymore"?

 

[HiTechCoach]

I will assume that your app is already split into a front end and back end properly. Also that you are talking about keeping the front end in Access and migrating the back end from Access to an SQL server. Note: You only nbeed to move the table and possible the queries to the SQL server.

What you can not avid is the size of the database. An Access database can not exceed 2 GIG in file size. If you need more space, it is probably time to migrate the back end to an SQL server.

Also the number of concurrent user can make a difference in performance. An SQL server can handle a lot more users than Access.

 

[AJordan]

Yes the database is split front end/back end. Size is not a major issue so I guess my concern was how many concurrent users can Access have before problems arise. Currently the most people ever to use the database is 4.

 

[Banana]

Try those:


Beginning SQL Server Development

Beginner's Guide to ODBC