Weird Occurence

[Bob]

RePost for Non HTML users...

I have an .adp that was built in 2007 and converted down to 2000.
We have many workstations that have either 2000, 2003 or 2007.
We made some backend SQL Server changes and moved the db
to another server.

Original was 7, new is 2005.

When I change the connection from the previous IP to the New IP,
Nothing worked.. and what I found was that
in the Database window of the project, the Stored procs all showed up
with a semi colon and a 1 after the name of the proc.
Switching the IP back to the original makes the names go back to normal.
Has anyone seen anything like this? Thanks in advance, .. Bob.

 

[Sylvain Lafontaine]

This is an old problem; if I remember correctly, it was because the latest
service pack for Office 2000 has not been installed.

Also, with either ADP or MDB files, mixing versions is a well known way of
having problem: when copying the ADP file to another version of
Office/Windows/Service Pack, you should take the precaution of decompiling
the file on the new machine at the first opening (and not just make a
Compact/Repair).

 

[Bob]

Thanks Sylvain. That is what we found. somehow the service packs on the
machines with the problem, were not up to date. Thanks for the reply.

With regard to the decompile... should I just use the /decompile or is there
a better procedure? Thanks again. Bob.

 

[Robert Morley]

With regard to the decompile... should I just use the /decompile or is there

a better procedure? Thanks again. Bob.

I find adding /decompile to the context menu for MDBs and ADPs to be easiest, but you can also force a decompile by adding a dummy
reference in Tools, References from the code window, click OK, etc., then go back in and remove the reference.



Rob

 

[Bob]

Thanks Rob. I didn't realize that it decompiled when you add references.
I had a weird occurance at one point with Outlook references where I needed
to remove
the reference, then re add it and recompile it. I just didn't realize that
it was actually
decompiled when the reference was removed and re-added.

Thanks for the reply Rob.
Bob.