linking tables in FileMaker 4.1 (Mac) and MSAccess97


TDash(TDash[at]edc.org)
Tue, 8 Jun 1999 17:38:29 -0400


WinMac Digest #335 - Tuesday, June 8, 1999

  DAVE remote to NT
          by "Blair, Hamish C" <hblair@kpmg.com.au>
  Print spooling off an NT Server
          by "Michael Eilon" <mgeilon@geocities.com>
  Re: [WinMac] Print spooling off an NT Server
          by "Stuart McClean" <stuartm@atlantis.es>
  RE: Flashing Question Mark
          by "Kimmey, Dennis" <DKIMMEY@IGC.com>
  linking tables in FileMaker 4.1 (Mac) and MSAccess97
          by "TDash" <TDash@edc.org>

Subject: DAVE remote to NT
From: "Blair, Hamish C" <hblair@kpmg.com.au>
Date: Tue, 8 Jun 1999 10:33:17 +1000
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"

Thanks to all who replied to my previous post.(its a bit long, so skip to
next message if not relevant to you)

I successfully connected over the weekend to download my football tipping
file. History was achieved on the weekend, with Tony "Plugger" Lockett
kicking his 1,300th career goal, an all time record, besting the previous
all-time record of 1,299 career goals held by Gordon Coventry. The record
stood for over 60 years. Check it out at
http://www.afl.com.au/7newsafl/plugger.htm

Anyway, here is what I did

1. Created a new configuration in AppleTalk and TCP/IP called Remote Access
(DAVE)

        AppleTalk -> connect via PPP
        TCP/IP -> configure via PPP and DHCP

2. Create a location via location manager (hey, I assume the multiple login
technology in Sonata will extend this highly useful control panel) called
Remote Access. I set it up to point to the above AppleTalk and TCP/IP
configurations (as well as a special Conflict Catcher set of extensions and
control panels - ensuring my modem and remote access control panels are
activated)

3. Reboot with the new location. Ignore the NetBIOS not working error
message

4 Activate the Remote Access Control panel and type in the telephone number
of the remote location. Make sure that "connect to a command line host" is
selected in the options tab.

5. Login screen comes up, much same as if dialling into and ISP. Type in
my username and password. Then type in PPP to activate the connection via
TCP/IP

6. Go into NetBIOS control panel to make sure an IP address is
obtained.

7. Use DAVE as would normally to mount servers etc.

8. Boot Outlook to see if works - YES!!! I can read email remotely

