Hi,

I am currently having a problem where on occasions, my linked tables -
oracle tables reference in MS access - are being deleted. It appears to be
completely random so I am unsure of what the cause is or even how to
replicate it.

The purpose of the form I am currently using is to simply import data from
an Access database into a oracle one using an ODBC connection. I have a
feeling it may be due to the "Compact and Repair Database" function which I
execute quite often (approx 1 per week), however I was unable to replicate
the error when I was testing.

Although the fix is fairly simple, I am still concerned about what may be
causing the link table reference to be deleted.

Does anyone have any suggestions?

Thanks in advance,

Aki

Hi, Aki.

Do you have VBA code that hides these table links? Specifically, do you use
the dbHiddenObject or DB_HIDDENOBJECT attributes to hide these links? If so,
these attributes hide the TableDef Object by marking the object for deletion
upon the next compaction in older versions of Access. The user doesn't see
the linked table in the Database Window, but it's still there until the next
compaction.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.


"AkiTo_G" wrote:

> Hi,
>
> I am currently having a problem where on occasions, my linked tables -
> oracle tables reference in MS access - are being deleted. It appears to be
> completely random so I am unsure of what the cause is or even how to
> replicate it.
>
> The purpose of the form I am currently using is to simply import data from
> an Access database into a oracle one using an ODBC connection. I have a
> feeling it may be due to the "Compact and Repair Database" function which I
> execute quite often (approx 1 per week), however I was unable to replicate
> the error when I was testing.
>
> Although the fix is fairly simple, I am still concerned about what may be
> causing the link table reference to be deleted.
>
> Does anyone have any suggestions?
>
> Thanks in advance,
>
> Aki