Why Re-Link causes Corruption

[DavidS]

My Access 2003 db on Win xp (on network) get's corrupt (MSysObjects) every
time I re-link my tables to a Data *.mdb in the same DIR on the network.
I do Have a mixture of linked tables, local tables and ODBC Oracle
Thanks for any help!

Simple programs work fine before I do the re-link and crash after it!

 

[John Spencer]

How are you doing the relink?
Are you using code? I assume so since you posted here.
What code are you using?

Does the code distinguish between Access linked tables and Oracle tables
when it does the relinking?

If you do the relinking using the built-in menu item do you get the
corruption?

I am a long way from being an expert on relinking - especially to Oracle
tables, but I think you would need to supply at least the above information
to get help.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[DavidS]

No Code, Just linked table manager
I'm refreshing linked tables after a copy from my local PC to the network

 

[John Spencer]

I'm stuck. DO you know if the Oracle tables are causing the problem or the
Linked Access tables or both?



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[DavidS]

John,
Oracle is not it, I've tried it on a db with no links to Oracle
I believe it's a corrupt report, that when I re-link is somehow cauing the
prob in msysobjects

When I opn the table Msysobjects it's tell me it's corrupt and the db is
useless

 

[John Spencer]

You might take a look at the following URL's and see if you can rebuild the
database to get rid of the corruption.

Try Allen Browne's article on Recovering from Corruption at:
http://allenbrowne.com/ser-47.html

Also take a look at Tony Toews site
http://www.granite.ab.ca/access/corruptmdbs.htm

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Manny]

I am using code to do a relink and I found a problem when looping through the
tables that mysobjects would bomb it's a hidden table and I don't know if it
can be linked to an external db. These table exist for each db and trying to
connect to an external db's sys tables might be the problem.

Manny

 

[Douglas J. Steele]

Your relinking code should only be looking at tables where the Connect
property is a non-zero length string. Alternatively, you can look at the
table's Attribute property and omit the System tables:

Dim dbCurr As DAO.Database
Dim tdfCurr As DAO.TableDef

Set dbCurr = CurrentDb()
For Each tdfCurr In dbCurr.TableDefs
If (tdfCurr.Attributes And dbSystemObject) = 0 Then
' it's not a system table

End If
Next tdfCurr
Set dbCurr = Nothing

 

[Manny]

Thanks Doug, I did end up finding the code to test for the link attribute, I
was hoping to help David with his corrption problem. I believe you can't
link the object tables do you know if that's true?

Regards,

Manny

 

[Douglas J. Steele]

You shouldn't link any of the system tables.