Sorry

[GizmoT]

I know that this has been broached before, but..... some of the responses are a bit technical for me.

I have been told that I need to upgrade from A97 to A2002.

The computers that we have all came with Office97 already installed, so I have no idea about licenses etc... etc.

Bearing in mind that I am not exactly computer literate, could someone explain what problems I might encounter (in plain english) converting our databases over, or just using A2002.

 

[namliam]

Well you can have a multitude of problems or no errors at all, depending on the state of your DB and the programming has been build.

For instance, if you have some VBA coding:
dim rs as recordset
This will become a problem because 2002 has ADO as well as DAO (different additions to handle data) whereas 97 only had/has DAO. All this will have to be changed to DAO.recordset to disambiguate

This is one of the most commen onces but there are many more potiential hazards. Testing is a MUST before changing over.... if your no expert, and have no one in your company that is, and have many DB's to migrate it might be necessary to get an expert to help you.

Licences i am sorry but dont know anything about....

Regards

 

[GizmoT]

EEK - you mean everywhere it says

dim rs as recordset

it will have to be amended? Ouch!!!

 

[namliam]

This can be done by a simple search and replace... there also is another way by re-doing references and stuff (bit to technical maybe?) but its good practice to do this and prevent posible future problems....

More problems like this one can be solved quite easily (if you know where to look)some unfortunatly are a lot harder to crack/trace...

Regards