473,320 Members | 1,861 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,320 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 1680
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: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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: 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.