![]() ![]() However: the customer loses knowing where the data is and being able to see it, making changes to data could be less straightforward, backup routines would have to be changed, so I would have to put forward a convincing argument for this.Īt the moment I’m playing with writing some routines as a test to do some comparisons between ODBC and ADODB, but I’m struggling to get it to work with the examples Eugene gave in his post Īs always any thoughts, opinions and comments gratefully received. ![]() It’s going to be faster and the coding appears to be quite similar to what I’ve currently used for ODBC. Technically better in a networked environment. SQLite/Express looks a good option to me from a programming point of view. If we’re to keep these files it looks like it’s got to be either ODBC or ADODB routes. It’s easy to locate the data files for back-up, etc. He can access parts of the data from Word/Excel etc if he wants to with ODBC. accdb files and it’s easy for me to correct mistakes in the ‘raw’ data when he screws things up or needs some amendment made. My customer likes the data being stored in. Try ADODB and see if that’s any better speed wise.Įach option has it’s advantages and disadvantages: Stick with ODBC and put up with slowness.Ģ. DNS or DNS-less seems to make little difference on a test set-up.ġ. Thanks for that Eugene, helpful but doesn’t really move things forward as I’d already gone through the Access Analyzer, Compacting the databases etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |