visual basic 6 without database 2

[chennaiprogrammer]

what are my options

1) I need to create a visual basic 6 application to store and retrieve user data

2) should I absolutely use ms access 2000 ? if so shouldn't the computer running the end executable .exe need ms access installed in it too ?

3) or is there any alternative like a built in small database application within visual basic 6 itself ?

4) or should I store an retrieve data from simple text files ? aren't they cumbersome !

chris

 

[JAG14]

Hi Chris..

1) Good On You

2) See thread222-748012 for the information about this..

3) Visual Basic doesn't have a Small Database builtin but provides pretty much seamless integration with your Access (or most other Big Names) Database

4) If you only have a small amount of data then using text files is not a cumbersome idea.. The code is very simple to work with and VB has a lot of support for File Input/output.
Search your Help files for "Open Statement" "Close Statement" and all related topics. If you need any more help with File I/O. Post a reply with your question and I will be glad to help.

Hope this helps.. Good Luck.

[tt]"Very funny, Scotty... Now Beam down my clothes."[/tt]

 

[Rhys666]

If you're just using Access as a database, you should be able to have an .mdb (Access database) in a central location, accessible by instances of the application on remote machines. Or you could use the MSDE, which is on the Office install discs. Have you considered MySQL, or XML rather than a flat text file format?

All of these will have benefits and drawbacks, but only you, (or your design/architecture team), can really look into these based on your set up and requirements.

Think along the lines of;

How big could this DB become?
Is speed an issue?
How many people will access the application simultaeneously?
Cost
Implementation


Rhys
Buffy: Spike, what are you doing here, five words or less!
Spike: Out for a walk... bitch!

 

[LostInCode]

>Visual Basic doesn't have a Small Database builtin

The VB6 default database dbms IS a JET Mdb database.

 

[chennaiprogrammer]

ok from what I have gathered if the data size is small then text file is the way to go

or if data size becomes huge and complex sql queries need to be

I need to go with access and all I need is the .mdb file , MDAC and DCOM packaged into my installer file and this will work on any computer running 95 to XP

am right ?

 

[johnwm]

Access is only a front end for the Jet4 database. You don't need Access to create and use Jet datbases from VB, although it's often easy to use Access to originally build the empty database.

You can use and manipulate Jet databases from VB using either DAO or ADO, and you can build Jet dbs with ADOX. There are good examples of all this stuff in VBHelp, and in this forum.

If this application may grow, then I would suggest using MSDE, which is a full MSSQL implementation, designed for up to 2GB databases and up to 5 concurrent users. It will scale directly to MSSQL server if you need to expand later.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[chennaiprogrammer]

I need to learn more about MSDE so that I can build scalable databases

also

http://www.tek-tips.com/viewthread.cfm?SQID=788951&SPID=703&page=1

I have a ms access problem and if anyone of you could help me out that will be excellent !