Question Is Access 2010 stable?

nrego

Registered User.
Local time
Today, 15:21
Joined
Jul 27, 2012
Messages
14
I have created a database to track a large number of data in my department. This data is used to create reports so that we can track the progess of our workload and be able to accurately document how long it takes to do each project. We also use this database to eliminate the need for data duplication and to provide automated tasks, such has emailing our sales people when a specific product is shipped.

Our IT department doesnt feel that Access is the best program for this because it is not "stable". So my question is, how stable is Access?
 
Not an answer, but an addition to it: What did your IT department offer as their alternative app? They might be considering that Microsoft tends to deprecate features between versions, breaking established links upon which you depend.
 
They offered Microsoft Project but I dont know how it would apply.
 
I know a lot of people who "demean" access just because they're not educated enough about it. Access in my honest opinion is pretty stable. The only thing that would cause it to crash is user errors.
 
Our IT department doesnt feel that Access is the best program for this because it is not "stable". So my question is, how stable is Access?
Your IT department is uninformed and probably doesn't understand that Access is a development environment and Jet/ACE (depending on version) is the actual database engine and a separate product. If they have concerns regarding Jet/ACE, then your data can be stored in SQL Server which I believe they will consider stable and reliable. Your Access application will then link to SQL Server rather than to Jet/ACE tables.

BTW, It is quite possible that Microsoft Project actually uses Jet to hold its data:) Many Microsoft applications do.
 
Pat how do I go about saving my tables and data so that it can be stored in SQL Server ?
 
You don't need to do anything special. If you want a preview of how smoothly the data transfer will go just run the upsizing wizard and read the report. You may have column names that SQL Server doesn't like or relationships on fields of unlike sizes (Jet/ACE are more flexible), or validation rules that don't pass muster. You won't know what you have to address untill you do it once. You can then delete the database and recreate it again once you have fixed the problems.

All your tables MUST have primary keys or you won't be able to update them via Access. You should also define relationships and enforce RI.

Modifying the application can take anywhere from an hour to a week depending on how it is designed. If you just upsize the tables and leave it at that, the application will work (some DAO and ADO code will need minor changes) but it will likely be slower than the Jet/ACE version. To make effective use of SQL Server (or any other RDBMS), you need to bind your forms to queries that use selection criteria to severely limit the amount of data selected. Typically Access applications use forms bound to table or unqualified queries. Because of the way Jet/ACE works, this is not a problem. With a server-side database it is a major problem. A form bound to a table or unqualified query will open as soon as Access has a couple of records downloaded. The form will then just sit there sucking data down from the server until the entire recordset is local. If your table has a hundred rows, it really won't matter much. But, once you get more than a few thousand, you'll notice the slowness and your network administrator will seek you out to complain about the bandwidth you are using.

We've written lots here about working with SQL. Have fun.
 

Users who are viewing this thread

Back
Top Bottom