For your use of Windows 98 and with old slow HDDs (and they are both
slow - not where one is much faster than the other), you will likely not
see any performance increase by moving a portion of the pagefile over to
drive 1. Might as well as keep it all together. It's not like you will
be doing huge video edits so the app could thrash in and out of pagefile
on drive 1 while the OS was working on drive 0.

Your Access files are probably not very large and you are not accessing
them as would a server handling multiple concurrent connections from
multiple users. Tis also likely the performance of your HDDs are very
close; that is, drive 1 is probably not much different than drive 0.
You probably won't see any performance gain from splitting the pagefile.
Usage and [better] hardware dictate if splitting the pagefile will do
anything to improve performance.

You would probably get better performance by running Access97 inside a
virtual machine (VMware Player, Virtualbox) on your newest and much
better and faster hardware boxes. Yes, virtualizing hardware makes
software run slower than when it runs on real hardware but if the real
hardware is a lot faster than the slowdown from virtualizing is likely a
lot less than using ancient hardware.

Also, it sounds like you will create one partition, say partn1, on drive
1 for the split pagefile and another partition, say part2, to use for
other purposes. If you run programs under your OS on drive 0 that read
and especially write files a lot on drive 1 partn2 then you obviate
having the partition over on drive 1 partn1. You want to NOT collide
concurrent writes into the pagefile, wherever it is, with writes by the
OS or other programs you run. If drive1 partn2 is just for storage,
like for downloaded files or data files not often accessed then there
won't [often] be collisions of writes with the pagefile in drive1
partn1. You're trying to not collide the OS writes to the pagefile with
writes by other processes onto the same media storage device.