How do I export a Microsoft Access database table in to it's own *.accdb database?
When viewing the list of tables on the left column under the "Tables" category I can right-click and export but when I give it a name to save the export like "example.accdb" I get the following error message...
Microsoft Access can't find the database file 'C:\example.accdb'.
Right...because it doesn't exist, that's why I'm exporting in the first place! To create the table as a separate exported database. Am I attempting to split the table off in to another database containing that table incorrectly or is there another step I missed somewhere?