User Support Forum

I wished to make a report on a table join not included included in the package. [See thread in Membership on "Offices Served"] I have made an Access export and built relationships and a query. When I re-export later with updated data the relationships and query previously built are gone. I have no wish to redo them each time and certainly would not expect our office admin to do it. I can save a relationship "object" but don't see what to click to re-import it. Would rather avoid learning VBscripting.

If anyone is regularly using Access, how do you "can" the procedure?

Anybody ever "split the database" so the relationships and queries are in one database and the "backend" could be the PC exported one?

http://office.microsoft.com/en-us/acces ... 42026.aspx