Search results

Thank you brothers for the advice & sharing.

Hi guys I run .mde on .mdb in win 10 all these while, there are no issues. I love old versions of msaccess because it is beautifully light and can serve database needs well. However when i try in on win 11, it seems .mde falters (don;t know what exactly, to be investigated) . I suspect it...

Isla Thanks the connection string to start tinkering.

Thanks Pat. Being very new with SQLite my aim in this thread is I am hoping some forerunner can help & show me the way to link from my msaccess FE to BE SQLite tables WITHOUT using ODBC. The reason is something to do with the registry .INI for each database using ODBC.

Instead of using SQL server my BE is in a SQLite, the FE is msaccess. I want link these tables so they become queries data for forms or reports

Hi help With ODBC we can link to any table in an SQLite database. How to do table link without ODBC eg with Open table

Guys more context For years i wanted to use one of the SQL Server application as my backEnd. I was using accdb or mdb for the BE in an low volume & low users LAN environment. I was reluctant to move because of server overheads. Then watching the android up surge i found a popular BE provider...

I am attracted to SQLite because it LESS many overhèads like server objects. Until I can get it really going the verdict is not out but from my reading I am hopeful to bypass other SQL servers or accdb.

To clarify SQLite is only for BE while FE is msaccess as it very familiar RAD. ODBC will be used to connect to BE

Hi guys Msaccess is great for small guy like me for VB# & SQL debugging, etc in a database environment. Because of Android popularity I am looking for a similar RAD. Any pointers..🙏😊

Hi contributors I have plan to use SQLite because it LESS many things for small projects. Any caveat or advices to drop to my new venture. Thanks brotherhood.

Oh!

Guys Just wonder if anyone has tried putting a split database in OneDrive & mapped it as a Netdrive in a PC for msaccess Front end to access. .pros & cons ?

Hi gurus Let's say I create a database in win 10 PC using SQLite. I believe with the right ODBC driver I can have a front end build with msAccess to use this backend. My project is to use Rad studio xe5 to develop a front end in an Android device. I am now trying to figure out how the...

ok ok Thanks for sharing .. what i mean by better is whether it is high success rate to detect.

Hi Gurus I use Scripting.FileSytemObject (FS) to check if a shared folder "Data" in a "MainPC" in a LAN Workgroup exist .. as in ... FS.FolderExists("\\MainPC\Data\") Is this a good way or is there another better way to do it.

i found the missing file, it was really file MISSING at a location i specified but human error of failing to put it there. pbaldy Esq, your comment out "On Error .." is great help, so easy but need my friend to prompt THANK YOU.

Thank you friends. I will go back to tinkering following all your advices.

Hi guys .. back after a long while to bug you I have a perfectly run .mdb file for years that do some housekeeping script from a module before it end up in a form. In this particular win10 tablet it flag error 53 ..file not found. I try to debug it but can't find the line causing it. Guy...

Folks I finally is seriously moving to SQL server .. need a helping hand I think of doing this with command as part of my codes in a FE. I thus start with mdb as template to import from, into a to be created database in SQL server What are the text commands that can achieve my goals.