Access problem
#1
Scooby Regular
Thread Starter
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes
on
0 Posts
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
Problem is,
College is running Office 97, and at home im running Office XP.
ive already asked gary about this, he said there not a chance it'll work.
Anyone shed any light on my problem
Si
College is running Office 97, and at home im running Office XP.
ive already asked gary about this, he said there not a chance it'll work.
Anyone shed any light on my problem
Si
#2
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
Yeah your versions are different..
see office xp aint the same as 97..
You follow that??
or..
version is difrent.
cant work dont think..
![Wink](https://www.scoobynet.com/images/smilies/wink.gif)
Make sense?
David
see office xp aint the same as 97..
You follow that??
or..
version is difrent.
cant work dont think..
![Wink](https://www.scoobynet.com/images/smilies/wink.gif)
Make sense?
David
#3
Scooby Regular
Join Date: Oct 1998
Location: London
Posts: 4,891
Likes: 0
Received 0 Likes
on
0 Posts
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
David's right. Access 97 and Access 2002 (aka XP) aren't compatible, as far as I'm aware. You may, however, be able to save your databases as '97-compatible from OXP. I don't know, though, as I don't use Access (it's a POS).
Surely though, referring to your other thread about W2K vs XP, if the college is running Access '97 you should be running it at home too? Or do you have an inconsistent policy?
Surely though, referring to your other thread about W2K vs XP, if the college is running Access '97 you should be running it at home too? Or do you have an inconsistent policy?
![Wink](https://www.scoobynet.com/images/smilies/wink.gif)
#4
Scooby Regular
Thread Starter
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes
on
0 Posts
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
word 97 and 2002 works! :P
I think they changed from DAO to ADO in these two version.
College it slowly upgrading to win 2k and office 2k.
Si
I think they changed from DAO to ADO in these two version.
College it slowly upgrading to win 2k and office 2k.
Si
#7
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
its got nothing to do with ado and dao, its because micro****e are *****..
same prob with access 2.0 and 97 etc.
Word documents arent quite as complicated as databases..
David
same prob with access 2.0 and 97 etc.
Word documents arent quite as complicated as databases..
David
![Big Grin](https://www.scoobynet.com/images/smilies/biggrin.gif)
Trending Topics
#8
Scooby Regular
Join Date: Oct 1998
Location: London
Posts: 4,891
Likes: 0
Received 0 Likes
on
0 Posts
![Thumbs down](https://www.scoobynet.com/images/icons/icon13.gif)
i might put XP back on, just had few issue's with games
Word documents arent quite as complicated as databases..
![Embarrassment](https://www.scoobynet.com/images/smilies/redface.gif)
#9
Scooby Regular
Thread Starter
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes
on
0 Posts
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
just i bought to 2k so id might aswell use it.
I know Xp does use the ADO, 97 doesnt support that.
Whats worse is the college is on NT and its fooking ****.
Just sorted my database out at last.
Im am suprised word is more complex, but i suppose it has more options and use's.
Si
I know Xp does use the ADO, 97 doesnt support that.
Whats worse is the college is on NT and its fooking ****.
Just sorted my database out at last.
Im am suprised word is more complex, but i suppose it has more options and use's.
Si
#10
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
Tools, Database Utilities, Convert Database, To Access 97 File Format ...
Of course, if you've used any new features that aren't supported in Access
97, the app isn't going to work without modification.
There is an interesting feature that may help you, if you look between the Escape key and the F2 key and press the button. Alternitavely STFI
Of course, if you've used any new features that aren't supported in Access
97, the app isn't going to work without modification.
There is an interesting feature that may help you, if you look between the Escape key and the F2 key and press the button. Alternitavely STFI
#11
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
Si,
It aint an ADO/DAO problem, I use ADO to connect front ends to Access97/2000/SQL Server, ADO just supercedes DAO, its basically the MDB file format changing, your best bet is to design it in '97 and then you can open in 2002 you just wont be able to change the structure, how did you get on with the DB anyway, you understand the relationships now yes?
Gary
[Edited by GaryK - 9/17/2002 3:09:16 PM]
It aint an ADO/DAO problem, I use ADO to connect front ends to Access97/2000/SQL Server, ADO just supercedes DAO, its basically the MDB file format changing, your best bet is to design it in '97 and then you can open in 2002 you just wont be able to change the structure, how did you get on with the DB anyway, you understand the relationships now yes?
Gary
[Edited by GaryK - 9/17/2002 3:09:16 PM]
#12
Scooby Regular
Join Date: Oct 1998
Location: London
Posts: 4,891
Likes: 0
Received 0 Likes
on
0 Posts
![Cool](https://www.scoobynet.com/images/icons/icon6.gif)
Im am suprised word is more complex, but i suppose it has more options and use's.
To complicate things further, the file format is designed in such a way that, for example, if you wanted to print page 450 of your 500-page document, the entire document doesn't have to be read from disk. This means that each of the streams of text/formatting, and the deltas, have dependencies and relationships which have to be fathomed out before you can get at the text itself.
It's a very clever format, but probably overcomplicated (particularly when machines and HDDs are so fast these days that saving the whole of a 100Mb document wouldn't take long anyway).
[Edited by MarkO - 9/17/2002 3:11:10 PM]
Thread
Thread Starter
Forum
Replies
Last Post