PC Review


Reply
Thread Tools Rate Thread

Access 2 to Access 2000

 
 
Don
Guest
Posts: n/a
 
      17th Jan 2008
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.

--
Don
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      17th Jan 2008
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.


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


"Don" <(E-Mail Removed)> wrote in message
news:13549BDA-EEC4-49EE-A909-(E-Mail Removed)...
>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.
>
> --
> Don



 
Reply With Quote
 
Tony Toews [MVP]
Guest
Posts: n/a
 
      18th Jan 2008
Don <(E-Mail Removed)> wrote:

>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"


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

--
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate Saving Access 2003 to Access 2000 and Access 97 =?Utf-8?B?Q2hlcnls?= Microsoft Access VBA Modules 10 1st Oct 2005 08:20 AM
Dialing from an Access form / Access 97 & Access 2000 Abay Microsoft Access Forms 2 12th Jun 2005 01:17 AM
Access 2002 queries saved as 2000 do not show in access 2000 =?Utf-8?B?Q2xhdWRl?= Microsoft Access 0 6th Jan 2004 03:46 PM
Re: Allowing users (w/o MS Access) to access an Access 2000 database Wayne Morgan Microsoft Access 0 29th Sep 2003 11:46 PM
Re: Allowing users (w/o MS Access) to access an Access 2000 database John Vinson Microsoft Access 0 29th Sep 2003 07:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:11 PM.