Access 2 to Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 17 Jan 2008 16:20 GMT

I am trying to Convert an ACCESS Data base from Access 2 to Access 2000
It was written in 1994. I did not write it Iam trying to update it.

It uses the following DLL's and is Run by MSARN200.EXE
DAO2016.DLL,MSABC200.DLL,MSAFIN.DLL,MSAIN200.DLL,MSAJT200.DLL,
MSAJU200.DLL,MSAOLE20.DLL,SOA200.DLL
It also has an Addin
SYSTEM.mba, Utility.MBA

When I convert I get errors about 16 bit.

There are also many Declares in the Visual Basic code.
Declare Function aad_OpenComm Lib "User" Alias "OpenComm"
Declare Function aad_CloseComm Lib "User" Alias "CloseComm"
Declare Function WriteComm Lib "User" Alias "WriteComm"
Declare Function aad_ReadComm Lib "User" Alias "ReadComm"
Declare Function aad_GetCommEventMask Lib "User" Alias "GetCommEventMask"
Declare Function aad_SetCommEventMask Lib "User" Alias "SetCommEventMask"
Declare Function aad_SetCommState Lib "User" Alias "SetCommState"
Declare Function aad_GetCommState Lib "User" Alias "GetCommState"
' Windows API Declarations.
Declare Function wu_CheckMenuItem Lib "User" Alias "CheckMenuItem"
Declare Sub wu_DrawMenuBar Lib "User" Alias "DrawMenuBar"
Declare Function wu_EnableMenuItem Lib "User" Alias "EnableMenuItem"
Declare Function wu_GetActiveWindow Lib "User" Alias "GetActiveWindow"
Declare Function wu_GetClassName Lib "User" Alias "GetClassName"
Declare Function wu_GetClientRect Lib "User" Alias "GetClientRect"
Declare Function wu_GetDC Lib "User" Alias "GetDC"
Declare Function wu_GetDesktopWindow Lib "User" Alias "GetDesktopWindow"
Declare Function wu_GetDeviceCaps Lib "GDI" Alias "GetDeviceCaps"
Declare Function wu_GetFocus Lib "User" Alias "GetFocus"
Declare Function wu_GetMenu Lib "User" Alias "GetMenu"
Declare Function wu_GetMenuState Lib "User" Alias "GetMenuState"
Declare Function wu_GetParent Lib "User" Alias "GetParent"
Declare Function wu_GetSubMenu Lib "User" Alias "GetSubMenu"
Declare Function wu_GetWindow Lib "User" Alias "GetWindow"
Declare Function wu_GetWindowRect Lib "User" Alias "GetWindowRect"
Declare Function wu_IsZoomed Lib "User" Alias "IsZoomed"
Declare Function wu_MoveWindow Lib "User" Alias "MoveWindow"
Declare Function wu_SetFocus Lib "User" Alias "SetFocus"
Declare Function wu_ShowWindow Lib "User" Alias "ShowWindow"

I do not know what of this is included in Access 2000 and what is not.

Signature

Don

Reply to this Message

Douglas J. Steele - 17 Jan 2008 20:27 GMT

Actually, your problem isn't really related to Access. The Declare
statements are references to Windows API calls. Access 2 was for a 16-bit
version of Windows, you're now using a 32-bit version.

Unfortunately, most people converted from 16 bit to 32 bit 10 years ago, so
there's not a whole lot of available documentation on the topic.
http://support.microsoft.com/kb/147781 offers an introduction.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I am trying to Convert an ACCESS Data base from Access 2 to Access 2000
> It was written in 1994. I did not write it Iam trying to update it.
[quoted text clipped - 39 lines]
>
> I do not know what of this is included in Access 2000 and what is not.

Reply to this Message

Tony Toews [MVP] - 18 Jan 2008 01:02 GMT

>There are also many Declares in the Visual Basic code.
>Declare Function aad_OpenComm Lib "User" Alias "OpenComm"
[quoted text clipped - 5 lines]
>Declare Function aad_SetCommState Lib "User" Alias "SetCommState"
>Declare Function aad_GetCommState Lib "User" Alias "GetCommState"

These look like they are serial communication port calls.

When I did a search on aad_OpenComm all I found was
http://www.tfwpa.com/msaccess/comm.htm which mentions Access 2
Developer's Guide, 2nd Edition by Roger Jennings, Which isn't all
that helpful.

Ah, wait I have the book. It's for an autodialer function. So
that you can have Access dial a phone and then pickup it up to talk.
You very likely aren't even using that code.

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Reply to this Message