Member Avatar for zebnoon

Hello ,
all dear.
I was not here for long time. I got project for a tuck shop please suggestion me what type of database i hae yo use MS access,Sal, Orelle or other ease tool?
regards,
Zeb noon

  • 2 Contributors
  • 5 Replies
  • 123 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Jx_Man

Dani AI

Generated

Good: choose the right tool for the real needs rather than the name. For a tiny, single‑PC tuck shop an Access file or an embedded engine is the fastest path because you can ship one file. For a multi‑user or growth scenario use a server RDBMS (what pointed toward) so you avoid file‑locking and scaling issues. Since prefers Access and asked about ADO, below are practical tips for VB6 + ADO and a minimal example to create a database and tables on first run.

Create-once, not on every Form_Load. Run a simple existence check at startup (file exists or try opening the connection). If the DB is missing, create it, then run the schema SQL. For Access you can use ADOX to create the .mdb/.accdb file and ADODB.Connection.Execute for DDL. For server DBs open an admin/owner connection and issue CREATE DATABASE then CREATE TABLE statements.

Example (VB6): create an Access file with ADOX, then create a table with ADO.

' Requires reference: Microsoft ADO Ext. 2.x for DDL and Security (ADOX)
Dim cat As ADOX.Catalog
Set cat = New ADOX.Catalog
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TuckShop\tuckshop.mdb;"
Set cat = Nothing

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TuckShop\tuckshop.mdb;"
On Error Resume Next
cn.Execute "CREATE TABLE Products (ProductID COUNTER PRIMARY KEY, Name TEXT(100), Price CURRENCY)"
If Err.Number <> 0 Then Err.Clear
cn.Close
Set cn = Nothing

Checklist & cautions: run DB creation only once (installer/first run), keep schema SQL in versioned scripts, use transactions and parameterized commands for data ops, split Access into front-end/back-end for multi‑user setups, store DB in a writable app data location (not Program Files), and implement backups. If planning to expand beyond one machine, start with a server DB to avoid later migration headaches.

Recommended Answers

All 5 Replies

Member Avatar for Jx_Man

MySQL. its free to use.

Member Avatar for zebnoon

thx dear jx
i mostly work on MS acess database .Please tell me how to use Sql data db to create? which tool i have to install?What are requirements?

Member Avatar for Jx_Man
commented: Complete Guide +2
Member Avatar for zebnoon

Hy JX!
I want to create database with ADO object.
secondly I want create Tables,Fields with SQL queries in VB6 i with need to create database Just as form will be loaded My complete DB will be created?
Please hep me.
zeb noon

Member Avatar for Jx_Man

Hi Zeb noon,
Please post your new question on new thread, with new title. you can get many helps from other members and gurus in new thread. i will help you there too.
Just keep the this thread for your originally question.
And Don't Forget to Mark This Thread As Solved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.