access 97 - 2000

[dmb1]

I have designed a database in access'97 which is quite large but not overlly complicated. The database is to put on some machines which has access 2000 on them. When I tried to run this database using access 2000 it said that it was created in a previous version of access and would have to be converted which I tried to do but it said there was a problem converting it. When I tried to run the database without converting it there was an error again.

Can anybody suggest any possible reasons why I could be getting these error messages!

Thanx

 

[ghubbell]

Yes. They really are two different animals. If you are going to do this you'll have to either provide a 97 "runtime" version (developers edition...$$$) or convert a copy of yours to 2000. When you do you will have to go to any Visual basic module, select tools-references. You will no doubt need a reference to MS DAO 3.6 Object library in order for the new database to compile. You may have to adjust its priority (move its order up or down in the "stack" of references.) You might first look at the order of things in your 97 version, then make the 2000 and try to duplicate it. Remember 8.0 in 97 becomes 9.0 in 2000 and 3.5x becomes 3.6. (you get the idea). Gord
ghubbell@total.net

 

[dmb1]

To try and solve my problem I have installed both access 97 and access 2000 on the same computer to try and iron out all the little problems!!! I now however have a new problem - the switchboard manager does not seem to be in my version of access 2000 and my database has a switchboard and therefore it is not running in access 2000.

Any help will be great

dmb1

 

[ghubbell]

You have all the same gizmos in 2000 and then some...I have seen soooo many problems running the two on one computer that I outright refuse to do this, and run two computers instead. (The second is a real heap but just to make the point...). I will highly recommend to bite the bullet, rip 97 out of your computer, then maybe office altogether (take care if it's an update that you still have a 97 disc) and reload. 2000 should be able to handle 99% of your conversion without error, but believe me I have never seen the two "co-habitate" very well. Oh BTW, once it's a true 2000 Db, you can "convert to prior version" at the click of a button. Gord
ghubbell@total.net

 

[Garyeag]

Join the Club,

Trying to use an Access 97 database on Access 2000 has completed screwed up my Access 2000. I am locked out of it and none of the passwords are valid, I can't get adminstrator tools, I can't even create new databases.

I've tried reinstalling Access and the whole of Office even but it keeps rebuiding itself and the same errors are coming up time after time. I think the rebuilding bit is due to Windows ME and Norton's protected recycle bin - at every fresh boot the sytem restore's itself.

If you come up with a solution to your problem I would be grateful to know what you learnt and I'll send you something if I work out what the hell is going on.

I don't have Office 97 on my machine anymore either. It's just some kind of error converting a 97 database introduces.
Typical Microsoft really

 

[dmb1]

I think I have my just about working in Access 2000 and Access 97 the only problem I have is the switchboard!

The only way I can see to solve this is to redo my switchboard in 2000 but then it won't work in 97 or will it? is there some code I can use for the switchboard which will enable both of them to work!

 

[dlynns]

The switchboard manager for 2000 is located in the "Tools" "Database Utilities" area and has a different look than the 97 version. I have converted several large complex databases from 97 to 2000 without much trouble. It was, however, necessary to convert all the Macros to VB Code modules then go through the code and code-behind- forms to replace all the macro calls with procedure or function calls to the converted code. I

 

[ghubbell]

Hi All,
The issue going forward is not a problem but the going backward seems like there might be something. I'm home now and work entirely in 2000 here - shipped off a 2000-97 last night and the client said there's a type mismatch when running up the switchboard. I'll check this out when I'm in to work in a few hours on the true 97 computer and let you know if it's my code, or the "built in" switchboard managers code.

Gary, if you have a jammed up Db feel free to zip it and send it over and I'll bump it up to a 2000 if I can for you, (my treat). I think you might be looking at that "spring cleaning" format of your PC... but first try again with Norton disabled or removed. Gord
ghubbell@total.net

 

[ghubbell]

Ok all, here's the skinny: The 2000P built database that was back converted to 97 fails because of references: In the back convert, Access changes 2 references MS DAO 3.50 library and MS ActiveX data object... . Solution: On the 97 computer create a new empty Db, import all the objects from the convert, and it will compile like a champ. The new one has a reference to DAO 3.51 and doesn't require the ActiveX at all.

This could probably be done programmatically, or by removing the Missing references and digging around in your computer, but for small projects, this seem to be quick and easy. Gord
ghubbell@total.net