473,511 Members | 16,258 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ACCESS 2000 to 2002 Question please..

2 New Member
Hi there,

Wonder if you can help me with my dilema ! ?

I currently have an access2000 database which works just fine, but when I come to open it with access2002 the relationship table is damaged.. All the links have gone and if I try to add some and then save it in 2002, they are gone when opened again !

I have tried exporting all the tables and queries in the 2000 database to a clean 200 database and created the relationship table again, but when it is opened in 2002 the same thing happens!

If someone can enlighten me as to where I am going wrong I would be most grateful.

Many thanks in anticipation

Paul.
Aug 1 '07 #1
1 1107
Hammy
2 New Member
Okay fixed it !

Me being Mr Thicky Thick Thick, forgot to remove the queries with external links to other databases, and in doing so messed up the relationship links..

Dropped them out and voila !!

Normal service is resumed... Nothing to see here.. Move along !

PS.. Thanks for looking anyway though
Aug 2 '07 #2

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

Similar topics

2
1803
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.
3
2101
by: Scott | last post by:
Hi, If we want to compile an Access 2002 database and distribute it to others, will the compiled software run on any PC, like Windows 98, Windows 2000, etc. Also, you don't have to have...
7
3440
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." ...
0
1403
by: Miguelito Bain | last post by:
hi everybody- i've got a conundrum... i inherited some old databases, and i'm trying to convert them. i run office xp with access 2002, and all of the databases i manage are either in 97...
3
2007
by: John Baker | last post by:
Hi: I am the ?proud? owner of Access 2000, and have been using it for a while (with help from this group). I now want to put some Access applications on the web. An associate told me that this...
3
1547
by: Stickleback | last post by:
Morning All I have been developing and deploying with Office 2000 for about 3 years, mainly Access based programs and although I have gotten used to it's quirks, I am starting to feel that I...
1
1358
by: Karen | last post by:
Anyone that may be able to help. I have MS Access 2000 installed. I need to convert some MS Access 2002 database files to MS Access 2000 needed for a course. Does anyone know how to convert? ...
47
4482
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
49
3171
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
13
13231
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
0
7242
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7138
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7353
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7418
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5662
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5063
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
4737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3212
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.