I have created a program in XP using
dim cnn as new Access.Application
cnn.opencurrentdatabase "Database path"
Then using
cnn.docmd.transferdatabase acimport "ODBC", etc.
to import data into the open database.
This is working well.
When I try to run this program on an Access 2000 database it will accept - dim cnn as new Access.Application but will not do the second line of setting the location of the database.
When I originally used this code I required the msjro.dll and I have updated this in the Access 2000 database.
Can anyone help please
dim cnn as new Access.Application
cnn.opencurrentdatabase "Database path"
Then using
cnn.docmd.transferdatabase acimport "ODBC", etc.
to import data into the open database.
This is working well.
When I try to run this program on an Access 2000 database it will accept - dim cnn as new Access.Application but will not do the second line of setting the location of the database.
When I originally used this code I required the msjro.dll and I have updated this in the Access 2000 database.
Can anyone help please