473,322 Members | 1,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Access 2010 incompatible with previous versions?

I have an Access database that has been is use for approx 8 years. It was originally written in 2000 and subsequently converted to 2003.

It consists of a client-unique front-end linked to a shared Access 2003 back-end data storage.

Has approx 200 concurrent users with a mixture of full Access 2003, full Access 2007 and Access 2007 runtime.

Never crashed in 8 years until we put out first Win7/Office2010 clients on the network.

Now it crashes regularly with "unrecognised database format" and random tables lose their indexes.

About a year ago, I installed the same application at another site. That ran without a glitch for almost a year until they put their first Win7/Office2010 client on the network.
Now theirs crashes weekly too.

I note that Office2010 automatically installs an "evaluation" version of Access2010, even if you buy a version of Office that doesn't include Access.

Access 2010 seems to have a backward compatibility issue with databases created in earlier versions.

Having the previously stable application crash regularly and inconveniencing 200+ users is not an option.
Neither is ugrading every client to Office 2010

Can anyone tell me exactly what is happening and suggest how we work around this.
Jul 28 '11 #1
9 12472
Narender Sagar
189 100+
You can create a new database in Access 2010 (in .accdb format) and import all objects in the new database. Database security features are changed in new version (like Workgroup Security is not available in .accdb files).
Switchboard option is also not available in new version. You can check on internet what is new in Access 2010.
Jul 28 '11 #2
Thanks for your input Narender.
But I think you have missed my point.

I don't want to migrate the application to Access2010.
I want to continue running my Access2003 application on clients which use 2003 (full & runtime) and 2007 (full & runtime).

My problem seems to be that on clients touched in any way by an Office2010 install, the 2007 runtime is corrupted or somehow usurped and the application fails, at the same time corrupting the shared central datastore (a 2003 format.mdb) so causing the application to become unusable not just for that user but for the entire client population.

What I need is a method of installing Word2010, Excel2010, PPT2010 on a client alongside Access2007 Runtime so that the Access2003 program component running on the client doesn't corrupt my shared Access2003 central datastore.

So I need to understand how the Office2010 install is turning my functioning 2007Runtime into a database corruption tool.

DLL conflicts?? Registry settings??
All ideas gratefully received.
Jul 28 '11 #3
NeoPa
32,556 Expert Mod 16PB
My suggestion would be to check somewhere like Converting to Access 2007 or 2010 to see if you can find anything that might explain your scenario Vernon.
Jul 28 '11 #4
neelsfer
547 512MB
Vernon, i was on A2010 for a 3 solid days, and converted back to A2007. One of my applications corrupted totally and another one developed "bugs" slowing it down to the extent, that you can have a cup of coffee in between pressing the buttons in the application.In A2007 it was lightning fast.
I was also using windows 7 + A2010 and even installed the new Office 2010 sp1 that was released very recently, with no improvement.

I have 2 other clients with A2010 installed, that experienced this "unrecognised database format" error with one of my applications.
WE have tried everything to no avail, and they are also now migrating back to A2007.

If you succeeds with: "What I need is a method of installing Word2010, Excel2010, PPT2010 on a client alongside Access2007 Runtime" right, then please post the solution!
Jul 28 '11 #5
Rabbit
12,516 Expert Mod 8TB
I'm thinking if you uninstall all office products, then install the office suite with custom options where you check only word, excel, and ppt, then install Access 2007 runtime, that might work.
Jul 28 '11 #6
I see similar nonsense.
Have a customer with 2010 on a server and 2000 on a series of PC’s recently showing what look like incompatibility issues; once a 2010 user saves the file, simple VBA code on a 2000 box opening a form fails.
I have also noticed similar but perhaps more expected issues when I modify a report in a 2003 file in 2010 and then attempt to use the MDB again on 2003.
Looks like it's part of Balmer's attack on productivity.
Nov 1 '13 #7
NeoPa
32,556 Expert Mod 16PB
Actually, MS Access has always had difficulties working with earlier versions. In previous releases of Office the other applications (Word, Excel, etc) were always further ahead than Access when it came to interoperating with other versions. Access has started to catch up, but clearly there are still issues. This reflects how difficult it's always been to interoperate within an application as complicated and heavy-duty as Access is.

My understanding is that a big problem, that accounts for many such issues, is that while libraries can be found to replace any missing ones on any individual PC, Access actually saves these new libraries in place of the originals when it is used. The side-effects of this are many.
Nov 1 '13 #8
neelsfer
547 512MB
Since my last post i have learned a few things. My 2007 versions are working almost 100% in Access 2010, but only because i use the latest available Service packs for both Access 2010, and Windows XP or 7 or 8. Also check that you have version 14 in your vba code where needed, and not version 12.
When it comes to 64 bit, compile a copy of your program to accde, using a 64bit windows operation system pc. I keep both 32bit and 64bit versions of my applications these days
Nov 1 '13 #9
zmbd
5,501 Expert Mod 4TB
This is a very old thread and as Neopa pointed out a very well known issue - only made worse with the introduction of 64bit flavors of the applications and PC hardware.
Nov 4 '13 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: phill86 | last post by:
Hi, I have an access 2010 database that I want to convert to an SQL Server database and I need to know if the data macros in access will still work in the SQL database or will i have to create...
5
by: jaad | last post by:
Hello, I have a database that was written in access 2007 on my pc. I wanted to work off site with the database so I uploaded it onto my laptop which is loaded with access 2010 beta. When I...
2
by: sierra7 | last post by:
It seems Access 2010 is associating an 'input mask' or field type with a combo box when a form is opened, even though there is no Format setting on the control. I have a form which has been...
2
by: dougancil | last post by:
I have a user who had deleted some records from a database today using Access 2010. They have an ID field that's autonumbered. They have No Duplicates allowed. When they created a new record today,...
0
by: Andolino | last post by:
In Access 2010 I get a Write Conflict error - "This record has been changed by another user..." In Access 2007 this Code is working - why? Private Sub Form_BeforeUpdate(Cancel As Integer) Dim...
1
by: Alan Yim | last post by:
Hi folks, My company recently upgraded our Office suite from 2003 to 2010. The problem in particular is with an Access database that was originally designed in Access 2003. The code in question...
5
by: colsoft | last post by:
I am using Access 2010. Am generating reports for the records, one record per page. The records on the even pages have a light black background shading which appears when am printing. Please i need...
2
by: Bill Boord | last post by:
I need to be able to shut off the AutoCorrect "feature" within Access 2010 code. I have utilized Application.SetOption with method strings for other startup requirements, but I cannot seem to find a...
1
dsatino
by: dsatino | last post by:
I have numerous applications built in Access 2000/2003 that all use ODBCdirect workspaces to access various non-Access databases. Unfortunately, ODBCdirect is 'no longer supported'in Access 2010 and...
1
by: Music Man | last post by:
Greetings All: I built a database in Microsoft SQL Server 2000 and used Microsoft Access 2010 as the front end. The database is used to keep track of "issues" that rise out of my employment. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.