Sorry for the confusion, had read though it before sending, but not well
enough.
This line:
- Off2k machine (1 each) - Converted Access 2000 machine to 'prior Access
version'
Should read:
- Off2k machine (1 each) - Converted Access 2000 DATABASE to 'prior Access
version'
The original db was created in Access 2000 then moved to 4 different Access
97 machines. On all 4 machines the 'Create Linked Table Wizard' WAS working
BEFORE loading the converted Access 2000 db, and NOT working AFTER loading
the db.
If I can provide any more confusion, please let me know. ;-)
Thanks again
John
-----Original Message-----
From: Jim Meagher [mailto:[log in to unmask]]
Sent: Wednesday, August 30, 2000 6:01 PM
To: [log in to unmask]
Subject: Re: [PCSOFT] MS Access Linked Table Problem
John,
You are still loosing me (us?) with the "converted Access 2000"
do you mean a database designed in 2k and then converted down
to 97? or do you mean a PC with Access 2k that was somehow
converted back to 97 (or 95???)
I suspect that in any case, this is where your problem lies.
Try loading the WHOLE data file into one of the pure Access 97
machines and save it. Then try your link with only other pure
Access 97 systems. Keep the converted machine out of the loop
and see what happens.
Jim Meagher
----- Original Message -----
From: "Sanborn, John" <[log in to unmask]>
> Replies inline ...
>
> > -----Original Message-----
> > From: Jim Meagher [mailto:[log in to unmask]]
> > Subject: Re: Re: [PCSOFT] MS Access Linked Table Problem
> >
> > Can you be a little more specific?
> Yes, I can ;-)
> >
> > When it doesn't work, what is the error message?
> No messages, the status bar on the bottom shows 'Link Table Wizard' for
just
> a second or two then nothing.
>
> > Do your Office 97 machines have SR2 installed?
> Yes, same results after Office & SR2 reinstall (& WinNT4-SP6). Tried to
> clean up register before reload, but no help.
>
> > Is Office 97 installed as a network application or
> > as separate installs running on each PC?
> Separate on each.
>
> > You mention having four machines.... did you do
> > your described test on only two?
> > or did you use 3 machines (one for each step)?
> All 3 steps on each of the 4 Office 97 machines.
>
> > Identifying each machine will help us visualize the problem better.
> > (ie: The database file is on PC1, Office 2000 is on PC3, etc)
> Off2k machine(1 each) - Converted Access 2000 machine to 'prior Access
> version'.
> Off97 machines (4 each) - Preformed all 3 steps with the same results.
>
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
The NOSPIN Group provides a monthly newsletter with great
tips, information and ideas: NOSPIN-L, The NOSPIN Magazine
Visit our web site to signup: http://nospin.com
|
