New to Developing


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 11 of 11

Thread: New to Developing

  1. #1
    Join Date
    Jan 2007
    Location
    Toronto,Canada
    Posts
    4

    New to Developing

    Hello

    I hope someone can help me. I am a newbie to programming and have been able to develop some basic components in VB6but now am trying to go a bit further and I feel like I am getting over my head or just simply missing something.

    I am creating an application from scratch. The basics are the app runs and a splash page is displayed. The user is prompted to register and a registration form appears with contact details. I guess my question is what is the best way to store the information? it will have to be recalled, updated etc.

    I don't know if I should be building my application to access a remote sql server and be able to create each user or just storing it locally some kind of a file.

    I hope someone can guide me in the right direction or even if there is a basic user registration sample I could code from.

    Thanks

    Robert

  2. #2
    Join Date
    Oct 2005
    Location
    Maady
    Posts
    1,819
    **this is my post number 500 lol

    well u haven't told us u need it for asp, vbscript or vb maybe , but anyway the best way to store information is database ofcorse , the access database is the simplest one of them all .. just creat new table in it and put in it fields u need .. now from your vb application connect to this access database using DAO connection say , I think what u need now is how to do this connection .. a small search in this forum or in google , u will get too many examples ..
    finally in your application you can execute SQL commands using your recordset created once you have connected to the database ...
    Programmer&Cracker CS
    MyBlog:Blog.Amahdy.com
    MyWebsite:www.Amahdy.com

  3. #3
    Join Date
    Jan 2007
    Location
    Toronto,Canada
    Posts
    4
    Thanks for the quick response

    Sorry VB6. Isn't this a problem. What if Access is not loaded on the users computer?

  4. #4
    Join Date
    Oct 2005
    Location
    Maady
    Posts
    1,819
    no u don't need the M$ Access at all in the client computer , just you need the ado dll file to be registred .. this dll is the file where u will refer to it , usually it exist with windows but to be sure take it out near your application or make installation package containing it .
    Programmer&Cracker CS
    MyBlog:Blog.Amahdy.com
    MyWebsite:www.Amahdy.com

  5. #5
    Join Date
    Aug 2004
    Location
    Orange, California
    Posts
    1,261
    What Amahdy is refering to is the Microsoft Data Access Components (MDAC). If the user is up to date on this, then they will have no problems using your application. From the Microsoft Downloads Center you can find the latest version of MDAC Under the Drivers section. The latest version of MDAC is 2.8. Here is the link to the Download Center:
    http://www.microsoft.com/downloads/S...displaylang=en

  6. #6
    Join Date
    Aug 2004
    Location
    Orange, California
    Posts
    1,261
    OOP's it now looks like the Jet Drivers are no longer in the MDAC updates. I have started a new thread under the Database Forum, called "What Happend with MDAC ?"
    Hopefully someone will know what is going on here.

  7. #7
    Join Date
    Jan 2007
    Location
    Toronto,Canada
    Posts
    4
    I appreciate the feedback. Just a question. If I just want to store a user record and call it back would it be good to use a Random Data file instead of recording it to access? If yes are there are basic examples. The ones I have found are very comples. All I would want to do is store the users details and call them back throughout the app.

  8. #8
    Join Date
    Oct 2005
    Location
    Maady
    Posts
    1,819
    another search will gives you to many examples again , here in vbclassic forum too .. just look in last threads it contains lots of those examples .
    what u need to know is how to make the connection and open the database file with a recordset called "rs1" for example ... after those three lines , rs1.open execute SQL commands , rs1.XXX contains all database needs like .movenext , .movelast and so on .
    Programmer&Cracker CS
    MyBlog:Blog.Amahdy.com
    MyWebsite:www.Amahdy.com

  9. #9
    Join Date
    Aug 2004
    Location
    Orange, California
    Posts
    1,261
    A random file would mean that the next time the program was started you would no longer know what file to use so you would not be able to get the data back. If you only need it for that one time then you don't even need to store it in a file at all. Now if you want to store it in a text file, or an xml file you could still use an ADO Recordset and treat the file as if it were a database. If you do this though then any user with access to notepad could open your file and read the contents. If you use an Access database then at least the user would need some type of program that can read Access database's to be able to open and read the data. You could of course encrypt your text files. So I guess it would depend on what your needs are and how much you care about security for this project.
    Last edited by Ron Weller; 01-07-2007 at 10:48 PM.

  10. #10
    Join Date
    Aug 2004
    Location
    Orange, California
    Posts
    1,261
    One more thing I just remembered that ADO Recordsets can be saved to a file in their own format. Usually this is used for disconneted recordsets, which in this case is basically what you are doing, so it would work quite well also.

  11. #11
    Join Date
    Jan 2007
    Location
    Toronto,Canada
    Posts
    4
    Thanks Ron for the detailed explanation. I appreciate the feedback.

Similar Threads

  1. Replies: 1
    Last Post: 11-15-2006, 05:13 AM
  2. Replies: 0
    Last Post: 10-04-2006, 03:37 AM
  3. Replies: 3
    Last Post: 05-26-2006, 01:46 PM
  4. Replies: 1
    Last Post: 03-11-2005, 03:32 PM
  5. Replies: 0
    Last Post: 08-03-2003, 04:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center