Hi Fabio,
Yes, I want 1 table shared by 2 or more databases of several copies of my application (without additional programming). The table name and database names are equal. However it doesn't work because the database stores the path name to the table and the table the path back to the database (backlink). Therfore it isn't possible that a table can belong to two databases at the same time.
However I found a very simple work around. A Windows NTFS file system supports so-called symbolic links (like Unix). There is a programme called FSUTIL (comes with XP and is available for W2K). You can easily have one table file appearing at different locations of the hard disk and belonging to different databases. The only thing you must make sure is not to delete (PACK or SDT) the table.
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/fsutil.mspxAndreas
>>>Yes! For any N>1 databases
>>>A simple trick and this Conditions:
>>>- W2k or superior
>>>- all N databases have same name
>>>- exists two partitions ( on first you put databases, and on second the table )
>>>
>>>But this is not a good programming style, and is not usefull.
>>
>>Hi,
>>
>>what do you mean with 2 partitions? I have the same problem. There are several copies of the application but now they want to share one of the tables. Obviously the database names are the same. I want to avoid to change the application and put this table into a new shared database.
>>
>>Andreas
>
>A lot of time has passed.
>Tell me,
>do you want to have two database with the same name that they use the same dbf table?
>
>If the databases have different names, then it is not possible.