URGENT PLEASE HELP

[hdpink]

I have an database that i have been developing and zipping and sending to
someone else to use - this has been working fine for some time but for some
reason when i sent it to her last night it seems to have corrupted a little
bit. Some of the controls are showing errors on the forms and some of the
queries have a format function in them and these have changed to say format$
which is of course giving an error.

She sent the same db back to me and apart from the format$ which i altered
the buttons and controls work fine on my pc. Could it be the zipping
process? I zipped and sent it to myself and it was fine. Any idea? the
poor girl is beside herself!

 

[ChrisM]

In message (e-mail address removed),

I have an database that i have been developing and zipping and
sending to someone else to use - this has been working fine for some
time but for some reason when i sent it to her last night it seems to
have corrupted a little bit. Some of the controls are showing errors
on the forms and some of the queries have a format function in them
and these have changed to say format$ which is of course giving an
error.

She sent the same db back to me and apart from the format$ which i
altered the buttons and controls work fine on my pc. Could it be the
zipping process? I zipped and sent it to myself and it was fine.
Any idea? the poor girl is beside herself!

Can't really see how zipping/unzipping the file could cause the kind of
corruption that you are seeing...
I'm assuming you haven't changed anything on your computer? Especially to do
with Access...?

Has ANYTHING changed on the computer of the lady that you send the file to?
Service packs, updates to any other software, new installations, anti-virus
updates/changes... anything? This is where I'd start looking.

 

[BruceM]

It would have helped if you had provided more information about the actual
errors. Are they things like #Name, or are they error messages, or what?
Does the problem with the Format function occur each time the function is
used, or just some of the time?
The person receiving the database could have a references problem. See:
http://allenbrowne.com/ser-38.html

 

[hdpink]

Many thanks - references were exactly it.

I am developing in Access 2007 and she is in 2003 - i had added some code
and added the Outlook 12.0 library but when i looked on hers it said Missing
Outlook 12.0 as she only has 11.1 - i installed on that and it was fine!!

Phew!