Making MS ACCESS Database part of .EXE file in VB6... how?

[cold_fusion]

---

Making MS ACCESS Database part of .EXE file in VB6... how?
unsa man na mga bai?... kinsa naay idea ug kamao?... murag embedding ACCESS Database to a VB6 program, MDB or MDE...
then how to retrieve data from it?...
yeah! bling bling men...abz'

This is easy.
Just create an ODBC connection for the MsAccess Database
Then create a either use RDO or ADO connection to point to the ODBC created.
Example in RDO:

Dim cnAccess As New rdoConnection
Dim rdoQry As New rdoQuery
Dim rdors As rdoResultset
Dim conn_string As String
Dim sql as String

con_string = "ODBC connection string here...."

cnAccess.CursorDriver = rdUseOdbc
cnAccess.Connect = conn_string
cnAccess .EstablishConnection

sql="SQL statement here...."

openRS rdoQry, rdors, sql

manipulate recordset rdors here....
.
.
.

rdors.Close
rdoQry.Close

[kibotizer]

This is easy.
Just create an ODBC connection for the MsAccess Database
Then create a either use RDO or ADO connection to point to the ODBC created.
Example in RDO:

Dim cnAccess As New rdoConnection
Dim rdoQry As New rdoQuery
Dim rdors As rdoResultset
Dim conn_string As String
Dim sql as String

con_string = "ODBC connection string here...."

cnAccess.CursorDriver = rdUseOdbc
cnAccess.Connect = conn_string
cnAccess .EstablishConnection

sql="SQL statement here...."

openRS rdoQry, rdors, sql

manipulate recordset rdors here....
.
.
.

rdors.Close
rdoQry.Close

nasod naba sa .EXE file ang database ani bro?... pwede na madelete ang database ining compile sa program?...



yeah! bling bling men...abz'

[cold_fusion]

nasod naba sa .EXE file ang database ani bro?... pwede na madelete ang database ining compile sa program?...

I-sulod sa .EXE
Why would you do that?
Exe files are even protected by anti-virus programs at runtime.

But there are database engines that are embedable but not the data. They are mostly written in C. For example sqlite.
You could put the data in memory but will be erased after the program quits.

[moz_k2]

I dont know if mabutang ba jud na sa exe.

Gamita nalang ang mdb file.
The application could still make use of it even wla ka ms access.

[silent-kill]

kana diay mga resource files?.. naka suway kog butang access files sa exe. or dlls via resource files. pro c# to. wa ko kabaw onsaon pag inser resource files for vb6 pro duda ko mao na.. imo i resource. ang .mdb file.

[eax]

kana diay mga resource files?.. naka suway kog butang access files sa exe. or dlls via resource files. pro c# to. wa ko kabaw onsaon pag inser resource files for vb6 pro duda ko mao na.. imo i resource. ang .mdb file.

I'm not an expert sa .NET, I think mga resource files is gi-zip(compressed) ra na siya sulod sa exe file. Dili gyud na siya part sa executable code.

[silent-kill]

di man jud na i apil sa executable code ang mga resource file bai. in ASM theres what they call the

executable code /block. where all the jmp jne, mov, pop ,push, static pointers, dynamic pointers. comes in.
and the resource/data block. just binary data floating around in the sea of bytes. LOL..

pro sulod siya sa exe file and DLL. and i guess ma access nimo pro readonly ra basin..
and theres this technique where they actually writes the "tmp/mdb/jpg etc" files and place it on the user profile...
so the next time you run your program... you'll just read from that location instead from the exe.... this technique is helpful. when you want to create "templates" for your data storage and dont want user to change them... but not really intended for saving to the mdb file inside the exe.

i dont know kong ila bajud i compress.. ang file kai 190k manto ang access.. file nya pag compile nako 200k+ na. heheeh.

[eax]

pro sulod siya sa exe file and DLL. and i guess ma access nimo pro readonly ra basin..
and theres this technique where they actually writes the "tmp/mdb/jpg etc" files and place it on the user profile...
so the next time you run your program... you'll just read from that location instead from the exe.... this technique is helpful. when you want to create "templates" for your data storage and dont want user to change them... but not really intended for saving to the mdb file inside the exe.

I think dili gihapon sakto kay u just statically/dynamically link a file. Kay iyang gusto is sulod man sa binary codes ang mga data sa exe file.

[cold_fusion]

possible cguro siya kung data retrieval lng...bisan data retrieval lng... unsaon kha?

If it is for data retrieval only, why not just put the data in an array?
Hardcode the data and assign them in a large array and voila you have your database.
This is already included in your exe file. Retrieval is even faster than on a native MDB.

BTW, What is purpose of this idea? Maybe we could give a better suggestion on for your intent...

[kibotizer]

di man jud na i apil sa executable code ang mga resource file bai. in ASM theres what they call the

executable code /block. where all the jmp jne, mov, pop ,push, static pointers, dynamic pointers. comes in.
and the resource/data block. just binary data floating around in the sea of bytes. LOL..

pro sulod siya sa exe file and DLL. and i guess ma access nimo pro readonly ra basin..
and theres this technique where they actually writes the "tmp/mdb/jpg etc" files and place it on the user profile...
so the next time you run your program... you'll just read from that location instead from the exe.... this technique is helpful. when you want to create "templates" for your data storage and dont want user to change them... but not really intended for saving to the mdb file inside the exe.

i dont know kong ila bajud i compress.. ang file kai 190k manto ang access.. file nya pag compile nako 200k+ na. heheeh.

bitaw bai silent-kill, sakto jud... gamit jud ni nako ron kung naa makahatag more idea... im only planning to read from a file not writing on it because i know it's very hard if not impossible.

maski asa: Resource File or OLE, basta after the program is compiled and turns to EXE file dili na dayon ka-edit ang user sa maong database... pwede pod kung gamiton na ang maong file i-extract siya from the EXE file and will be temporarily/permanently save in a specific location

===========
opening embedded object in the OLE control in vb6

'kung unsa ang file sa OLE control i-save niya temporarily to a specific file unya i-open kung unsa ang default software nga 'maka-open niya
'another alternative in opening the file during runtime is by double clicking the icon of the file
OLE1.DoVerb


'ang ako problema kay dili ko ka-kuha sa path kung asa na-save ang embedded file
'unya dili pod siya ko ka-access sa file kung dili i-open
===========

pasaylo mga bai nga mag-lisod jud ko pasabot sa ako gipangita... hehe


yeah! bling bling men...abz'