Why Re-Link causes Corruption

D

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!
 
J

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
..
 
D

DavidS

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

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
..
 
D

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
 
M

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
 
D

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top