Yes the backup is failing. I went to a backup in August and that works. There is a button that has an embedded macro on it and that is the only button that works.
The move was made in 2010, so that is not the issue.
Jim Wagner
On Monday, January 6, 2014 7:59 AM, Bryan <bmorris.gm@gmail.com> wrote:
Jim,
Did you say your backup version is failing also? – if so, sounds like a security/trusted program/macro issue, especially if the move was recently made to 2010.
Thanks,
B
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Monday, January 06, 2014 9:52 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing
Sent: Monday, January 06, 2014 9:52 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing
Glenn,
This has been a touchy subject here. I do not think that they will let me do it because it is different and a change. I am at the mercy of the protocol of hesitation. I was able to do it for another department we support and they loved it. But our department is different. We have some that refused to have Office 2010 installed and got away with it for a long time until it became an issue with compatibility.
Jim Wagner
On Monday, January 6, 2014 7:43 AM, Glenn Lloyd <argeedblu@gmail.com> wrote:
Jim,
Even for single users, the application should be split. This enables you to keep an backup on a local system, isolated from the network and other users. This copy can be used as the starting point for future development as well as insurance against catastrophes such as you have just experienced.
As far as I can see, your only remedy is to track down a network backup copy that predates the first occurrence of the failure and start from there. Use that file to create a front end and then link the new frontend to the data. Once you have that working provide the new frontend to the users and link these to the backend. You should also do a compact and repair or the backend. Before you do anything, however, backup your existing files.
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Monday, January 6, 2014 9:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing
Sent: Monday, January 6, 2014 9:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing
Glenn and John,
We support over 50 databases located on a network.Sorry I used that sentence. The database in question is shared between 3 users and it is not split. They are not in the database at the same time. I do have a backup and when I open that, I get the same error messages.
The first message refers to a report that is loading and if I want to continue loading the project. The report is not set up to load at start up.
The next message is about the vba being deleted.
Jim Wagner
On Monday, January 6, 2014 7:03 AM, John Viescas <JohnV@msn.com> wrote:
Jim-
If the "code" part of the database is shared on your network, then that's your problem. Anyone could have done something to corrupt the database. I hope you have a backup!
You could try running decompile against a copy of the database to see if that restores the code. You could also try importing all the objects into a new, empty database.
Best of luck.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 6, 2014, at 2:30 PM, Jim Wagner <luvmymelody@yahoo.com> wrote:
Hello all,
I have been off on vacation for a couple of weeks and I came back to an email from my boss that none of the buttons in one of the databases we support do not work. So I went to the database this morning and no buttons are working. I went to alt -F11 and the vba window came up empty. I went to the onclick event of all the buttons and there is no code between the Private sub and end sub for any of the buttons.
The database is on a network and I have only seen this before when we converted from 2007 to 2010. Far removed from that scenario, I am questioning why I am now playing "Where's Waldo" with the vba code?
I will ask what anyone saw or did, but what do I tell my boss?
Thank You
Jim Wagner
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar