Setting up ODBC between FMP7 Databases - Thankyou



Hi Lynne,
As always, you have something good to say. I did not realise that I could
make Table Relationships across db's. I tried it and it is simple. Thank you
Best Regards Ron H.

"Lynn allen" <lynn@xxxxxxxxxxxxxxxxx> wrote in message
news:1h12y5z.1lqzfxg10kzgloN%lynn@xxxxxxxxxxxxxxxxxxxx
> Ron H. <ronald_h70@xxxxxxxxxxxxxxx> wrote:
>
>> Hi All,
>> I have 2 separate databases set up on a small PTP network using FMP7 for
>> both databases
>> I want to do table lookups on one db from the other db across the netwok.
>> Obviously in this case FMP7 is going to be both a Client and a Source. My
>> questions
>> 1. Because I am communicating between FMP7's only do I have to install a
>> driver
>> 2. If so where do I find the driver and how do I install it
>> 3. Do I have to install the driver in both Client and Source FMP7's
>> 4. Because FMP7 networks only allow 6 users (Host + 5 Remotes) per
>> database,
>> will a Client making a SQL request to a Source cause the user count on
>> the
>> Source machine to step up by 1
>
> Don't use ODBC between FM databases. Set them both to be multiuser, host
> them both, and do the lookups directly using the Field definitons in FM.
>
> Lynn Allen
> --
> Allen & Allen Semiotics www.semiotics.com
> FSA Associate Filemaker Design & Consulting


.



Relevant Pages

  • Re: cups - samba - frustration! - LIKE SOLVED
    ... then I went on a w2k client, connect to the printers share, uploaded the ... windows driver to the samba machine. ... you don't need to install every printer locally on windows before and need ...
    (Debian-User)
  • Re: Adding printers to NTPRINT.INF
    ... MCSE, CCEA, Microsoft MVP - Terminal Server ... > I believe that an easier way to install the drivers on the TS is ... >> signed drivers, you can install the driver on the server. ... >> autocreated the client printer. ...
    (microsoft.public.windows.terminal_services)
  • Re: How install Access app on client PCs ?
    ... Well you will have fun the multiple version of access, ... run under the other two versions, if you still have Access 97 databases, ... > installing on 50-100 client PC's. ... > initial install and when versions change. ...
    (microsoft.public.access.gettingstarted)
  • Re: Printer to a client PC on remote connection problems
    ... As other account has admin rights I install them under that account ... >corresponding print driver on sbs. ... You could install this print driver on sbs ... >the client printer redirection. ...
    (microsoft.public.windows.server.sbs)
  • Re: XP fax client doesnt connect to server
    ... Was the client you installed XP Fax? ... how did you install it and did ... you receive any error messages along the way? ... 'Microsoft Shared Fax Driver' printer driver is not installed on this ...
    (microsoft.public.windowsxp.print_fax)