Access 2010 stability

[chappy68]

We are trying to decide between reworking our FE/BE Access 2002/2003 database in Access 2010 or SQL backend and Access front end. My prior experiences with Access 2002 was when the database bloated to about 100mb, it started having problems corrupting records and became unstable.

I spoke with a gentleman the other day that stated Access 2010 is much more stable at larger sizes than prior versions. We are not running millions of records. Right now our database is fine but we have changed how we analyze data and some of the work previously done outside the database will now be done inside the database increasing the number of records significantly.

My concern is we put in a bundle of time now and in a year or so the database becomes unstable and we then need to migrate to SQL Server.

Any insights would be greatly appreciated.

 

[DJkarl]

Well I would say if migrating to SQL server is even an option on your plate then take it. You can still use Access as a front-end to your SQL server back-end, but then you eliminate some of Accesses biggest issues by housing your data in a more stable environment.

 

[chappy68]

Well I would say if migrating to SQL server is even an option on your plate then take it. You can still use Access as a front-end to your SQL server back-end, but then you eliminate some of Accesses biggest issues by housing your data in a more stable environment.

I was leaning that way but I was hoping you wouldn't say that. I am not familiar with SQL Server at all. I know I can migrate to SQL Server through Access but since I don't know SQL Server I won't be able to tell if it did a good job.

 

[Lightwave]

Access should be able to cope up to 2GB no problem. It should be used with caution over wide area networks and it certainly doesn't like when you include jpegs actually in the database but avoiding that and with good design its not supposed to have problems.

 

[Lightwave]

SQL server is an industrial strength product and you will probably need to get IT support if you are a power user as it requires to be set up on a server and its not entirely user friendly with a somewhat un-intuitive interface. Additionally it tends to hiccup with straight transfer of large amounts of information but too my mind simply setting it up ready for use is the hardest part of using it.