External data basics

[Alan]

I need to retrieve information from our MRP program that is Access 2000
based. How do I retrieve this information in the tables without using
"linking"? I tried using the, linking wizard and the performance is
horrendous - up to 3 minutes to relink tables, 30-60 seconds to change
changes to queries and forms....

Can some one please point out the basics of how to use ADO/DAO (or other
method) to get at the information in these tables? I need to read the
information only - no write backs to the source tables (not allowed by our
MRP tech support people).

Thanks
Alan

 

[bonejn]

You could probably link the MRP program tables to a db you have locally and
create MakeTableQueries for each linked table. Base all your additional queries
and forms on the new tables. Run the MakeTableQueries whenever you need the most
current data.

 

[Alan]

I had thought of that after posting my question. It certainly is do-able
but the information in the MRP program changes so rapidly that I think I
would need to do it each time this little helper app runs. My main concern
is what happens if something has been deleted from the MRP data tables? For
example: I use the MRP tables to get employee information and someone
deletes an employee between the times that we run this helper app. Any
suggestions how to handle this probability?

Thanks

 

[bonejn]

Sorry I can't help you any further. I think you're gonna have to decide if you
want realtime info and deal with the lag or compromise realtime data for
efficiency
in running queries and forms. You probably won't get any better using Access.

Here's another option I'm currently using though.
I have copies of our company's intranet databases stored locally.
I then have my own database that has linked tables to those local copies so that
I can query and build forms. I wrote a wscript file on my desktop that I'll run
whenever I go for coffee or a break to get the latest copies from the network, I
have it scripted to make backup copies of my orginals too, just in case.

BTW, I don't ever delete employees from my db; they're either active or
inactive.

hope this helps, good luck =)

 

[Alan]

Thanks for the info.

Sorry I can't help you any further. I think you're gonna have to decide if you
want realtime info and deal with the lag or compromise realtime data for
efficiency
in running queries and forms. You probably won't get any better using Access.

Here's another option I'm currently using though.
I have copies of our company's intranet databases stored locally.
I then have my own database that has linked tables to those local copies so that
I can query and build forms. I wrote a wscript file on my desktop that I'll run
whenever I go for coffee or a break to get the latest copies from the network, I
have it scripted to make backup copies of my orginals too, just in case.

BTW, I don't ever delete employees from my db; they're either active or
inactive.

hope this helps, good luck =)