i also tried experimenting...
i created 120mb access database...
and created 25 of them...
i tried opening all of them..
results are i can connect to them freely no matter how many of them...
but when i open a table...
i can open 5 tables... the 6th one will get an error
when i check taskmanager the neobook app only get less than 2000mb.. or probably the 2gb limit of access..
but its only 5 tables.. or 5 120mb or 600mb of data..
is this the limit of access?
edit:
i tried using
Code: Select all
dbpOpenDatabase "A[looper]DB" "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\RTS Work Files\Access Filesize EXperiment\a[looper].mdb;CursorLocation=Server"
and i successfully opened tables of all 25 test access database..
each of the 25 .accdb are 185,555kb in filesize and has 1,000,000 records inside...
whew*