9. Boot Internet Explorer to see if can surf :-( No can do. Try to look
for volumes in the chooser and none there - which may explain why IE 4.5
can't see the proxy server.

10. Disconnect in the remote access control panel

11. Boast to wife about my legendary status. She nods knowingly and says
"Yes dear, its a good thing you have friends like Dan and Alex to help you"

Cheers

Hamish Blair
Melbourne, Australia

"This email is intended only for the use of the individual or entity
named above and may contain information that is confidential and
privileged. If you are not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
email is strictly prohibited. When addressed to our clients, any
opinions or advice contained in this email are subject to the terms
and conditions expressed in the governing KPMG client engagement
letter. If you have received this email in error, please notify us
immediately by return email or telephone +61 2 9335 7000 and destroy
the original message. Thank you."

Subject: Print spooling off an NT Server
From: Michael Eilon <mgeilon@geocities.com>
Date: Tue, 8 Jun 1999 16:26:02 +0800
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,

apparently, Win95/98 PCs can't directly print to Apple LaserWriters
(although WinNT workstations can), so usually we have a WinNT server to do
the job (connect to the printers and share them across the network).

Ironically, both our NT workstations and Macs (who don't need the
functionality) can see the printers shared on the NT server, but none of
our Win95 PC (who do need to functionality), can! (Although they can see
the server and shared folders OK.)

The server is running NT 4 SP3, and was able to do the job OK a couple of
weeks ago (before the HD died and we re-installed it on the current
machine). Pretty much everything else works OK, just not the print
spooling.

I don't think applying SP5 will solve this problem since it worked fine on
the old machine (identical hardware to the current one) with SP3. Could it
be that going straight from SP1 to SP3 without first applying SP2 is the
problem? (There was a thread recently about how the service packs are
cumulative.)

If so, how does one apply SP2 retroactively once SP3 has already been applie=
d?

If not, are there any ideas as to what the problem could be?

Cheers,

Michael Eilon
Assistant computer manager
Dept. of Physics
University of Western Australia

Subject: Re: [WinMac] Print spooling off an NT Server
From: "Stuart McClean" <stuartm@atlantis.es>
Date: Tue, 8 Jun 1999 11:14:25 +0100
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

This is almost certainly not a service pack problem as the service pack
content is
cumulative therefore missing SP2 and using SP3 is fine. Have you reinstalled
the
WIN95/98 drivers for the Apple LaserWriter this sounds more like the route
to your
problem.

Stuart

-----Original Message-----
From: Michael Eilon <mgeilon@geocities.com>
To: The Windows-MacOS cooperation list <winmac@xerxes.frit.utexas.edu>
Date: 08 June 1999 09:29
Subject: [WinMac] Print spooling off an NT Server

Hi all,

apparently, Win95/98 PCs can't directly print to Apple LaserWriters
(although WinNT workstations can), so usually we have a WinNT server to do
the job (connect to the printers and share them across the network).

Ironically, both our NT workstations and Macs (who don't need the
functionality) can see the printers shared on the NT server, but none of
our Win95 PC (who do need to functionality), can! (Although they can see
the server and shared folders OK.)

The server is running NT 4 SP3, and was able to do the job OK a couple of
weeks ago (before the HD died and we re-installed it on the current
machine). Pretty much everything else works OK, just not the print
spooling.

I don't think applying SP5 will solve this problem since it worked fine on
the old machine (identical hardware to the current one) with SP3. Could it
be that going straight from SP1 to SP3 without first applying SP2 is the
problem? (There was a thread recently about how the service packs are
cumulative.)

If so, how does one apply SP2 retroactively once SP3 has already been
applied?

If not, are there any ideas as to what the problem could be?

Cheers,

Michael Eilon
Assistant computer manager
Dept. of Physics
University of Western Australia

* Windows-MacOS Cooperation List *

Subject: RE: Flashing Question Mark
From: "Kimmey, Dennis" <DKIMMEY@IGC.com>
Date: Tue, 8 Jun 1999 07:56:55 -0400
MIME-Version: 1.0
Content-Type: text/plain

>Have you tried running Norton Utils on the drive. When you boot from your
>CD, when the volume asks to be initialized, say no, and try to get it to
>mount with Speed disk. If you can get it mounted, you can probably run
>speed
>disk or at least recover files.
>Good Luck
>begum

I happened to have a Norton 3.5 CD, which I loaded onto an external hard
drive containing a universal install of Mac OS 8.1 (so I can use it to boot
040, as well as PowerMacs), then patched Disk Doctor to v3.5.2. Booting from
the external drive still displayed the "the disk is unreadable, do you want
to initialize it?" message. I hit cancel (of course), Only the external
drive appeared on the Desktop. I launched Disk Doctor, which did show the
missing hard drive, then found & fixed a slew of problems. As to what caused
it, "Warn about improper shutdown" was checked, and I'm almost certain Drive
Setup v1.6.2 was applied prior to the 8.5.1 update. I did notice Virex was
at version 5.8.1 and remembered problems were reported in this list a while
back when copying to NT Servers, so I upgraded Virex to 5.9.1.

Thanks for everyone's suggestions!
- Dennis

Subject: linking tables in FileMaker 4.1 (Mac) and MSAccess97
From: TDash@edc.org (TDash)
Date: Tue, 8 Jun 1999 17:38:29 -0400
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

One of my colleagues would like to use the Link Tables feature of Microsoft
Access97 to connect directly to a table inside a FileMaker database. We have
several related questions:

Let's assume for the sake of simplicity that the FileMaker database is
maintained by a Macintosh user and resides on a Novell drive that accommodates
both Mac and PC. Is it theoretically possible to link a Windows 98 client
running Microsoft Access97 to the FileMaker table? If so, what must we install
or configure in order to make this work?

Now for the real situation: The FileMaker database is maintained by a Macintosh
user and resides on a Macintosh workstation running FileMaker server software.
(I believe that this Macintosh is *not* an AppleShare server.) Is it
theoretically possible to link under these circumstances also? What would you
recommend as the simplest strategy for doing so?

Thanks in advance for your help,
Terry Dash
tdash@edc.org

* Windows-MacOS Cooperation List *



This archive was generated by hypermail 2.0b2 on Tue Jun 08 1999 - 17:13:28 PDT