Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Macro to connect to Base DB

I’m trying to re create some MS Access 2007 databases in Base, so far so good, but now I am way out of my depth. I have created a Database “DPR” and it’s only table “Results” but I need a macro that can connect to the DB and then the table so it can then run some analysis, I am completely stuck on the first bit, connecting to the DB. I have read so much my brain is now fuddled. Can anyone show me what is needed. The OS is Windows 10, the DB path is “C:\Data\Base\DPR.ODB” Thanks