I am trying to compact and repair my database within VBA Code. I'm not sure where to start because I want to C&R a linked database. So my source file is named Source.mdb and all my tables are in Source_Be.mdb.

How can I just C&R Source_Be.mdb?