Results 1 to 11 of 11

Thread: Access 2000

  1. Nov 9th, 2000, 11:08 AM #1
    jp_schwartz
    jp_schwartz is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2000
    Location
    Mexico City
    Posts
    306

    Unhappy

    Hi all!!!

    The only way for making a recordset to Access 2000 is ADO?
    Can I use DAO?

    Can someone give me some code?

    Thanks!!
    Reply With Quote Reply With Quote
  2. Nov 9th, 2000, 11:50 AM #2
    smh
    smh is offline
    Addicted Member smh's Avatar
    Join Date
    Oct 2000
    Location
    South Dakota, USA
    Posts
    249

    try this...

    Try this site...

    This is where I refer to:

    http://www.vb-world.net/articles/database3/index3.html

    smh
    Normal is boring...

    smh
    Reply With Quote Reply With Quote
  3. Nov 10th, 2000, 03:37 PM #3
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    DAO 3.6 is the earliest version that works with Access 2000.
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    Reply With Quote Reply With Quote
  4. Nov 10th, 2000, 04:04 PM #4
    jp_schwartz
    jp_schwartz is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2000
    Location
    Mexico City
    Posts
    306
    Thank you very much.
    So, I guess it´s time to move onto ADO.
    If things were easy, users might be programmers.
    Reply With Quote Reply With Quote
  6. Nov 12th, 2000, 11:27 AM #5
    honeybee
    honeybee is offline
    Randalf the Red honeybee's Avatar
    Join Date
    Jun 2000
    Location
    off others' brains
    Posts
    4,345

    Well ...

    What made you switch from DAO to ADO?

    DAO 3.6 can be safely used with Access 2000. And if you are using DAO 3.51 or something, you just have to change the reference from DAO 3.51 to DAO 3.6 There is no need to change any of the code. So before switching to ADO, consider the re-coding exercise.

    I am not a complete idiot. Some parts are still missing.
    Check out the rtf-help tutorial
    General VB Faq Thread
    Change is the only constant thing. I have not changed my signature in a long while and now it has started to stink!
    Get more power for your floppy disks. ; View honeybee's Elite Club:
    Use meaningfull thread titles. And add "[Resolved]" in the thread title when you have got a satisfactory response.
    And if that response was mine, please think about giving me a rep. I like to collect them!
    Reply With Quote Reply With Quote
  7. Nov 14th, 2000, 10:03 AM #6
    jp_schwartz
    jp_schwartz is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2000
    Location
    Mexico City
    Posts
    306
    Thanks, but, between ADO and DAO...
    Which one is faster?, lighter?, better?
    If things were easy, users might be programmers.
    Reply With Quote Reply With Quote
  8. Nov 14th, 2000, 10:47 AM #7
    paulw
    paulw is offline
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    ADO is the future. Microsoft are not going to update DAO for much longer.

    ADO is much lighter and more flexible. Better, well depends on your point of view.

    My advice, use it for all new projects. Don't bother converting current DAO - its too much hassle.

    Cheers,

    Paul.
    Not nearly so tired now...

    Haven't been around much so be gentle...
    Reply With Quote Reply With Quote
  9. Nov 14th, 2000, 02:54 PM #8
    jp_schwartz
    jp_schwartz is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2000
    Location
    Mexico City
    Posts
    306
    Thank you very much guys!!!
    If things were easy, users might be programmers.
    Reply With Quote Reply With Quote
  11. Nov 14th, 2000, 02:56 PM #9
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    DAO is faster and easier to program, but it only works with Access.
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    Reply With Quote Reply With Quote
  12. Nov 15th, 2000, 08:46 AM #10
    SmashingPiggy
    SmashingPiggy is offline
    New Member
    Join Date
    Nov 2000
    Posts
    10

    Exclamation

    JP,

    Word of caution. I have been working with both Access 97 and Access 2000 databases in the same program. The current version of ADO is great and manipulates both versions well. The Jet Engine 4.0 tool CompactDatabase, however, will destroy your Access 97 database.

    So to compact, use the JETCOMP.EXE tool that is provided by Microsoft. It can run from a command line, use JETCOMP.EXE -? to get all of the paramaters. You will have to call it from a shell script, use the information in the Knowledgebase article Q129796 "HowTO: 32-bit App can determine when a shelled process ends" to set it up. Since you need to wait for JETCOMP to complete so that you can verify it before you "Kill" the old database.

    You can get the JETCOMP.EXE from:

    http://support.microsoft.com/support...-US&SD=gn&FR=0


    Hope that helps,



    TTFN,

    Smashing Piggy

    "Beware of Big Bad Wolf dressed in Tigger clothes"
    Reply With Quote Reply With Quote
  13. Nov 15th, 2000, 04:07 PM #11
    jp_schwartz
    jp_schwartz is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2000
    Location
    Mexico City
    Posts
    306

    Talking

    Thank you very much!!!
    If things were easy, users might be programmers.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width