Shop_fld

[Sameer]

How can I edit SHOP_FLD for all catalogs at a time?
I want to make SHOP_FLD =1 for all first, and then = 2 for some components.
I have created access linked file, but i am not very sure how can I edit all tables at a time!!!

thanx and regards,

Sameer

[awerning]

You can't. You can only run queries on one table at a time (in this case anyway). Should be able to run a find-and-replace limited to that single field (SHOP_FLD) and set your find = * and replace = 1. Again though, you are going to have to do it on each table in each catalog one at a time. Then you can move on to changing the ones you desire to 2.

Having said that, there is a VB.NET app that I have written on my own time that I plan on selling through davetyner.com probably for around $30. It is a multi-.mdb file find and replace tool. With this tool you will be able to select as many .mdb files as you want and then select the field that you would like to run your find-and-replace on, and then lastly, set your find-and-replace values. Should be EXACTLY what you need. It works super slick! Now, if Dave would just get his software sales up and running we could start distributing!

However, if you would like to PM or email me, I might be interested in adding you to the beta group. Let me know...

[Sameer]

Thanx Aaron°
Provide me more information about your VB.NET application.
Like how it works...is it just find & replace or we can run sql queries also?

Sameer

[awerning]

I have attached a screen print of the dialog...hopefully it should tell answer most of your questions. At the moment it is just a simple find-and-replace on the fields selected. There is a slight addition that I have been adding in which you will be able to refine the scope of the records that the find-and-replace is performed on (the "Advanced Query" section in the dialog attached...but it is still under development). In a sense, it will be creating the WHERE clauses in the background. I have another test tool that can script a bunch of queries onto the list of selected .mdb files, but I have not incorporated that functionality into this tool at this time (maybe a future upgrade).

[Sameer]

Cool!
But I will not be able to use it without "where" clause, specially when I want to change something with facing/end/gtype/stype criteria.
let me know when it is ready to use with where clause I would like to buy it.
and I hope there is no restriction of no. of tables you can modify at a time?

Thanx & regards,

Sameer

[Sameer]

Shop_fld
Hi Aaron,

Any development?

Pl. let me know how can I buy this?

Thanx and regards,

Sameer

[awerning]

I have been working to add the where clause functionality you requested (and then I got side tracked for the week). I should have something ready for you to work with on Monday. I am going to give it to you for free as a beta copy since the where clause functionality isn't fully tested yet.

So there is my disclaimer...
Would I use it on my company's databases? Yes! (because I hate doing manual database work) But I would make a backup of them first and then inspect the results throughly afterwords to make sure everything happened correctly.

But I can't think of anything bad that can happen at the moment. With how the program is written, it just creates SQL queries and then runs them on the databases. You can preview them before you run them (just to check). And worse case scenario is that the query just does nothing. Thats what I have seen anyway.

[Sameer]

Great!

Will it be possible for you to diliver it by email? You can send it on frsfrs11@yahoo.ca

Thanx a ton!

Sameer

[awerning]

Yep...should have it to you shortly.

[awerning]

...annnd sent.

Save the file to your computer and rename it by taking the underscore “_” off of the end. No install is necessary (I think, let me know if it doesn’t work).

As I said above, this is a beta (more like alpha) release for you. I do not warrant that the operation of this program will be uninterrupted or error free. Let me know what you find though (if anything) and I will get it fixed up and send you an update. Also, if you have any suggestions of interface or program enhancements, feel free to let me know. Now is when the suggestions can really shape this tool and make it real useful.

[Aplant Monkey]

you already have my major suggestion Aaron... make it so that I can copy and change items without overwriting the existing items.

that would be kick arse!