Visual Basic 6.0 translation

Sunday, July 4, 2010

VB 6.0 و التعامل مع MS-ACCESS 2003 من خلال شبكة - MS-ACCESS 2003 THROUGH NETWORK AND VB 6.0

بسم الله الرحمن الرحيم

الموضـــــــــــوع هذه المرة يتحدث عن كيفية التعامل مع Access من خلال الــــ VB 6.0 فى حالة وجود قاعدة البيانــــــــــــــات (mdb.*)  على جهاز اخر يصل الى الجهاز الى يحتوى البرنامج عن طريق شبكة NetWork .
و فى البداية يجب أن نتأكد من أن الجهازين على اتصال ببعضهم البعض بمعنى :


Ip Address
اســـــم الشبكة
  • نفرض ان لدينا جهازين (PC1 - PC2) و الجهاز PC1 هو السيرفر (هو الذى يستضيف قاعدة البيانات) و ليكون اسمها (ahmed.mdb) فى فولدر اسمـــــــة (MyProject) فى داخل الفولدر (Shared Documents) الذى يوجد فــــــــــى  (My Computer) ......
كما بالشكل .
    • و يجب ان لا ننسى ان نقوم بعمل Share للفولدر الذى سيحتوى على قاعدة البيانات أو ممكن ايضا تقاريـــــر.
    • و سنقوم بعمل قاعدة البيانات الان ...

    '' طبعا اذا كنت غير قادر على فهم أو تطبيق اى جزء فأنت غير ملم بالموضوع و يلزمك ان تدرس أكثر ''
    الان انتهى العمل تماما على الجهاز PC1
    و الان سنقوم بتصميم البرنامج
    كما بالشكل
     - طبعا البرنامج فكرتة كالتالى : قاعدة البيانات على جهاز و البرنامج على جهاز تانى أو على عدة أجهزة كل الاجهزة دى واصلة ببعضها عن طريق شبكة اسمها (Evry1falls) و الاى بى (IP) بتاع الجهاز الرئيسى رقمة (192.168.1.1) و بالنسبة للجهزة التانية تقدر تحط الارقام اللى انت عاوزها من 2 الى 255 فى أخر الرقم اللى فوق دة , فى المثال دة (PC1) الاى بى رقمة 192.169.1.1 و (PC2) الاى بى بتاعه رقمه 192.168.1.5 و الشبكة اسمها Evry1falls و البرنامج شغال بقاله اكتر من سنه و زى الفل بس طبعا على اكتر من جهاز , تقريبا 5 .
    - المفروض دلوقتى ان أول ما نعمل Run للبرنامج كل الــ TextBoxes هيظهر فيها أول سطر فى قاعدة البيانات و ده عشان منطولش على بعض , انا مرضتش أحط زراير تانية عشان كلها فكرتها مشروحة قبل كده فالدروس اللى فاتت .
    - ايضا لا تنسى اختيار مكتبة Ado اى اصدار , و فى هذا المثال نعمل بالاصدار 2.8 .
    - و الان مع الاكــــــــواد :
    كما بالشكل
    - الان قم بفتح ملف قاعدة البيانات (Ahmed.mdb) و املأ الحقول (سطر واحد فقط مثلا و ليكن "1 - احمد - 27") تجد أنه بمجرد عمل Run للبرنامج تظهر القيم السابقة فى الـــ TextBoxes و ايضا هذا معناه انك الان متصل بقاعدة البيانات من على الشبكة و يمكنك الان اضافة الازرار التى ترغب بها و الشاشات و الموديولز كأنك تعمل على قاعدة بيانات فى نفس الفولدر .....
    - و لمزيد من الدروس .... تابعونا باستمرار.
    - و لأى اسألة .... فقط ضع تعليق .
    - شكرا .............. مع تحياتى 

    17 comments:

    1. مجهود جميل وحياك الله والى الامام في مسيرة العلم وزكاته.
      اخوك رغيد من العراق

      ReplyDelete
    2. شكرا على مرورك أخ راغد و اسف على التأخير فى الرد

      ReplyDelete
    3. Hurrah! In the end I got a web site from where I can in fact obtain helpful information concerning
      my study and knowledge.

      my web blog: BertramHSotello

      ReplyDelete
    4. Hey there! Do you use Twitter? I'd like to follow you if
      that would be ok. I'm absolutely enjoying
      your blog and look forward to new posts.

      Also visit my web blog ErvinZLeffert

      ReplyDelete
    5. Hi to every one, it's actually a nice for me to pay a visit this site,
      it consists of valuable Information.

      My web page EleanoreQGluck

      ReplyDelete
    6. Hello! This is kind of off topic but I need some advice from an established blog.
      Is it difficult to set up your own blog? I'm not very techincal but I
      can figure things out pretty quick. I'm thinking about
      creating my own but I'm not sure where to start.
      Do you have any points or suggestions? Thank you

      my site ... AllineYCampus

      ReplyDelete
    7. Spot on with this write-up, I absolutely feel this website
      needs a great deal more attention. I'll probably be returning to read more, thanks for
      the info!

      Look into my weblog BreanneGFinkenbiner

      ReplyDelete
    8. I'm really enjoying the design and layout of your website.
      It's a very easy on the eyes which makes it much more enjoyable for me to
      come here and visit more often. Did you hire out a developer to create your theme?
      Great work!

      My web site :: TannerLSchlecter

      ReplyDelete
    9. I am extremely impressed with your writing skills as well as with the layout on your blog.
      Is this a paid theme or did you customize it yourself? Either way keep
      up the excellent quality writing, it is rare to see a nice blog like this one these
      days.

      my web-site; CrystaADarwish

      ReplyDelete
    10. I feel this is one of the most important info for me. And i'm happy studying your article.
      But should remark on few basic things, The web site taste is perfect, the
      articles is in reality great : D. Excellent job, cheers

      Feel free to surf to my web page :: ArdellCMcgath

      ReplyDelete
    11. Its such as you read my thoughts! You appear to grasp so much approximately this,
      such as you wrote the book in it or something.
      I believe that you just can do with some % to pressure the message
      home a bit, but instead of that, that is fantastic blog.
      A great read. I will certainly be back.

      Here is my blog post ... AngelitaKMassingill

      ReplyDelete
    12. I used to be able to find good advice from your content.


      my website; MadelaineOHilbun

      ReplyDelete
    13. Hey there! I know this is kinda off topic but I'd figured I'd ask.
      Would you be interested in exchanging links or maybe guest authoring a blog post or vice-versa?

      My blog goes over a lot of the same topics as yours and I think we could greatly benefit from each other.
      If you happen to be interested feel free to send me an e-mail.
      I look forward to hearing from you! Excellent blog by the way!


      my homepage :: CharlesJJohanningmeie

      ReplyDelete
    14. After looking over a number of the blog posts on your site, I
      honestly appreciate your technique of blogging.
      I bookmarked it to my bookmark website list and will be checking
      back in the near future. Please check out my website
      as well and let me know your opinion.

      Here is my page :: RamiroNPaluch

      ReplyDelete
    15. I am really enjoying the theme/design of your web
      site. Do you ever run into any browser compatibility
      issues? A few of my blog readers have complained about my blog
      not working correctly in Explorer but looks great in Safari.

      Do you have any tips to help fix this issue?

      Stop by my web site EloyLConchado

      ReplyDelete
    16. بارك الله فيك ووفقك
      حبذا لو تكون الاكزاد مكتوبة بدل الصورة
      وشكرا

      ReplyDelete

    visual basic 6 source code says (Hi)

    Visual Basic Online Course

    vb6 (63) Application Development (45) Visual Basic Online Course (45) Online Visual Basic Course (44) Visual Basic Help (44) Visual Basic Programming (42) IT Jobs (39) VB6 developer (38) Visual Basic Course (38) Visual Basic 6.0 (26) Microsoft Visual Basic 6.0 (25) VB6.0 (24) Visual Basic Programmers (24) vb 6.0 (24) visual basic programming tutorial (19) Third lesson (16) Source code download for Visual Basic 6.0 (14) Source code for Visual Basic 6.0 (10) visual basic tutorial (9) Visual Basic 6 (5) Visual Basic Courses (5) Lesson 3 (4) VB 0.6 - TreeView control (4) VB 0.6 With TreeView Control (4) VB6 Course (3) Create ActiveX (2) How to automate MS-Access from Visual Basic 6.0 (2) Add controls at runtime (1) Back up your Database (1) Change ActiveX icon (1) Change screen resolution (1) Create FTP (1) Crystal Reports 4.6 (1) Crystl32.ocx could not be loaded (1) DataGrid Columns re-size (1) Date Calculation (1) DateAdd Function (1) DateDiff function (1) FTP (1) Marquee Title Bar (1) Marquee VB 6.0 TitleBar (1) Method 'Action' of object 'CrystalCtrl' Failed (1) Microsoft Access with Visual Basic 6.0 (1) OpenSchema method (1) Save File Using CommonDilog (1) Track Database path (1) VB 0.6 - Registry (1) VB 0.6 With Registry Editor (1) VB 6.0 Access (1) VB 6.0 OOP (1) VB6 Access2003 ADO Like % (1) VB6 Add Date (1) VB6 Add Time (1) VB6 Date calculation (1) VB6 Subtract Date (1) Visual Basic Remote (1) Win7 (1) Windows7 (1) ms access networking details (1) remote Visual Basic DB (1) rounded and transparent forms (1) vb 0.6 style (1) vb 6.0 Remote Database (1)