Sharing linked tables

[JMCONNOR]

I have a couple databases that at times need to share the employee table. The problem is that both databases can't be open at the same time on the same PC. Both databases can be open and working properly as long as they are on separate PCs

The error I get is: "Couldn't use ...(path); file already in use."

The two databases in question are front ends. The back ends live on a Novell server. The PC's are XP, SP2.

Any ideas?

Thanks.

 

[IGPCS]

make sure its shared i dont see the problem is because its on 1 computer

is it that you have 2 database files with the same name?


I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[JMCONNOR]

The employee table is in the back end of database 1. Database 2 has its own back end but also links to the employee table. Different users in my workgroup can be working with one front end or the other front and there's no problem (some users can have one open and other users have the other open at the same time). The error occurs when one user tries to have both open on a single PC.

 

[IGPCS]

and the error is to witch one the one that has the back end linked or the other one?


I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[JMCONNOR]

It's apples to the DB that is linked only to the table but has its own back end.

 

[traingamer]

I have no problems at all linking (and opening) the same employee table from more than two databases concurrently. We do something quite similar here.


hmmm

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill