All data lost when renaming .mdb file!

[Harmough]

I'm using a DAO connection with Access 2000 and now I have a little problem. When I first close a connection with a 'generic.mdb' file using the data1.database.close method, then rename the 'generic.mdb' to, for example, 'other.mdb' with the 'Name oldfile As newfile' statement, then reopen it with the data1.databasename=...etc etc , all the data in the 'other.mdb' file is lost!

What am I doing wrong?

Dave.

[barrk]

Not sure about Access 2000 but in the older versions you had to rename the library (ldb) too. Maybe that would help?