Any way to read and write records to "access bank" or sqllite by memory?
hi,i have a access bank (mdb or accdb file) or db sqi lite bank.i want can add record or edit or delete or run query but in memory
any sample code?
i dont want save it on hard disk and i want set to data grid or others grids and use like as adodc
any sample project or idea?
Re: Any way to read and write records to "access bank" or sqllite by memory?
Not sure what you are trying to do, a DB that is entirely in memory is only useful during the current run of the program since nothing is saved to disk then all add, edit, delete processes that were done during the run are lost when the program is closed. No matter how you skin the cat if you want the data to be there when you start the program the data has to be on disk and if you want changes to show up the next time it is ran then those must be saved to disk as well. There is no real way around that. You could use a ram disk but that is cleared when the PC is restarted so data there does not persist either.
1 Attachment(s)
Re: Any way to read and write records to "access bank" or sqllite by memory?
i want protect my files from any access and its important for me to dont create on disk but its ok if i should be use ram disk till restart but how do that? do u hv any sample?
i attached my simple program to i can use my access bank from memory and i can run query too but i like more than this,i like can edit and add and save,any sample or any idea?
Re: Any way to read and write records to "access bank" or sqllite by memory?
Are you wanting to start the program with a blank database and loose any and all changes made when the program closes?
If the answer is no then you need to save the data to disk.
Even with a ram disk you are still in a sense writing to a disk it is just a very fast, temporary disk that gets erased when the system is restarted or powered down.
I have no idea what you mean when you keep saying access bank. Access is a file based DB system.
Re: Any way to read and write records to "access bank" or sqllite by memory?
it can be empty or filled with data at start program like as my sample in #3
First of all, I need to use more memory capacity than just loading a file or font or playing musics, most of the examples I found in the forums were just reading from memory, but this time I want to read Do the writing operation as well
But in the second step, I used both "Access and sqllite banks" as examples and not jst "access bank only", just the nature of the database, otherwise other banks can be used as examples as i told in thread #1, but the problem is that I do not want any files to be available to users.
The nature of the database is that I can store a lot of information in an organized way and connect it to some grids or adodc or other component to support ado or dao or like these technology in design and without need internet connection, but this time I want to display this information and edit it, if it is necessary to save the information at the end of working with ram I have to find a way to solve this problem, but it may be possible to read and edit the information temporarily, and eventually need to connect to the Internet to send the information. For example, run the program and during the opening of the program, everything includes adding information, editing and deleting, etc., and at the end, the Internet is needed to send that edit bank in memory,Access Bank is because this bank with software Build different software or design different relationships and queries outside of vb. Also, because working with a database and communicating with the adodc tool is simple, I used the Access Bank as an example. If your problem now is that the data is not stored Is it okay for you to send an instance of a database connection in memory that can support various operations of editing the search delete log by supporting a variety of sql commands
important note : in my sample in #3 i dont created bank at runtime with coding,i jst attached my mdb file (created by office) to my exe so i dont want use time for coding to make access bank in runtime.
The problems I'm still looking for are controls that can also communicate with memory
I'm looking for other examples to change the file in memory but my priority here is the database because it is useful
- For example, reading a video with a large size from memory and play it or edit it
- Read an office file from memory and display it and edit it
- Execute an executable file from memory (antivirus can also be problematic)
- Use ocx from within memory without the need to install on disk
- and various examples like this
Re: Any way to read and write records to "access bank" or sqllite by memory?
Hmmm, self-modify EXE files, read/write bank records, do it all in memory to leave no evidence ... no no, this doesn't smell phishy at all.
Re: Any way to read and write records to "access bank" or sqllite by memory?
Quote:
Originally Posted by
Elroy
Hmmm, self-modify EXE files, read/write bank records, do it all in memory to leave no evidence ... no no, this doesn't smell phishy at all.
u can ask this question in dark web to can find more than 1 answers too haha but am i doing talk about smell or phishy technology :p ?!!! i explained in #5 !!! did u find my another questions many months ago for example about how can play video from memory or load office files and show inside vb from memory!!! its like as theme but thanks for ur codes here :),its ok if u want send a sample code like as phishy maybe i can use it for this thread too :p
maybe i dont need any codes to can solve my problem here jst by using (virtualizations softwares or automations softwares or portable softwares creators) but i ask here to use coding and know more about and more than jst reading from memory.
