Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Converting API calls from Access 2.0 to Access 97

Posted on 2000-05-10
Medium Priority
Last Modified: 2008-03-17
I am converting an application from Access 2.0 to Access 97.  I have found 2 API calls so far that use the MSAU200.DLL library.  The functions called are Update_GetFileName and Update_SplitPath.  So far, I can't find any help in determining if this library has an Access 97 equivalent.  Can anybody help?  Thanks in advance.
Question by:NJJim
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Expert Comment

ID: 2797208

I feel for you.  I pulled my hair out doing what you are doing.

The 3 .dll's I had to deal with were called:
Lib "User"
Lib "Kernel"
Lib "GDI"

I changed the code to use their 32 bit counterparts called:
Lib "User32"
Lib "Kernel32"
Lib "GDI32"

And I and changed "As Integer" to "As Long" in the Declarations.

Since then I found a Microsoft KB article that deals with this - I'll go back in my notes and see if I recorded it.


Accepted Solution

MacRena earned 200 total points
ID: 2797304

I found it.

This is the URL to the KB article on what you are trying to do.

Good luck,


Author Comment

ID: 2800036
Thanks, Mac.  Without your help I would probably be chasing my tail for another week.

I've seen this article before but I didn't originally see anything that I could make work.  Now that you've pointed me toward it again, I can see that the GetOpenFileName function from the comdlg32 library will probably work just fine.  At least I hope it will.

Expert Comment

ID: 2800343

I'm glad to help - and in that way repay the Experts who have moved me up the learning curve.
I'd like to hear your success (or otherwise) story when it's all said & done - that way the next guy who finds this thread can get a better foot up.

Good luck!


Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question