Thanks all for responding to my message, yes i may have needed to clarify my question a little better, but i also drew out some answers from perspectives i didnt think of, i have the need to do several things, link from FB tables to external DB's or link inside the one FB Database or link across several FB DB's, I see that there are some clear differences in what i am use to with Access to Firebird, so i will continues to look at it further.

Craig.

-----Original Message-----
From: Lee Jenkins [mailto:lee@...]
Sent: Friday, 20 August 2004 11:25 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Linking Tables in Firebird

> Hi All,
>
> I must ask this silly question, suppose i am converting an Access DB which

has linked tables, does firebird have an equivalent setup or is this
performed in another manner ?

>
> Craig
>

Hi Craig,

Yes, you can link Firebird tables from Access. I do it all the time to
generate query templates that I can tweak later on. What you need is an
ODBC driver. I use the one from XTG Systems
( http://www.xtgsystems.com/linux/ofbodbc/about.php) which seems to work
best with Access (at least from my exp.). I'm using Access2K to do this,
but.... Once you have the odbc driver setup and a entry to your firebird
DB, open access and choose File > Get External Data > Link Tables. Just
choose ODBC as the datasource and choose your ODBC entry from the list
shown. If you need more help, Craig, just email me privately.

When you link the tables, be sure to indicate a good primary key index when
asked, if you plan on editing tables through access. With that said, the
only thing that I use Access for any more is its QBE GUI which I believe is
quite better than 3rd party query builder tools I've seen for IB/FB (well,
short of being wealthy enough to hire Helen to sit by my desk and write my
queries for me :) )

Everyone else, Access uses Link Tables to well......link tables from an
external database and treat them as if they are part of the Access DB
itself. I've not ever used that myself other than the purpose I explained
above :)

Warm Regards,

Lee



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129fk9194/M=298184.5285298.6392945.3001176/D=groups/S=1705115386:HM/EXP=1093095096/A=2319498/R=0/SIG=11thfntfp/*http://www.netflix.com/Default?mqso=60185352&partid=5285298> click here
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2319498/rand=315906462>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .



_____

Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.
http://www.mailguard.com.au






[Non-text portions of this message have been removed]