so while trying to convert to mdb format, I had to delete data macros, and then I realized, it was working!
apparently this is causing problems, I started with a template, which had built in macros, I must have broken this one:
Products: Before Update
<?xml version="1.0" encoding="UTF-16"...