473,322 Members | 1,403 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Installation DAO utility

EP
I am fresh in Access and after install my Office 2000 Pro within
Win2003 XP pro, I found that I cannot use the DAO functions. e.g. dim
abc as DAO.Recordset ... etc

How can I install or embed the service?

Thank you!

Jul 28 '06 #1
2 2106

EP wrote:
I am fresh in Access and after install my Office 2000 Pro within
Win2003 XP pro, I found that I cannot use the DAO functions. e.g. dim
abc as DAO.Recordset ... etc

How can I install or embed the service?

Thank you!
put it in when the concrete is still wet.

No, just kidding. Open a code window. Go to Tools, References.
Scroll down until you find DAO 3.6. click on it. If you want it to be
the default (instead of ADO), move it above the ADO library in the
list. Otherwise, if you declare a recordset object, like this

dim rs as recordset

you'll get an ADO recordset.

Of course, you could always use the library prefix. then reference
order doesn't matter.

dim rsDAO as DAO.Recordset
dim rsADO as ADODB.Recordset

Jul 28 '06 #2
EP
Got it !!! Thousand Thanks ^.^

pi********@hotmail.com wrote:
EP wrote:
I am fresh in Access and after install my Office 2000 Pro within
Win2003 XP pro, I found that I cannot use the DAO functions. e.g. dim
abc as DAO.Recordset ... etc

How can I install or embed the service?

Thank you!

put it in when the concrete is still wet.

No, just kidding. Open a code window. Go to Tools, References.
Scroll down until you find DAO 3.6. click on it. If you want it to be
the default (instead of ADO), move it above the ADO library in the
list. Otherwise, if you declare a recordset object, like this

dim rs as recordset

you'll get an ADO recordset.

Of course, you could always use the library prefix. then reference
order doesn't matter.

dim rsDAO as DAO.Recordset
dim rsADO as ADODB.Recordset
Jul 28 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Hayk Khachikyan | last post by:
Hi Angela, Although I'm not familiar with capabilities of InstallShild's and the likes of it, you can easily accomplish what you want in the following manner: write a small tool that takes the...
1
by: Troy | last post by:
I was experiencing odd behaviour from SQL Server within Vis Studio this morning and had to uninstall SQL. Trouble is I can't seem to get it set up the way it was before. I installed the developer...
5
by: Gus T. Butt | last post by:
I'm trying to repair an installation of MS Visual Studio .Net 2003, but if I try to install prerequisites (Step 1) or Visual Studio .Net (Step 2), it launches a Spanish install of the Intel Chipset...
2
by: Laura | last post by:
I just need to install the DB2 client in a solaris machine. The machine has not installed an open windows environment so the installation should be done in character mode. Is it posible? How could...
5
by: Dann Corbit | last post by:
Several fascinating problems have occurred with attemped installations of the latest beta 2 versions of the .NET languages (including VC++). mscorsvw.exe has been using 99% of my CPU for 17...
10
by: Jim | last post by:
I just installed the VB.NET Resource Kit and it completed successfully. However, when I try to open the 'Visual Basic .NET Resource Kit' web page, I get an error. address:...
0
by: CharlieR | last post by:
Hi I have mangage to install the prerequisites disk for Vis Studio.net and am trying to now install VB.net 2003 Standard edition, using the setup wizard. When I click on the setup link the...
1
by: rkrishnaprasadh | last post by:
Hi, I am writing a small utility which runs on the server. As all the user require Administrative privilege for some or other reasons it becomes tedious preventing unwanted s/w installations. I want...
2
by: =?Utf-8?B?R3JlZw==?= | last post by:
I have no idea where to post this question, or even if its appropriate for me to post it here. I don't know if installing a VB.Net program has caused the problem I'm having or not. All I know is I...
2
by: Don Li | last post by:
Info: the machine's OS is XP Professional with SP2 sql server 2000 developer's edition installed and running a bit of 'history' last night I first tried to install sql server 2005 express but...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.