Hi,
I'm converting numerous version 2 backend databases to XP.
They have lots of tables, but only a couple of forms and a single module.
I have been trying to use ConvertAccessProject as detailed in Technet and it works apart from the module which does not get copied across to the new database.(tables,queries,forms and macros are all there)
Application.ConvertAccessProject _
SourceFilename:=strOLDDB, _
DestinationFilename:=strNewDb, _
DestinationFileFormat:=acFileFormatAccess2002
Anyone know why ?
I can do a transferdatabase afterwards to copy the module acress, but then the references are missing.
(P.S all the frontends have had to be converted manually via 97 as there was so much code problems - I would be great not to have to repeat this for the data as well!)
Thanks
Ruppie
I'm converting numerous version 2 backend databases to XP.
They have lots of tables, but only a couple of forms and a single module.
I have been trying to use ConvertAccessProject as detailed in Technet and it works apart from the module which does not get copied across to the new database.(tables,queries,forms and macros are all there)
Application.ConvertAccessProject _
SourceFilename:=strOLDDB, _
DestinationFilename:=strNewDb, _
DestinationFileFormat:=acFileFormatAccess2002
Anyone know why ?
I can do a transferdatabase afterwards to copy the module acress, but then the references are missing.
(P.S all the frontends have had to be converted manually via 97 as there was so much code problems - I would be great not to have to repeat this for the data as well!)
Thanks
Ruppie