View Single Post
  #8  
Old October 24th, 2009, 12:30 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Making a Database for 14,000 providers in Access 97 need resou

On Fri, 23 Oct 2009 15:16:01 -0700, Taking On A Big Job
wrote:

This info is coming from a access database and we can only have the data
because the county owns the database. Your input is not so helpful but
thanks. How did you get to where you are? You learned it and so will I. I can
do anything I put my mind to and I will.


Well... if you already HAVE the database you can use it... link to it from
another Access database perhaps. You can use File... Get External Data... Link
to connect your local database to the county database, so long as both
databases are on the same fast, stable network (this will NOT work over the
internet or over a Wide Area Network).

Perhaps you could explain the business purpose of the database, how the county
database comes into it, and the work environment (i.e. are you in the same
office as the county's database, or at a remote site)? Do you need real-time
connection, or would daily or weekly updates suffice (and would they be
available from the county)? Do you need just read-only data, or do you need to
record or update information?
--

John W. Vinson [MVP]