Access 97 to Access XP

J

Jimmy

I have a database that has macros that was created in access 97. Now i am
using access XP and would like to use that same database but the macros dont
work. How do i go about of converting the database to work in access XP?

Thanks
 
D

Douglas J. Steele

Macros generally convert without any problem. What are yours doing?

One option might be to convert the macros to VBA code. To do this in Access
97, highlight the macro, then choose File | Save As/Export from the menu.
Select the Save as Visual Basic Module option. Unfortunately, you'll have to
do this macro by macro.
 
J

Jimmy

Thanks for your reponse.

I am getting alot of error messages saying Action Failed. With the macros
name of which failed. Your solution is a little too technical for my blood.
Would there be an easier way?

Thanks.
 
D

Douglas J. Steele

Sorry, but as I said, I'm not familiar with problems converting macros.

What action are they trying to do that's failing?
 
J

Jimmy

I am not sure on this either. But it looks like the macro is for exporting
data in to a text file.

This is the macro (below)
Transfer type: Export Delimited
Table name: QRYClientTable
Filename: c:\test\test.txt
Has Field Names: No

The error i am getting when this is run is this:

Action failed.

Macro Name: Disk C
Condition: True
Action Name: TransferText
Arguments: 2, , QRYClientTable, c:\test\test.txt, No, ,

This error means nothing to me unfortunelty.

Any ideas?
 
J

Jimmy

Doug,

I figured it out :)

I needed to use a UNC for my save path. I was using a drive letter and path
before. How this makes a difference i really dont understand. But it works
fine now :)

Thanks for your help though. Appreicate it.
 
Top