I did this successfully a long time ago, but I can't remember how. I have recently saved an old Access mdb file under a new name, because it had all the references I needed for the VBA code I write. However, the system still prompts me with the old name on the Debug Menu, i.e. "Compile OldName". Can anyone tell me how I can rectify this? Many thanks.

I did this successfully a long time ago, but I can't remember how. I have recently saved an old Access mdb file under a new name, because it had all the references I needed for the VBA code I write. However, the system still prompts me with the old name on the Debug Menu, i.e. "Compile OldName". Can anyone tell me how I can rectify this? Many thanks.

• database
• ms-access
• rename

3 Answers 3

• Open the VBE
• Click at top-left in Project on the project name
• In the properties box below, click property Name
• Edit the value of this to the name you prefer

Well I finally found the answer myself. I had to open a code window and click on the Tools menu. This revealed a list containing References... Macros... Options... and (wait for it) Oldname Properties... and when I clicked on this last one it opened a rather boring page with a number of text boxes, the first one being labelled Project Name. This contained the old name, so I entered the new name.

Seemed a rather silly place to hide this information, but then it is a Microsoft Application so one shouldn't be too surprised.

By the way, when I clicked on the link in the email I received from Stack Overflow, it led me to a login page where none of my saved passwords worked. Eventually I tried going to https://stackoverflow and found I was automatically logged in straight away! I'll never understand web security...

If you want to change the shown name, you can go to File - Options and in the section for the current DB you can change the title.