Page 1 of 3 123 LastLast
Results 1 to 15 of 37
  1. #1
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Use Access 2000 as a Three-Tier Client (2000)

    You might be more responses if you explain what might be found in the attachment. Not everyone is willing to download it blind, especially if they don't know whether they have anything to contribute.
    Charlotte

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use Access 2000 as a Three-Tier Client (2000)

    Hi Charlotte!
    I followed your advice and edited the message, do you think it's good enough?
    <font color=ff69b4>Ciao</font color=ff69b4>

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

    Re: Use Access 2000 as a Three-Tier Client (2000)

    ADP is a front end for SQL Server. Are you asking how to connect to MSDE/SQL Server, how to implement a middle tier, or what? Why don't you include the text from your FW.doc in a message and describe the messages you're getting? The graphics aren't entirely necessary. Do you have the required SQL Server to connect to? I don't mean SQL Server itself but the specific server used for the project? Have you opened CustSvr in VB to see what it's trying to do and how?

    As it is, you seem to be asking for someone to make this 3-tier example work on their machine and then tell you how to make it work on yours.
    Charlotte

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Access 2000 as a Three-Tier Client (2000)

    What are the steps to be taken for displaying the tables being part of an adp file and working with its objects?
    As far as I know the only way to post a message with 3 pictures embedded in its body is to pack it in a zip file, so please <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>read the enclosed FW.doc
    <font color=ff69b4>Ciao</font color=ff69b4>
    Attached Files Attached Files

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Access 2000 as a Three-Tier Client (2000)

    Thanks again for your advice.
    I've tried opening CustSvr in VB but a message warns that the file may be corrupted. I've tried downloading it again but I still get the message.
    <hr>I don't mean SQL Server itself but the specific server used for the project? <hr>
    Are you talking about SQL command files(.sql file extension)?

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

    Re: Using Access 2000 as a Three-Tier Client (2000)

    Files with .sql extensions are SQL scripts.. Every SQL Server has a name, even if all you have installed is MSDE. There are databases within the SQL Server. If the example is looking for a particular server that contains a particular database, you have a problem. If you can't open the VB project, are you using the same version of VB used to create it?
    Charlotte

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

    Re: Using Access 2000 as a Three-Tier Client (2000)

    Hi Giorgio,
    I'm curious why you want to pursue a three tier design - the author of the article concluded that it basically didn't work in an update direction if I understood it correctly. If you are looking at a real-time transaction system where designs of that sort are common, you really want to work exclusively with VB or some other development platform. SQL Server can still be the back-end of course. Have I missed something?
    Wendell

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Access 2000 as a Three-Tier Client (2000)

    <hr>If you can't open the VB project, are you using the same version of VB used to create it?<hr>
    Well, Jeffrey McManus in his article said that he used a database-driven ActiveX DLL component called CustSvr, <span style="background-color: #FFFF00; color: #000000; font-weight: bold">built in VB6</span hi>, to populate an Access form with data so... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Access 2000 as a Three-Tier Client (2000)

    Hi Wendell,
    Jeffrey McManus in his article said, "Binding out-of-process doesn't work in VB either...when I took the same code and placed it in an Access VBA class module, it worked flawlessly." so shouldn't we infer that we do need Access to work with this sort of project?
    Have you tried opening Cust.adp? And, if so, does it give you the same message I get when you click on the "Get Customer" button on the frmCustomer form?

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

    Re: Using Access 2000 as a Three-Tier Client (2000)

    Did you register the dll on your machine using regsvr before trying to reference it? If it's compiled into a dll, you won't be able to open it in VB.
    Charlotte

  11. #11
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Access 2000 as a Three-Tier Client (2000)

    Jeffrey McManus in his article said that he used a database-driven ActiveX DLL component called CustSvr but the zip file contains CustSvr.vbp and CustSvr.vbw. Is the zip file missing a CustSvr.dll file then?

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

    Re: Using Access 2000 as a Three-Tier Client (2000)

    Sorry for not including the quote at the end of his article. He said

    "This brings us to the other side of the coin: getting data out of the database through an Access report. How do you report database information using a middle-tier component? I hate to say it, but ya got me! You certainly can't bind a report to a middle-tier component, and unlike the Access form, the report doesn't even have a Recordset property to bind to. Barring a revelation, either your middle-tier component must provide a RecordSource string to the Access report (ick), or you must leave it out of the reporting picture completely."

    I haven't actually tried to work with his concepts, but we avoid OLTP systems in general. They frequently involve high data volumes and things like clustered servers. We let the guys that want to take big risks (and get paid big bucks) take on those projects. I suppose one day when I'm not swamped I should look at the concepts in more detail, but . . . .
    Wendell

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

    Re: Using Access 2000 as a Three-Tier Client (2000)

    My crystal ball is in the shop this week <img src=/S/grin.gif border=0 alt=grin width=15 height=15>, so I don't know. You can create a dll from VB, so the vbp file may need to be compiled into a dll for the project to work. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  14. #14
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Access 2000 as a Three-Tier Client (2000)

    <hr>the vbp file may need to be compiled into a dll for the project to work.<hr>
    What do you use to compile a vbp file into a dll?

    I've noticed there's a CustSvr.vbw file in the zip download. In spite of having VB6 installed, this type of file(Visual Basic Project Workspace says in the file properties) is not recognized by my computer. Do you know what it's for?

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

    Re: Using Access 2000 as a Three-Tier Client (2000)

    Every project has a vb workspace file. You don't open them directly. I can't answer your question about compiling the project into a dll, because I've never tried that manuever.
    Charlotte

Page 1 of 3 123 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
  •