Running access 97 macro through access 2000 db

[Jshipley45]

Is there anyway to run a macro I have in a 97 database from a 2000 database? My problem is the sorting created in the 97 db doesn't sort correctly in the 2000 db (I think because of unicode problems) so I was going to run the macro to update the tables in 97 and create a sequence field So I could correctly sort the tables in 2000....

[ctaylor]

Try replacing periods with exclamation marks in your macro instructions in order to get the code to run within MS Access 2000.

i.e [forms].[frmMainMenu].[txtStartDate]

should be written as

[forms]![frmMainMenu]![txtStartDate]

If you were to provide more detail about the macro, I might be able to help you convert it to MS Access 2000 syntax.

(I have never tried to run MS Access '97 macros from MS Access 2000. Personally I would want to fix the macro to work with MS Access 2000)

[Jshipley45]

the problem isn't in a macro... the problem is how access2000 looks at strings vs access97. My company uses a sort string to sort our partnumbers in correct order. This sort string works fine in access97, but does not sort the same way in access2000