Question How on earth do I change the file extension to .accdr?

[CarysW]

Am I being stupid again? All the resources on the net just say 'simply change the file extension to .accdr....but HOW??!!

 

[Kryst51]

Right click on the file, click "rename" and change the extension there maybe?

I don't know if anything could be that simple though, so I could be wrong.

 

[CarysW]

Right click on the file, click "rename" and change the extension there maybe?

I don't know if anything could be that simple though, so I could be wrong.

Tried that, I just end up with 'myDB.accdr.accde'

 

[Kryst51]

Try changing to accdb and from there to accde. When I googled it I come up with sites that talk about changing accdr to accdb. And the Accde is done from accdb. Just an idea. I don't know if it will work.

http://www.informit.com/articles/article.aspx?p=726132&seqNum=9

You can convert any Access 2007 .accdb database to an .accde file by opening the file, clicking the Database Tools tab, and clicking the Make ACCDE button to open the Save As dialog. Navigate to the location for the .accde file and click Save to create and save the file. Then close the dialog.

The problem with .accdr files is that users quickly discover they can simply change the file extension from .accdr to .accdb to regain lost design and navigation features.

 

[CarysW]

I'm completely stumped by this now.

 

[Scooterbug]

By default, when you use windows explorer there is an option checked that hides known file extension types. This is why when you rename it you wind up with

'myDB.accdr.accde'

To turn on the option to see all known file extensions, In the Windows Explorer window, go to Tools --> Folder Options. The setting is under the View Tab.

 

[CarysW]

Thankyou Scooterbug. I knew there would be a simple stupid answer.

 

[Reza]

Nobody seems to have a sensible answer to this question.