|
 |
access thread: Why form not working in NT4, but is in Win2000?
Message #1 by "Ryan Lockhart" <rlockhart@p...> on Fri, 7 Dec 2001 18:35:13
|
|
I have built up a form connecting to multiple tables with lots of VBA code
in the background. It works perfectly on Win2000, but on WinNT 4 it
bombs. When a button is pushed to retrieve records it dies. Here is the
code in question:
Dim dbAstu As Database
Dim rsAstu As DAO.Recordset
First of all, why is this happening? Second, what do I need to do to get
it to work with both Win2000 and NT 4.0? Any kind of direction would be
very appreciated.
Message #2 by "Ryan Lockhart" <rlockhart@p...> on Fri, 7 Dec 2001 19:44:21
|
|
We are using Access 2000. I check in the References and it said I was
missing the Microsoft ActiveX Data Objects Recordset 2.6 Library. This is
the msador15.dll. Can I just copy and paste the dll from the client that
works to the client that doesn't?
> I have built up a form connecting to multiple tables with lots of VBA
code
> in the background. It works perfectly on Win2000, but on WinNT 4 it
> bombs. When a button is pushed to retrieve records it dies. Here is
the
> code in question:
>
> Dim dbAstu As Database
> Dim rsAstu As DAO.Recordset
>
> First of all, why is this happening? Second, what do I need to do to
get
> it to work with both Win2000 and NT 4.0? Any kind of direction would be
> very appreciated.
Message #3 by "Gerald, Rand" <RGerald@u...> on Fri, 7 Dec 2001 14:03:26 -0600
|
|
This seems backwards. I would have expected that problem with an ADO, ADODB
or ADOX reference not a DAO reference.
The ADO library is a standard default reference with Win2K. It must be
referenced/installed with earlier versions of Windows.
Rand
-----Original Message-----
From: Ryan Lockhart [mailto:rlockhart@p...]
Sent: Friday, December 07, 2001 1:44 PM
To: Access
Subject: [access] Re: Why form not working in NT4, but is in Win2000?
We are using Access 2000. I check in the References and it said I was
missing the Microsoft ActiveX Data Objects Recordset 2.6 Library. This is
the msador15.dll. Can I just copy and paste the dll from the client that
works to the client that doesn't?
> I have built up a form connecting to multiple tables with lots of VBA
code
> in the background. It works perfectly on Win2000, but on WinNT 4 it
> bombs. When a button is pushed to retrieve records it dies. Here is
the
> code in question:
>
> Dim dbAstu As Database
> Dim rsAstu As DAO.Recordset
>
> First of all, why is this happening? Second, what do I need to do to
get
> it to work with both Win2000 and NT 4.0? Any kind of direction would be
> very appreciated.
Message #4 by "Pardee, Roy E" <roy.e.pardee@l...> on Fri, 07 Dec 2001 12:21:49 -0800
|
|
Actually, the ADO library also comes standard with Access--so I believe that
reference should be set no matter what the OS is. But the default setting
is the version of ADO that installs with Access, which is I believe 2.1.
The version cited below is 2.6 & that may be the problem. If you download &
install the latest MDAC (http://www.microsoft.com/data) you should be set.
HTH,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Friday, December 07, 2001 12:03 PM
To: Access
Subject: [access] Re: Why form not working in NT4, but is in Win2000?
Importance: High
This seems backwards. I would have expected that problem with an ADO, ADODB
or ADOX reference not a DAO reference.
The ADO library is a standard default reference with Win2K. It must be
referenced/installed with earlier versions of Windows.
Rand
-----Original Message-----
From: Ryan Lockhart [mailto:rlockhart@p...]
Sent: Friday, December 07, 2001 1:44 PM
To: Access
Subject: [access] Re: Why form not working in NT4, but is in Win2000?
We are using Access 2000. I check in the References and it said I was
missing the Microsoft ActiveX Data Objects Recordset 2.6 Library. This is
the msador15.dll. Can I just copy and paste the dll from the client that
works to the client that doesn't?
> I have built up a form connecting to multiple tables with lots of VBA
code
> in the background. It works perfectly on Win2000, but on WinNT 4 it
> bombs. When a button is pushed to retrieve records it dies. Here is
the
> code in question:
>
> Dim dbAstu As Database
> Dim rsAstu As DAO.Recordset
>
> First of all, why is this happening? Second, what do I need to do to
get
> it to work with both Win2000 and NT 4.0? Any kind of direction would be
> very appreciated.
Message #5 by Walt Morgan <wmorgan@s...> on Fri, 07 Dec 2001 14:37:47 -0600
|
|
Which version of MDAC is on the PC that works; compare with the one that
doesn't. Just a thought.
Message #6 by "Ryan Lockhart" <rlockhart@p...> on Fri, 7 Dec 2001 20:57:51
|
|
Thanks Roy that worked! The different version was the problem. With 2.7
it works.
> Actually, the ADO library also comes standard with Access--so I believe
that
> reference should be set no matter what the OS is. But the default
setting
> is the version of ADO that installs with Access, which is I believe 2.1.
> The version cited below is 2.6 & that may be the problem. If you
download &
> install the latest MDAC (http://www.microsoft.com/data) you should be
set.
>
> HTH,
>
> -Roy
>
> Roy Pardee
> Programmer/Analyst
> SWFPAC Lockheed Martin IT
> Extension 8487
>
> -----Original Message-----
> From: Gerald, Rand [mailto:RGerald@u...]
> Sent: Friday, December 07, 2001 12:03 PM
> To: Access
> Subject: [access] Re: Why form not working in NT4, but is in Win2000?
> Importance: High
>
>
> This seems backwards. I would have expected that problem with an ADO,
ADODB
> or ADOX reference not a DAO reference.
>
> The ADO library is a standard default reference with Win2K. It must be
> referenced/installed with earlier versions of Windows.
>
> Rand
>
> -----Original Message-----
> From: Ryan Lockhart [mailto:rlockhart@p...]
> Sent: Friday, December 07, 2001 1:44 PM
> To: Access
> Subject: [access] Re: Why form not working in NT4, but is in Win2000?
>
> We are using Access 2000. I check in the References and it said I was
> missing the Microsoft ActiveX Data Objects Recordset 2.6 Library. This
is
> the msador15.dll. Can I just copy and paste the dll from the client that
> works to the client that doesn't?
>
> > I have built up a form connecting to multiple tables with lots of VBA
> code
> > in the background. It works perfectly on Win2000, but on WinNT 4 it
> > bombs. When a button is pushed to retrieve records it dies. Here is
> the
> > code in question:
> >
> > Dim dbAstu As Database
> > Dim rsAstu As DAO.Recordset
> >
> > First of all, why is this happening? Second, what do I need to do to
> get
> > it to work with both Win2000 and NT 4.0? Any kind of direction would
be
> > very appreciated.
>
Message #7 by "Nazia Khan" <khan@p...> on Tue, 11 Dec 2001 11:25:15 -0500
|
|
I think you need mdac 2.5 for NT4
>>> rlockhart@p... 12/07/01 07:44PM >>>
We are using Access 2000. I check in the References and it said I was
missing the Microsoft ActiveX Data Objects Recordset 2.6 Library. This is
the msador15.dll. Can I just copy and paste the dll from the client that
works to the client that doesn't?
> I have built up a form connecting to multiple tables with lots of VBA
code
> in the background. It works perfectly on Win2000, but on WinNT 4 it
> bombs. When a button is pushed to retrieve records it dies. Here is
the
> code in question:
>
> Dim dbAstu As Database
> Dim rsAstu As DAO.Recordset
>
> First of all, why is this happening? Second, what do I need to do
to
get
> it to work with both Win2000 and NT 4.0? Any kind of direction would
be
> very appreciated.
|
|
|
View Cart
