Hello @Rokank ,
you can connect to Microsoft Access Database from KNIME Analytics Platform using the [Microsoft Access Connector Node] (Microsoft Access Connector – KNIME Community Hub) although there are not KNIME related limitation of this connection such as the MS Access Database size. Please check this post and the links included for further reference.
What I would suggest to test it first locally by downloading the access file manually. This would be a first indication if it could work in general.
Good luck!