Anyone regularly using Access .mdbs for reporting?

[DonHD]

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?

[DonHD]

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