Re: ODBC problem with linked tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: david epsom dot com dot au (david_at_epsomdotcomdotau)
Date: 04/01/04 

Date: Fri, 2 Apr 2004 07:41:08 +1000

Probably if you set the database to "compact on close"
the problem will solve itself. Normally compacting
solves the problem just as well as relinking.

Linked tables save information about the table structure,
so it's not that you are doing anything wrong.

(david)

"Ron bromwell" <anonymous@discussions.microsoft.com> wrote in message
news:16f5601c41820$288c4d00$a301280a@phx.gbl...
> I have an Access database that has linked tables to the
> tables in my oracle DB. Every time I make a change to the
> database and send it to the users, they have OBDC
> failures until I re-link the tables. Any ideas on how I
> can elevate this problem?

Relevant Pages

  • Re: Question about Re-Linking Tables from Backend
    ... Your code seems to be going into a pausing loop and then closes the form. ... Use the form's Timer event to run the relinking code. ... to 10 milliseconds in one of my database files. ...
    (microsoft.public.access.devtoolkits)
  • Re: Specifying path to linked tables
    ... startup form must be unbound. ... Form_Open event, open the real startup form after the relinking, and cancel ... > that starts up when the database is started: ... > Dim strFileName As String ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Relink tables questions
    ... For example, the network is down, a network admin changed ... circumstances that would make relinking necessary. ... present users with a dialog for selecting the correct database file. ... If your code returns an error, you know that the data file is not ...
    (microsoft.public.access.formscoding)
  • Re: Relink tables questions
    ... For example, the network is down, a network admin ... circumstances that would make relinking necessary. ... present users with a dialog for selecting the correct database file. ... If your code returns an error, you know that the data file is not ...
    (microsoft.public.access.formscoding)
  • Re: Issues relinking to backend tables
    ... database, since you know its path before you start relinking; ... Although I suppose it might be necessary to actually open a recordset on ... a table in that database. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)