473,394 Members | 1,007 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,394 software developers and data experts.

What replaces Database/Recordset collection in Access XP?

Hello,

I'm hoping enough time has passed now that someone could tell me what
methods have replaced the Database / Workspace / TableDef collections in
Access XP. I've tried asking this question before, quite some time ago, but
have been told "Just throw in a reference to DAO and away you go". That's
not the answer I'm looking for.

I'd like to know how to reference a database or a tabledef "the new way",
but I can't seem to find out what "the new way" is because the Access help
file also contains all the old items as well. Any help or even a keyword
would be appreciated.

Thanks!
Jo
Nov 13 '05 #1
3 1682
Br
Jozef <NO****@NOSPAM.com> wrote:
Hello,

I'm hoping enough time has passed now that someone could tell me what
methods have replaced the Database / Workspace / TableDef collections
in Access XP. I've tried asking this question before,
quite some time ago, but have been told "Just throw in a reference to
DAO and away you go". That's not the answer I'm looking for.

I'd like to know how to reference a database or a tabledef "the new
way", but I can't seem to find out what "the new way" is because the
Access help file also contains all the old items as well. Any help
or even a keyword would be appreciated.

Thanks!
Jo


The newer versions of Access by default use ADO. You can easily use the
old DAO way of doing things by opening up a module and go into the menu
Tools/References and tick the reference to Microsoft DAO 3.6. If you
haven't "unticked" the ADO reference you'll need to let Access know
which Database/Recordset type you are using by adding a prefix
eg.
DIM myRS as DAO.Recordset
DIM myRS as ADODB.Recordset

The Access help explains both fairly clearly.
Look up the help contents for "Programming Information"/"Conversion"
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #2
"Jozef" <NO****@NOSPAM.com> wrote in message
news:Ifane.1532585$6l.1449168@pd7tw2no...
Hello,

I'm hoping enough time has passed now that someone could tell me what
methods have replaced the Database / Workspace / TableDef collections in
Access XP. I've tried asking this question before, quite some time ago,
but have been told "Just throw in a reference to DAO and away you go".
That's not the answer I'm looking for.

I'd like to know how to reference a database or a tabledef "the new way",
but I can't seem to find out what "the new way" is because the Access help
file also contains all the old items as well. Any help or even a keyword
would be appreciated.

Thanks!
Jo


.... database or tabledef? You may find that to do what you want to do, you
may need to use more than one object library. If you needed a recordset
then you might use the ADODB.Recordset object, but for working with tables
you would use the ADOX.Table object. You could set a reference to these
libraries and explore their object models and (if it ever works) the help
file. Failing that, there is online help - for example if you want to write
new code without using the tabledef object, you could look here:
http://msdn.microsoft.com/library/de...ce10052000.asp
You should be aware that not everyone would agree that the DAO object model
has been replaced - there are still things which cannot be done with these
new libraries and even these have been replaced by objects under the .net
framework. Although these are not available for Access, many asp.net vb.net
applications are using the new object models. In short, there needs to be a
pretty convincing reason to replace DAO.TableDef objects with ADOX.Table
objects.
Nov 13 '05 #3
Thanks Justin, that's excellent!

That's the best explanation I've had.

Thank you.

Jo
"Justin Hoffman" <j@b.com> wrote in message
news:d7**********@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
"Jozef" <NO****@NOSPAM.com> wrote in message
news:Ifane.1532585$6l.1449168@pd7tw2no...
Hello,

I'm hoping enough time has passed now that someone could tell me what
methods have replaced the Database / Workspace / TableDef collections in
Access XP. I've tried asking this question before, quite some time ago,
but have been told "Just throw in a reference to DAO and away you go".
That's not the answer I'm looking for.

I'd like to know how to reference a database or a tabledef "the new way",
but I can't seem to find out what "the new way" is because the Access
help file also contains all the old items as well. Any help or even a
keyword would be appreciated.

Thanks!
Jo


... database or tabledef? You may find that to do what you want to do,
you may need to use more than one object library. If you needed a
recordset then you might use the ADODB.Recordset object, but for working
with tables you would use the ADOX.Table object. You could set a
reference to these libraries and explore their object models and (if it
ever works) the help file. Failing that, there is online help - for
example if you want to write new code without using the tabledef object,
you could look here:
http://msdn.microsoft.com/library/de...ce10052000.asp
You should be aware that not everyone would agree that the DAO object
model has been replaced - there are still things which cannot be done with
these new libraries and even these have been replaced by objects under the
.net framework. Although these are not available for Access, many asp.net
vb.net applications are using the new object models. In short, there
needs to be a pretty convincing reason to replace DAO.TableDef objects
with ADOX.Table objects.

Nov 13 '05 #4

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

Similar topics

3
by: Jules | last post by:
Hi, newbie here: I have created a small (5 fields) Access table which I will be converting to MS-SQL Server format when the ASP code has been completed. It is basically a collection of links to...
7
by: Danny | last post by:
I am trying to process a database and my code does so much that it takes a whle to go through the database. most of it is sql queries, updates and such. For about 6000 records, it takes over a...
3
by: scottallenmccullough | last post by:
I've recently returned to Access programming, having last worked extensively in Access 97. I'm now using Access 2002. I am trying to reuse some old code (from A97 days) and am having some troubles....
0
by: gm | last post by:
Immediately after generating the Access application from the Source Safe project I get: "-2147467259 Could not use ''; file already in use." If Access database closed and then reopened I get:...
12
by: Matt.W.Stephens | last post by:
Here is the scenario. We have a database with patient case information. This database was previously solely used in Access. The problem is our users connect to this database (located in California)...
6
by: mpmason14 | last post by:
I found a vbscript on vbskrypt.com that allows me to inventory the software installed on my computer and puts it in an Access database. problem: the script only finds those programs installed...
3
by: Ninio | last post by:
i would like to know how to query a database so that if a category from the dropdown menu is selected it will display all the records found on the table. thank you very much. Here is the table from...
30
by: fniles | last post by:
On my machine in the office I change the computer setting to English (UK) so the date format is dd/mm/yyyy instead of mm/dd/yyyy for US. This problem happens in either Access or SQL Server. In the...
13
by: craigchalmers | last post by:
Hi I am a complete novice so hope someone can shed some light on my problem/goal. I have an access database with some records in it. i have two fields 1) ArrivalDate 2) ReturnDate
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.