Recent content by goJimH

It's late tonight - but will try to revisit. I will review some code I have - the verify's the the network item - before I rely on it. That way - before you leap - you can have some assurance it should be there. Let me know if yo are still interested. Jim H

Pat, Thanks for the heads up. P.S. - After I make my schema changes via DbWeigher - and go back in and test it again - DbWeigher shows the schema's to be the same - but does report any ordinal differences. But as you and others have pointed out - that is just the way it is. Jim H

Pat, You have already been a huge help! Just your sharing about using a 3rd party tool has been a God-send for me. I spent much of Friday searching and looking for such a tool to work with Access databases but really did not find anything – that is until I tried DbWeigher and DataWeigher...

Thank you Dave. I will have to try that out as well. I appreciate your input. Jim

Pat, P.S. I intend to have all the lower code – control the order of the fields. However, to be extra careful (belt and suspenders) – was considering changing the transport for ObjectArray (or itemarray in vb net) to DataRow – and the receiving class parse and accept by field name. Field...

Pat, First of all – thank you!!!!! My situation will be updating remote locations. I think I understood everything you said up until the point “Sadly they only offer Access Support for Data compares”. And appreciate your suggestion of external tools. In the Dos world – I wrote my own...

Pat, You nailed it. I use a database to define all my databases, tables, fields and even extend it to direct screen edits. All my lower db access code is machine generated from this database. And yes – there is one case where I use Select * which is easy enough to fix. If you don’t...

AbbottF got your answers covered. Best of Luck!

Pat, Thank you for your time – and clear response. I was very concerned about the order – as my lower code that accesses the database makes heavy use of object arrays to transport the data in and out my strong-typed net classes. And just one field out of order would be a problem. Since...

Is it possible to direct the placement/order new of fields when modifying an Ms Access database in code? I need to modify the schema of an MS Access database via code – but I want to be able to direct the order or placement of the fields within the tables. For example - if TableOne has 3...

I don't have great experience in VBA but am here because I use Vb Net with Ms Access. There is a learning curve - but it is a lot easier and more powerful that it was back in Net 2003. I use Visual Studio 2010 Professional. And find the debugger to be very powerful and you can add a host of...

Have you tried StackOverFlow? stackoverflow dot com Best of Luck

Nigel, I thank you greatly. And will keep this in mind as a resource. As to my problem - under dead line - the thought of having to back track and rework the tables was daunting. As I thought about it - realized I was doing things backwards. I had two tables - one a monthly file - the...

John Big Booty, Thanks for your quick and helpful reply. The Monthly Seed for the AutoNumber is likely what I will try. I appreciate it. Jim H

In month-end posting - I basically delete all the records from my transaction file. And in doing so - it seems to be resetting the auto number index - which is causing me major problems. This forum has been very helpful - and to my reading - the resetting of the index after deleting all the...