Split database - ACCDE

[ItsMe]

Perhaps you can adjust some settings in your Operating System, e.g. W7, XP Pro, etc.

You can view file extension by adjusting settings in "Control Panel">"Folder Options".

[June7]

As ItsMe says, if you cannot see file extensions, change view settings in Windows Explorer. Another way to find is from Windows Explorer > Organize > Folder and Search Options > View > uncheck Hide extensions

Then click Apply to Folders.

[Sheba]

Thank you June7 and ItsMe. I fixed my settings and have changed the extension from '.accdb' to '.accdr' but now, I can't create .accde.
I get an error message: "Microsoft Access was unable to create the .accde, .mde, or .ade file"

Could you advise on how to fix this please?

[ItsMe]

The purpose of accdr is to simulate dependence of Run Time and independence of Development Time. Change your file back to accdb before creating your accde.

[Sheba]

Hi ItsMe. I changed the file extension back from .accdr to .accdb before trying to make it .accde. That is when I got the error message

[ItsMe]

Be sure to Compile your VBA before attempting to create an accde. From the VBA editor, Debug>Compile Database.

[Sheba]

It worked. Very much appreciated. Thank you for your helpful tips.