Search Results

It just requires an additional call at the right place: sql.ExecNonQuery("COMMIT;") See: (Thanks to @jmon https://www.b4x.-and-ucanaccess.62909/post-477390 https://www.b4x.-with-ucanaccess-not-committing-inserts-solved.96142/post-606832
link: I spent quite a bit of time tracking down an error that... wasn't in my project. To prevent you from doing it too... I had to insert many records int

1. Download UCanAccess: https://www.b4x.com/b4j/files/ucanaccess.zip (Sources: https://jackcessencrypt.sourceforge.io/ and http://ucanaccess.sourceforge.net/site.html) The libraries are licensed with Apache 2.0 license: http://www.apache.org/licenses/LICENSE-2.0 2. Copy the jars to the additional l
link: Note that creating a new database will fail when the app is packaged. It will work during development. The solution is simple, put an empty database i
link: Here's a demo for accessing .mdb's on Android: https://www.b4x.com/android/forum/threads/b4a-ucanaccess-demo-works-under-b4j-see-notes.121546/#content
link: Instructions were updated based on a new version of the libraries that will work with B4JPackager11. Note that you need to add several files to the F

The database is being used by the existing program, and conversion to other databases is not allowed. gSQL.Initialize(): This command took too much time. Switch to gSQL.InitializeAsync() always slow.
link: The best solution is to convert the database to a proper engine such as SQLite. Which part is slow? Switch to the async methods. They are simple to u
link: in b4jtest1.mdb. It only takes 2 seconds to execute the above program. But. If there is a table named PLU(only 10 records) and HIST table(have 100,0
link: Just noticed you still have an old *mdb using Jet engine 4. Can you not update to the new Jet engine 12 and use *.accdb. Cheers

i use instructions in this tutorial https://www.b4x.-ms-access-databases-mdb.107963/#content i can read data without any problem ,but when try to insert any new data nothing show in database file -no error return when insert new data -after insert new data ,i can found data with ResultSet ,but afte
link: Hi, maybe (if is not to complicate to build something new) will be better when you switch from ms access to sqllite... It's simple to work with sqlli
link: Have you tried this? https://www.b4x.com/android/forum/threads/b4a-ucanaccess-demo-works-under-b4j-see-notes.121546/ The demo seems to have no issues

As the access database is in your computer, the better solution is to create a server in B4J. Maybe you can start here: https://www.b4x.-ms-access-databases-mdb.107963/
link: You mean DBUtils? Do you create the .mdb file using Jet JRO dll or MS Access? It won't work
link: Hello good people, My sincere apologies for the (probably) dumb question ahead : Can the datautils library handle database files created in vb6 ? (
link: No. Absolutely not. It is not a dumb question either.

I agree... in 90% I am using Access MDB databases with VB6 ....at least 20 years now... and never had bad records... corrupted databases... Also I was using them with asp classic as online db... with concurrent users more than 300 !!!!! :) and worked very well... but not with those superspeeds of t
link: Actually Access can also connect to databases, read / write, and then disconnect, it is not necessary that the connection is always active Even if th
link: I have seen posts regarding MS Access databases being used remotely. The situiation as I understand it is that Access requires a constant connection a

Hi. My requirement is access to a mdb file on the local network. Need to read & write data. Must be able to use an android app to do operations. Can any one help me? I really have tried to do it on my own based on the examples, but I am struggling. Any help will be sincerely appreciated. Fanks gu
link: Morning, David. Can I please ask you to help me with this msaccess file access? I have it working to the point where I can initially read records from
link: Ryan Do send a message if you need help. It was difficult to get it to work with MS Access but I finally got it going. Yes I do program in VB as well
link: Yes it is possible and the way described helps a lot. I have a B4A program which manages a wine storage warehouse which is managed by phones and tabl

Is your .mdb file protected by password? If it is take look at this post: https://www.b4x.-ms-access-databases-mdb.107963/#content EDIT: BTW this dose not look right -> "DBUtils.ExecuteTableView(gSQL, "SELECT * FROM " & CurDBName , Null, 0, TableView_Main)" "CurDBName" indicates your mdb file nam
link: Thanks jerry07 You are right. I started from the "cars.mdb" example where the name of the database AND the name of the table are the same. By putting
link: As a starter tested the example only with the (old format) cars.mdb database. Did another test, using the newer format .accdb using this sample datab
link: Using B4JHowToAccess from #7, the driver connection is now successful Unfortunately, after the first DBUtils.ExecuteTableView(gSQL, "SELECT * FROM "

So connecting to the .mdb is necessary. Is there anything I can do to make the initiailisation quicker, or is this just a limitation of Access &/or UCanAccess?
link: For 115 Mbyte mdb file, on my pc, your routine is completed about 7 sec For 1450 Mbyte accdb file, on my pc, your routine after 2 min (cpu 100%), abor
link: Thanks both for your responses. Yeah, I had seen about the keepMirror setting. Unfortunately the purpose of this app will be to do a one-time conver

This was built for B4A I do not know whether it works for B4J or not https://www.b4x.-library-uses-ms-access-database-files.28373/ If not you can search for a .mdb to sqlite converter .
link: You should use jSQL and the correct JDBC jar file. https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#post-206131
link: Hi, I should create an app that reads data from an old Access database (.mdb). I searched the forum but I could not find anything. Which library use?

Powered by ColBERT