CurrentProject.ProjectType (Access)

You can use the ProjectType property to determine the type of project that is currently open. Possible return values are acADP - The current project is a Microsoft Access project, acMDB - The current project is a Microsoft Access database, acNull.

CurrentProject.ProjectType