I was demoing Oracle’s migration product that does exactly the same thing (without the dumb bits) the best part of 10 years ago. The access app quite happily now talking to an Oracle back end.

I never realised that Microsoft did’t do this themselves!

Probably easier to migrate to Oracle and back again. At least it can sort out the types properly.

If memory serves Oracle’s tool is also free.