link workgroup database

[Ronald_yoh]

anyone knows how to link a table in access if the source table is in the workgroup database (.mdw)?

e.g. database A = a.mdb and database B = b.mdb; b.mdw. how do i create a link table in DB A pointing to DB B?

[CreganTur]

This may be a stupid question, but have you used: File -> Get External Data -> Link Tables?

[Ronald_yoh]

dude... ur answer's absolutely stupid!!!.... i wouldn't ask for that freakin' simple question.. i'm not a newbie here!!...

the thing is the DB B is in workgroup... you need to have the right permission to link the table from DB B!!!

NOTE: Mind your language.. mate..!!!

[CreganTur]

dude... ur answer's absolutely stupid!!!.... i wouldn't ask for that freakin' simple question.. i'm not a newbie here!!...

My suggestion was not intended to insult you. I don't use Access's workgroups to manage my databases (for various reasons), so I am not familiar with them. I can understand your frustration, but I really did not appreciate your response.


anyone knows how to link a table in access if the source table is in the workgroup database (.mdw)?
A little google time took me to this thread (http://www.mdbmakers.com/forums/showthread.php?p=114800) that will help you link to your MDE.

[Ronald_yoh]

mate.. sorry.. was just too many pressures at work and been trying to get this solution for more than a month....

we're cool mate....

cheers...