Since upgrading our pc's OS from Win95 to Win2K related files take forever to open. This database has been around as long as I have - well almost. It's hosted on WinNT 4.0 We have several other hosted newer databases that work great. I think its the relationship and the "Filespec" if your familiar with that term. I've tried re-establishing the relationships but it doesn't seem to help. Any ideas?

I notice you upgraded from Win95 to Win2K. It leads to the question: Could the computer itself be too old to handle Win2K? A client recently wanted to upgrade, only to discover that the BIOS on some of their computers was too old. It's possible that the age of the BIOS (or other components) allows some things to happen, but other things just get screwy.

It's a thought, anyway.

Dan

Thanks for the reply Dan, I've tested the database on different computers (some P4's and it's still slow) It appears to be related to the FileSpec. I've since re-established relationships and scripts links directly on the server and that has helped. I'm still curious if this is a Windows 2K issue or not. Thanks, Jeff

We have mixed network here: NT4 server, NT4, W2000, W98 clients and everything is the same. Just the HP Brio with 98 corrupted sometimes data. That is the most unreliable combo I've ever experienced.

Follow up: I believe I've solved the problem. It may not be the best solution but it worked. I renamed the files that took a long time to pull up. This means re-establishing all links to those files in Define Relationships and any scripts related to those files. Thanks, Jeff