Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 24th, 2003, 10:39 AM
Ben Ben is offline
Authorized User
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access - Linked ODBC Tables

Hi all,

I am using Access and linking tables via ODBC, however the linked tables seem to be causing corruptions in my Database.

The corruptions I've had are:

The ODBC Linked Tables won't display data

The ODBC Linked Tables give a message "This action will reset the current code in break mode. Do you want to stop the running code?" Even though I have no VB in my DB

Some ODBC Linked table related queries just refuse to run

If I import the tables the errors disappear, I have tried changing the table key sets to no avail. I don't get this issue when using a different ODBS linked table

- Do all ODBC drivers support linked tables or do some just support imported tables?
- Has anyone else had this issue?
- Is it possible my drivers have corrupted and need a reinstall?

Thanks in advance

Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing Linked SQL tables in Access seran128 Classic ASP Professional 0 April 3rd, 2006 10:39 PM
ODBC - insert on a linked field - [microsoft][ODBC chimp MySQL 0 April 7th, 2005 04:44 AM
Read Linked tables in Access from VB code meggan VB Databases Basics 3 March 4th, 2005 11:26 AM
Access Linked Tables StephenDID Access ASP 6 October 6th, 2003 10:08 AM
Want to code external linked tables in Access Michael Allaire Access VBA 1 July 23rd, 2003 06:11 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.