I develop Access databases at work, and most of my users are running 2002, with no real upgrade in the future. I'd like to install Access on my home machine (currently I don't have it at home at all), but if I buy 2010, I'm afraid I will have trouble remembering will and won't run on my users' versions.
Or is this not much of a problem?
As most of the comments seem to be saying, go for the compatible version. Access is famous for struggling with compatibility across different versions. That means 2002 (or XP) even though 2003 is very much a solid product and the differences between the two were minimal (AFAIA).
I'd never recommend 2007 to anyone anyway, as it's a pile of junk, but even 2010, which is coming to be understood to be pretty robust and reliable, is not the version your users are using, so I'd avoid that for this project.
8  1390 
I think you should buy 2007 or 2010 Ms office and upgarde all the db to 2007/2010 version.
As I said in my original post, there is no upgrade in the offing for my users. They work at different institutions than I do, and I have no input, much less control, over what those institutions run. Also, we're County, so shoestrings are a luxury for us.
It's 2002 for them or nothing.
From personal experience, I have observed that databases made in 2003, later opened in 2007, would no longer even open in 2003, even though I had made no design changes while having it open in 2007.
yes buy 2002 or 2003. Just be sure when you save your work to save it in 2000 format from the file menu.
I have gone through the same issue and obtained a copy of access 2003. It seems to be the standard version for access in most companies to be honest.
NeoPa 32,556
Expert Mod 16PB
As most of the comments seem to be saying, go for the compatible version. Access is famous for struggling with compatibility across different versions. That means 2002 (or XP) even though 2003 is very much a solid product and the differences between the two were minimal (AFAIA).
I'd never recommend 2007 to anyone anyway, as it's a pile of junk, but even 2010, which is coming to be understood to be pretty robust and reliable, is not the version your users are using, so I'd avoid that for this project.
Thanks for the advice, everyone! I guess it's 2002 for me!
NeoPa 32,556
Expert Mod 16PB
You may have problems finding 2002 (XP) in the market now, but I expect you'll manage to get a copy if you look on the web. Good luck with it.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Simon |
last post by:
Dear reader,
Can I install Access-2000 and Access-2002 on one machine with as operation
system MS-XP.
If same one knows how to fix this please lat me know.
|
by: John |
last post by:
Hi,
I've recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet...
|
by: deko |
last post by:
After doing a lot of vba work, I've noticed the size of my mdb has grown,
even though no data or objects have been added.
I've read that the following procedure will remedy this and improve...
|
by: Esmee |
last post by:
Hi there,
Hope you guys can help me out.
For one of my clients I have created an Access 2002 db. It used to be
under Access97, but I have converted it to Access 2002, without any
problems.
My...
|
by: David Kistner |
last post by:
I'm fairly new to Access (I've worked with Oracle and MySQL in the
past). I was asked to build an application for a small office and told
that I had to use Access 2002. I was VERY uncomfortable...
|
by: James P. |
last post by:
Hello there,
I'd like to have my minutes convert to hours and minutes in Access
report in this format: hh:mm. For examples: 150 minutes converts to
2:30. I have this formula below used to work...
|
by: Aliza Klein |
last post by:
Apologies in advance as I am SURE this has been asked 100 times - but I
haven't got a simple answer:
I have MS Office XP Developer and have created an installation package (with
the runtime) for...
|
by: mar10 |
last post by:
I am creating a database in Access 2002 for a small firm that would
like security on the tables. They want some employees to have write
access only to tables, while others read-only.
I have not...
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server...
|
by: mainframetech |
last post by:
We are having a problem with Access 2002 as opposed to Access 2000.
A multi-file query was set up under 2000 and tested good. Access is
connected through a link to an Oracle 9.1 database. The...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
| |
