Roy Vidar:
Putting the mdb extension in the path name solved the problem. Thanks. Stepping throught the code did not help. The database was being created, but the program would not find it if the ".mdb" was not entered in the text box. Thank you again for your help.
Thanks. I tried:
Rem Dim newDb As Object and
Rem Dim newDB As Database and
Rem Dim newDB As DAO.database.
They all did not work.
Very respectfully,
plist
I have code from an old Access 97 database that does not
work in Access 2000. I keep getting a Run-time err04 '2043' and the database can't find the newly created file. The DoCmd.Transferdatabase method does not seem to work.
I am using the statements:
Set newDb =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.