Relocate and update database

[widman]

On the Excel forum I'm sent to the Access Forum, and on the Access Forum to
the Excel forum... Maybe it is a basic Office question as to how things are
arranged.

I use a softare that was written in Access. I don't have direct access to
the real database, but it has a funcion with a query that creates an
accesable database for the time period or tables that you request.

I copied that database to my notebook and imported three sheets into Excel,
where a 4th sheet extracts, summarizes, etc. the information from those
tables. I see that Excel (or windows or access) created copies of those
tables in a folder called "my Data Sources".
Three questions:
1. How can I transfer this (and it's sources) to my accountant's computer
in the office so he can update it monthly?
2. When you click "refresh data" in Excel, does it just refresh from "My
Data Sources" or does it cause those tables to be updated from the original?
3. If it only refreshes from the tables in "my data sources", how do I
refresh those tables?

 

[Bob I]

Contact the folks that wrote the software. They would know where and how
the access and updates are handled.

 

[widman]

They told me for $750 they would tell me.

Anyway, by trial and error I figured it out. Type in a new address when it
can't find the right one. Would have been nice if MS had given a "browse
button"

 

[Bob I]

Ahh, "MS" did provide a "Browse" button, perhaps the issue is the
customization done to the interface.