Replies

OK…I found out what you did and it worked for me as well. I’ve already repopulated the revised mdb file with the necessary elements, save one exception: The switchboard. Are there any ways to convert on import a previous version’s switchboard? I can always import the Switcboard Items table, (and even the form itself) but the switchboard fails on open. I have a feeling it is the Office 10 object library, which is nowhere to be found in the references. It’s really funny vbecause it stumbles on compile in the FillOptions() procedure with an “User-defined object not defined” error msgbox. The line that trips it up:
Dim dbs as database

Yes, I can at least copy and paste another instance…so thats fixed.
I still can not compact and repair. Does that work on your system?
Also, it fails on importing objects from another database.
If you can do both of those, I know that it’s a local config issue.

Attached is the stripped-down database per your instructions

The report is based on a parameter query. Just feed it 9/1/06 and 10/30/06

There are two things wrong with this database:
1- I can’t copy this particular report or rename it
2- It won’t compact and repair without raising the macro screen…but that could be a local config issue.

Thanks for the help.

Yes, I checked it out…and I even downloaded the latest recommended Jet SP. When I tried to install, it claimed that my version was newer. That wasn’t too surprising. I have a feeling that this is due to the fact it was created in 97, updated by a user in 2002 and then finally altered by me in 2003, without resolving the initial errors. When my user opens it, she get’s a different error.. bottomline: All I want is the report, so I can save it as another report and move on. Oddly enough the report runs just fine.

NOthing appears to be missing

Right after I posted this, I searched a little deeper and I found all the references to compact/Repair as well as the link to the JET repair tool.
Unfortunately, when I try to implement the repair, I get the macro warning (which I can’t seem to turn off).
I even tried importing the report into another existing database but got this error :
However…when I try to import it into a new database, I get the ole ‘name conflicts with existing blah blah’ error.

I can’t rename this or change it and ‘save as’…this object appears to be dead in the water.

On this same thread, is there an easy way to rename folders (just folders not files) via bat files?
I have a program that has two separate functions (applications).
Unfortunately, they all want claim to the registry and path despite conflicting dlls.

I noticed that by creating a copy of DIR A after Prog1 installs ,and then allowing Prog2 to install over the original DIR,
that I can regain functionality by just renaming the applicable Dir.

Sequence:
Install Prog1 create a copy of DIRA..called “Copy of DIRA”
result: Prog1 works
Install Prog2 allow it to install and register .dlls to DIRA
result: Prog2 works Prog1 doesn’t
rename DIRA to DIR1 rename Copy of DIRA to DIRA
result: Prog1 works again

I realize it’s just a workaround, but if I could automate it by 2 separate batch files, it could be run by the users.

Any ideas?

Not really. There are hundreds of templates in question here. That would take forever. I was thinking that I could run a script that would use a directory as a target and do a “for each” statement and programmatically set the margins to a specific value. Speaking of printer, isn’t it the driver of the printer that sets the last margins value?

Thanks for the tip, J. I used the RegMon utility to some success. However, the key that is being altered is extremely complex. I can’t really see where the change is taking place as it is a multi-string entry at: HKLMSoftwaremicrosoftwindowscurrentversioninternetsettingsconnectionsdefaultconnectionsettings……whew
Whoda thought adding a zone (named parameter no less) would’ve been easier than just flipping a flag?

OK, I got where it is marking itself. Inside the multivalue string it throws in the value !
btw- the binary (hex) values is 3C 6C 6F 63 61 6C 3E 21 or !
The placement in the string is dependent on if you have any sites listed as exceptions.
If you do, it lists the sites first, then the local flag setting, then the name of the proxy and then some program code that the hex editor doesn’t decode.

Since your app probably created it’s own directory in the registry to house the key, try deleting that directory. Another thing to check for is the GUID that is created on install. Try searching for the GUID in your regedit process. Also try HKLM/Software/Installer/Assemblies.

Well, considering it all was working just fine until AROUND the time of the upgrade, I naturally suspect the upgrade. However, it bears mentioning that there may be human error involved as well. This whole thing balances on bi-weekly code pushes with a team of developers on a continuously changing unfrastructure (can we all agree how Novell networks and MS security do not play especially well together?). Also an IT staff (DBAs) that services around 15,000 employees which has had a few reassingments lately. It’s a real security stew around here.

In any case, without .NET this whole thing would have taken many more years in development and millions more in cost. No complaints (well few anyway) on this side about .NET, other than the 1.0 to 1.1 in the middle of the project was a bit quirky…but code base upgrades are always part of the development cycle, as well.
Thanks for the reply.

OK…I found exactly what I needed via a search.
Hey Scripting Guy

I’ve modified the code to do partially what I want, but your code is geared using a case select to look through versions.
I probably could use it, but the case names are much longer and not as clear as MS Office’s enrties.
They have all kinds of quotes and special characters.

I have the path working but I need to detect the following string from the Value Name property of the object:

My_DocumentGenerator,Version=”1.0.1.189″,Culture=”neutral”

These are the locations that make the sRegPre and sRegPost you have in the script:
sRegPre HKLM/software/classes/installer/assemblies
sRegPost = “D|Program Files|MyCo|LACE Document Generator”

OK, good stuff, but the VBS file requires you to keep appending the case statement for every subsequent version created.

I really am looking on how to programmatically modify the entry at the
HKLMSoftwareMicrosoftWindowsCurrentVersionUninstall{CLSID} key.
Specifically, the Display Version and possibly Contact keys

Well, I thought I found out a way:
– Toggle the attrib in the MSI from Read to Write
– add in a version number in the dialog box
– flip the attrib back to read.

Thanks for the help

How about finding and replacing special characters that are not formatting codes? I have a user that want tos replace a bunch of (what appear to be Euro signs) with legal subsection markers. On the charts these would be Alt + 0128 and Alt 0167. Thanks