mdb vs accdb performance

[Norman]

I converted one of my database from mdb format to accdb format in Access 2007 in the hopes that it would reduce the number of database corruption issues that have been occurring. My users are now complaining that the new version is slower, and I have verified that some screen updates are indeed slower. Has anyone else had this problem? Is there a solution?


Thanks,

[Tony Toews]

On Thu, 29 Aug 2013 11:28:10 -0700 (PDT), Norman
<norman.b...@boeing.com> wrote:

>I converted one of my database from mdb format to accdb format in Access 2007 in the hopes that it would reduce the number of database corruption issues that have been occurring.

I would not have expected converting from MDB to ACCDB format would
help with frequency of corruption issues.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony

[Patrick Finucane]

On Thursday, August 29, 2013 1:28:10 PM UTC-5, Norman wrote:
> I converted one of my database from mdb format to accdb format in Access 2007 in the hopes that it would reduce the number of database corruption issues that have been occurring. My users are now complaining that the new version is slower, and I have verified that some screen updates are indeed slower. Has anyone else had this problem? Is there a solution?
>
> Thanks,

No. I found both A2007 and A2010 speedy and better. Perhaps you can do a SaveToText/LoadFromText on a couple of forms and see if there is a difference. I will assume you've compacted and repaired both front/back ends.

Although I did not have a problem, others have. I went to Google and searched for "access 2007 slower than 2003" and got a few hits. You might want to read what others say.

[jafsan...@gmail.com]

On Thursday, August 29, 2013 2:28:10 PM UTC-4, Norman wrote:
> I converted one of my database from mdb format to accdb format in Access 2007 in the hopes that it would reduce the number of database corruption issues that have been occurring. My users are now complaining that the new version is slower, and I have verified that some screen updates are indeed slower. Has anyone else had this problem? Is there a solution? Thanks,

I have been using Access 2003 for at least 9 years for my company. I have created a database that is being used with at least 24 employers; I recently created a replica of the database utilizing Access 2013 and the results were disappointing, the database was working super fast with 1 user, but once other users were connected it started to become very slow. I never had this isue with Access 2003.