Split app problem (1 Viewer)

BobNTN · Sep 2, 2008

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 · Sep 2, 2008

Do you have your sister return what she received to verify that things are truly missing?

BobNTN · Sep 2, 2008

Yes a few times just to make sure.
I think I have eliminated email or zip problems.
Really a weird thing.

MSAccessRookie · Sep 2, 2008

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 · Sep 2, 2008

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 · Sep 2, 2008

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 · Sep 2, 2008

Is it the same version of Access on both ends? What version is that?

BobNTN · Sep 3, 2008

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 · Sep 3, 2008

Hmmm... I'll post back when I come up up with some other ideas.

georgedwilkinson · Sep 3, 2008

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 · Sep 3, 2008

They aren't listed on the menu(switchboard).

RuralGuy · Sep 3, 2008

What code are you using to list the reports on your SwitchBoard?

BobNTN · Sep 3, 2008

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 · Sep 3, 2008

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 · Sep 3, 2008

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 · Sep 3, 2008

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 · Sep 3, 2008

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.

Split app problem (1 Viewer)

BobNTN

Registered User.

RuralGuy

AWF VIP

BobNTN

Registered User.

MSAccessRookie

AWF VIP

BobNTN

Registered User.

gemma-the-husky

Super Moderator

RuralGuy

AWF VIP

BobNTN

Registered User.

RuralGuy

AWF VIP

georgedwilkinson

AWF VIP

BobNTN

Registered User.

RuralGuy

AWF VIP

BobNTN

Registered User.

RuralGuy

AWF VIP

georgedwilkinson

AWF VIP

BobNTN

Registered User.

georgedwilkinson

AWF VIP

Similar threads

Users who are viewing this thread