I have Access97 and 2000 databases on our server. Access97 is the only one that is "installed". I have seen articles on installing 97 and 2000 together, and on my development machine it works great. But I "call" the access .mdb from our AS/400, which runs the Autoexec macro. The operating system would not know which version to run, so I thought I'd write a VB 6 program to do this, but I can't get the TransferDatabase command to work right from VB. It tells me that ISAM is missing.
I need to transfer 2 database files from my AS/400 first.
I know we should be using SQL Server for this stuff.
If this belongs in the VB forum, I'm sorry.
But it's kinda like an Access issue.
-Gary
They never have to knock if your door is always open.
I need to transfer 2 database files from my AS/400 first.
I know we should be using SQL Server for this stuff.
If this belongs in the VB forum, I'm sorry.
But it's kinda like an Access issue.
-Gary
They never have to knock if your door is always open.
