Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

URGENT PLEASE HELP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hdpink - 16 May 2007 08:56 GMT
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 - 16 May 2007 10:34 GMT
> 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
[quoted text clipped - 8 lines]
> 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.

Signature

Regards,
Chris.
(Remove Elvis's shoes to email me)

BruceM - 16 May 2007 13:05 GMT
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

> In message 8B4B6115-C4B6-4D2E-9CE5-935B25A6FB23@microsoft.com,
> hdpink <hdpink@discussions.microsoft.com> Proclaimed from the tallest
[quoted text clipped - 21 lines]
> to? Service packs, updates to any other software, new installations,
> anti-virus updates/changes... anything? This is where I'd start looking.
hdpink - 17 May 2007 18:20 GMT
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!

> 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?
[quoted text clipped - 28 lines]
> > to? Service packs, updates to any other software, new installations,
> > anti-virus updates/changes... anything? This is where I'd start looking.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.