Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Office XP user not able to write to 97 database (Office 97 & XP users)

    I have a database base created in Office/Access 97 and we are not in a position to convert it to Office XP yet. My problem is that the Outlook forms that we use to write the data to the database are giving up problems with our Office XP users. Is there some utility or patch that we can give to our XP users that will let them use the Office/Access 97 db, either with Outlook forms or with the Access 97 switchboard?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    Is there a macro or VB6 script that I can run that will copy and convert an Access 97 to Access XP on the fly? Since I can't get my Access 2002 users working the the Access 97. I think I will copy the db and convert it to XP so they can read and create reports out of a copy.

    Any ideas or problems with this line of thought?

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    What do you mean by "on the fly"? And if you create a copy of the A97 database, how are you planning to keep it in sync with the original?
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    At this point I don't plan on keeping it in sync. I'd like to create a "program" that will copy and convert it to a new name in XP format. All the Users are going to do is print reports from the data. In two months we will convert everybody to OS 2000 and Office 2002. I don't want to spend to much time creating security and replicates for a short time.

    Even though we are moving to Office XP, I have to convert at the same time ALL MS Access databases's to DB2 that runs on our IBM OS360 Mainframe. So my main push is to try and create a frontend for the user in VB6.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    Is there a reason you can't use the built-in conversion utility to convert a copy of the A97 database to AXP?
    Charlotte

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    There is a very good reason. I didn't think about it. LOL, do you think it would possible to automate this processing?

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    It should be possible, but why bother? Just convert it once and distribute that to your XP users.
    Charlotte

  8. #8
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    If we update the 97 database with about 50-100 new records during the day/everyday how will the XP users get "Current" information?

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    You were the one who said you didn't have to keep them in sync in <!post=Post 129183,129183>Post 129183<!/post>. I just answered your question. If you are planning on updating this daily (or more often) by automating the conversion and distribution of this data to your XP users, you have my sympathy.

    The point is, there is no clean, easy way to do this. You're mixing two different and non-consecutive versions of Access and Office, and you would have fewer headaches by opting for one or the other and not trying to hybridize them. I don't have AXP installed on my home machine because of past problems with A2k and AXP, so I can't offer much in the way of constructive advice if you decide you absolutely must find a way to do this.
    Charlotte

  10. #10
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    This issue has finaly been settled here. I am droping both Access 97 and Access 02 and "they" have decided to convert the whole thing into a DB2 mainframe database. This way there is no issue on what version of Access we are on or what version a user is on.

    I now have the pleasure of using VB6 to create a front-end to simulate the forms where had to send and rec. information.

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    I don't envy you - creating a front-end in VB that behaves in a similar fashion to an Access97 front-end is a <font color=blue>MAJOR</font color=blue> undertaking. <img src=/S/heavy.gif border=0 alt=heavy width=40 height=34> Our experience suggests that you are looking at 3 times as much effort to do a comparable VB front-end. But if "they" have decided, then "they" have decided! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Just out of curiosity - did anyone consider using an Access front-end to a VB back-end? It does mean you need either Office 97 Pro or Office XP Pro, but it should be much quicker.
    Wendell

  12. #12
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    A VB backend? What would that be, Wendell?
    Charlotte

  13. #13
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    Looks like I gotta get more sleep (or something)! I meant to say DB2 back-end. <img src=/S/doze.gif border=0 alt=doze width=15 height=15>
    Wendell

  14. #14
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    Have a nap with Lex in the afternoon! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

  15. #15
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office XP user not able to write to 97 database (Office 97 & XP users)

    As for using Access as a front end, this was considered for about 30 seconds. At this time we have a few new PC's using XP Access, another 10% using 2K and about 80% using 97. By June or July of this year, we should be all using XP Office, but we would need front-ends for all the different flavors of Office. Then we would have to see what our remote sites are using. This way would be a nightmare.

    I am hoping you are wrong about this being a MAJOR undertaking. I am a basic level VB user, that means I just took a class a few months ago and now I am trying to make something work. This project will have a total of 1 person working on it. No I take that back, there is a guy here that would like to learn VB and is willing to "help" me work on this project. Talk about the blind leading the blind.

Page 1 of 2 12 LastLast

Posting Permissions

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