1 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Updating the tables in NBNData.mdb

I have the need to add more linked tables to the NBNData.mdb to write a query. The problem is I can't see how the connection has been made in the first place as there are no  data sources apparently linked to the MDF.

If I create one on the server and link to the tables I want then the access db no longer works. I'm guessing there is another way to do this. Do you know how. Another solution would be an updated version with links to the new tables in Recorder 6.

Any ideas welcome.

Tony

Data Manger
Somerset Environmental Records Centre

TonyP's Website

2 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Updating the tables in NBNData.mdb

I've never had a problem doing this Tone

I work on a converted (to 2000) copy of the Access 97 db and have added Recorder 6 as a machine datasource and it seems to be quite happy to let me link additional tables via odbc.

I might be around friday afternoon if you want to call me about this

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website