W
waynemb
I'm trying to update an mdb file that contains tables linked to my current
mdb - by renaming it, and then replacing it with an updated file. Access
won't let me rename the file, I assume because the links exist. I tried
deleting all the links, but Access still refuses, I guess because it hasn't
broken all the links and closed that file. What do I have to do so Access
will let me rename that file?
Delete all tables linked in TableSourceFile.mdb ' is this necessary?
Name TableSourceFile.mdb as RetiredFile.mdb ' rename old file
Name NewTableSource.mdb as TableSourceFile.mdb ' rename updated file
Thanks
mdb - by renaming it, and then replacing it with an updated file. Access
won't let me rename the file, I assume because the links exist. I tried
deleting all the links, but Access still refuses, I guess because it hasn't
broken all the links and closed that file. What do I have to do so Access
will let me rename that file?
Delete all tables linked in TableSourceFile.mdb ' is this necessary?
Name TableSourceFile.mdb as RetiredFile.mdb ' rename old file
Name NewTableSource.mdb as TableSourceFile.mdb ' rename updated file
Thanks