View Full Version : Split app problem
BobNTN 09-02-2008, 10:06 AM I make changes to the front end and send to my sister via email.
Sometimes, when she opens the app, the changes are there, sometimes they are not. Of course, these changes do not affect the back end.
I always have her delete the mde before saving the new version, empty recycle bin, reboot, etc. etc.
I just sent a revised version that I added two reports and changed menu colors. The new colors show up but not the reports.
Anyone have any ideas what causes this ?
RuralGuy 09-02-2008, 11:26 AM Do you have your sister return what she received to verify that things are truly missing?
BobNTN 09-02-2008, 11:56 AM Yes a few times just to make sure.
I think I have eliminated email or zip problems.
Really a weird thing.
MSAccessRookie 09-02-2008, 12:24 PM I assume your mail program saves a copy of "SENT Messages" like mine. Re-open the last email you sent to her and check that the attachment is proper on your end. This procedure should eliminate one end of the process or the other from any primary consideration.
If the attachment is not correct as saved, then the issue is in the preparation of the attachment, and you should be able to locate it.
If the attachment is correct as saved, then your tools should not have any issues. Send the email to yourself two times (at your own email address) and at a 3rd party (like gmail or Yahoo! Mail) email address. If the attachment is OK in both of the emails, then you can eliminate your service provider as an issue as well.
BobNTN 09-02-2008, 12:34 PM OE on both ends
have tried all that - guess I should have said that up front.
Can't see any problem in the zip nor email procedures.
Is there any 'refresh' in Access that could be used ?
gemma-the-husky 09-02-2008, 02:31 PM if its zip file, perhaps there is a problem with the zip file refresh
its hard to see how the menu colors could change though, but the reports not be in the mdb file
try opening a report with code
docmd.openreport("reportname")
to see what error you get
RuralGuy 09-02-2008, 02:52 PM Is it the same version of Access on both ends? What version is that?
BobNTN 09-02-2008, 03:43 PM Exactly the same both ends. 2003
It doesn't do this every time.
I added two reports last week. Sent it three different times. The new reports didn't show up but everything else was fine.
Yesterday, I changed the menu colors and resent it. The color changes show up but the two reports still don't on her end.
Very puzzling.
I have sent and resent, zipped, unzipped, had it sent back, unzipped, works fine here.
Just don't think it is a zip nor email problem, but .....
OE both ends, Power Archiver both ends same version. Win XP and Office 2003 both ends same versions virtually same updates.
RuralGuy 09-02-2008, 03:56 PM Hmmm... I'll post back when I come up up with some other ideas.
georgedwilkinson 09-02-2008, 04:04 PM What is her evidence that the reports are not there:
1. They don't show up in the database window
2. They aren't invoked when she presses the button you set to open them
3. An error comes up
4. A mushroom cloud
Essentially, something you haven't told us is how you know they're not there.
BobNTN 09-03-2008, 12:12 PM They aren't listed on the menu(switchboard).
RuralGuy 09-03-2008, 12:32 PM What code are you using to list the reports on your SwitchBoard?
BobNTN 09-03-2008, 12:35 PM as far as the menus themselves, I just use switchboard manager and edit those.
Not sure what you are asking as for the code I am using.
RuralGuy 09-03-2008, 12:45 PM The SwitchBoard Manager uses a table named "Switchboard Items". Is that table in your FrontEnd or BackEnd? It should to be in the FrontEnd so you can make changes and send a new FE.
georgedwilkinson 09-03-2008, 01:12 PM The switchboard uses a hidden table. If that table is not in the front end you are sending your sister, she will never see the changes to the switchboard.
BobNTN 09-03-2008, 02:01 PM Thanks George
You hit it on the head
I thought all the switchboard stuff resided in the FE.
How can I move that table from the BE or can I ?
georgedwilkinson 09-03-2008, 02:20 PM Create a new table in the FE using a select from the one in the BE (or just import it). Rename or delete the version in the BE and rename the version in the FE. Viola, you're done.
|