Right - the full path IS the only relative path to a different drive. I guess you can say at that point that it's not relative at all...
Thanks for the clarification. I'll be more careful.
>FYI, the relative path is stored in the DBC as long as the tables and DBC are on the same volume/drive. The hard path is stored if they are on separate drives.
>
>>What Mark says is true, assuming the tables and the database are in the same directory. The DBC just stores the RELATIVE path to the tables.
>>
>>If you have them in different directories, consider putting them together.
>>
>>Hint: if you close the database, and then open it as if it were a table, you can see the info it really has in it:
USE database.DBC IN 0 SHARED>>
>*snip*
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site