Unable to delete or change name of database

[leroyd]

I have tried to rename or delete in MS Explorer, but this just creates confusion. The databases still show up in bits and pieses on various screens. I've purchased 2 additional how to do it books on MS Access 2007 and find nothing on deleting or renaming an entire database and all objects or references to it. Does anyone know the magic bullet?

 

[DJkarl]

To my knowledge there is no "magic bullet" when it comes to changing a file name. If you have tables in other databases linked to the database you're changing then you will have to manually or programmatically update each of those links.

My question to you is why would you have to rename files often enough for this to be an issue? I seldom change the name of a back-end database, what's causing you to have to do this on a regular basis?

 

[leroyd]

Normally I wouldn't change the name of a database if I could just transfer the old data into a newly created database and delete the old database entirely; that would work. I just can't figure out how to completely delete the old database.

While trying to figure out how to use access (I'm an old MS Works user), I created some practise databases that I don't need. Now I don't know how to get rid of them or redesign them into something useful and change the names.

 

[boblarson]

If you delete them in Windows Explorer, they are gone. If you are talking about that they still show up in the recent documents list when you go up to File or in the task list, you just have to open enough other ones to knock the names off of the list