Disc or network error

[Fifer]

We have recently upgraded our systems from 97 to 2003. A lot of our main info is kept in our Data db and we link our tables to this main db from all our other databases.

When I try and link these tables after converting them to 2003 i get a ' Disc or Network error' and then all the queries disappear and I have to close access and start again.

Is there anything I can do or do I need to make all of my databases stand alone?

 

[gemma-the-husky]

how are you trying to link them?

i would check the mapped drives on the computer, as that sounds like your app really cannnot see the data.

Try to link one manually, then check the connect property

currentdb.tabledefs("mytable").connect - a jet table will report
database="folowed by the path"

Jet links in A97 and A2003 are both the same.


Second, what do yuo mean the queries disppear. do you mean they just start reporting they cannot find the data/make the join etc. They will come back as soon as you get the table links fixed.

 

[Fifer]

I have tried to manually link the tables and to use the link manager, I think it may be because our main db is so huge .

You have to forgive me as I am not totally up to speed with coding :
'currentdb.tabledefs("mytable").connect - a jet table will report
database="folowed by the path"'
What does that mean and where do I go to check this.

Sorry

 

[gemma-the-husky]

it doesn't matter about the connect - its just code to put in a module.

BECAUSE

if you can't link the table manually, then you really do have a network issue.

can you navigate to the database on the backend server in windows explorer/my computer?

 

[Fifer]

I think it may be to do with the size of one particular table that I have.

When you say 'backend server' Im not sure what you mean. The person who built our dbs buit a Data db, Import db and a System db, so im presuming that the data db is the back end as that is where all our tables are linked to.

Went into a smaller db today which I mind stand alone and the network disc error reared its ugly head on this now. as soon as I get that error, my tables and queries vanish and I have to close and reopen access. this is pants!!!

 

[gemma-the-husky]

with a lniked table. your dbs will be trying to get the information from another database on your network. It can't find this because it says there is an error.

i expect there is a real network error that would prevent you finding the correct file using (say) my computer or windows explorer.

Perhaps you have different letters for the mapped drives on this computer.

 

[Fifer]

I escalated this to our IT dept, and they think!!! it might be to do with our network migrating to xp and some mirroring stuff going on. So Im told that when all our stuff migrates over then we wont know for definate if I can get these db's working successfully. Thanks for your help on this. I may be back in a few weeks when it definately goes wrong!!!