ACCESS FEED: Re: [MS_AccessPros] VBA Code is missing

Senin, 06 Januari 2014

Re: [MS_AccessPros] VBA Code is missing

Jim-

If there are some "working" tables that are created and destroyed by your code, then don't put them in the backend database. A Make Table should always be local so that it doesn't destroy what others may be doing at the same time. You could start with all linked tables, but your delete / make table should run just fine. The first time it'll destroy the link. Thereafter, it will delete the local copy - which is what should happen anyway.

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

http://www.viescas.com/

(Paris, France)

On Jan 6, 2014, at 8:08 PM, Jim Wagner <luvmymelody@yahoo.com> wrote:

So I have a question about FE and BE. We have several processes and procedures that have make table queries contained in them. I just split a database and then tried to run the process. It deleted the linked table and then created a new table that is not linked. How do you get around that?

Jim Wagner

On Monday, January 6, 2014 11:16 AM, Jim Wagner <luvmymelody@yahoo.com> wrote:

I have already made several copies

Jim Wagner

On Monday, January 6, 2014 11:12 AM, Glenn Lloyd <argeedblu@gmail.com> wrote:

That's good news Jim. Treat the file they have given you like gold!

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Monday, January 6, 2014 1:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing

IT came through. They must have access to a better backup than we do. IT has always told us to use the Previous version list from the property window. Each one of them was corrupted. I asked IT if they had another way of looking at the files. They must have so it is fixed. I will work on a development of the FE and BE version and see what they say.

Thank You so much for all your help everyone.

Jim Wagner

On Monday, January 6, 2014 10:50 AM, Jim Wagner <luvmymelody@yahoo.com> wrote:

LOL

Jim Wagner

On Monday, January 6, 2014 10:41 AM, John Viescas <JohnV@msn.com> wrote:

Jim-

Your IT guys must all be Republicans. 😃

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
http://www.viescas.com/
(Paris, France)

On Jan 6, 2014, at 5:39 PM, Jim Wagner <luvmymelody@yahoo.com> wrote:

Glenn,

Thank You for the prognosis doc. We found a copy of the database from October. We will go from there. I emailed IT to ask them about it. They do not like Access so they will say something like Access is not good. I tell them every time to give us SQL and they walk away. We have SQL servers but they do not want to give us a place.

Jim Wagner

On Monday, January 6, 2014 9:32 AM, Glenn Lloyd <argeedblu@gmail.com> wrote:

The prognosis doesn't sound good Jim. What if you import everything but the form with the button you mentioned? Backups that pre-date the occurrence of the error "should" be free of the error but there is no guarantee. If you have gone as far back in network backups as you can, I'm not sure what else you can do. Have you asked IT to assist with recovering the file from backup?

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Monday, January 6, 2014 11:10 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing

I tried to do one at a time into a blank database and it causes the errors. I think it is because the vba code is missing.

Jim Wagner

On Monday, January 6, 2014 8:50 AM, Glenn Lloyd <argeedblu@gmail.com> wrote:

Jim,

Did you create a new blank database to import into? Are any modules showing in the database window of the file you are trying to import from?

You may have to try importing the objects one by one.

Missing vba code should not cause name conflict errors.

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Monday, January 6, 2014 10:37 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA Code is missing

I think it is giving me errors because the vba code is missing. Could that be the issue?

Jim Wagner

On , Jim Wagner <luvmymelody@yahoo.com> wrote:
Glenn,

Love your analogy. Pretty harsh but true.

I have tried to import all objects into a empty database and I am getting Name conflict errors.

Name conflicts with existing module, project, or object library.

No current record.

Jim Wagner

On Monday, January 6, 2014 8:21 AM, Glenn Lloyd <argeedblu@gmail.com> wrote:

Unfortunately Jim this is one of those cases where the corrective action is not simply nice as long as everyone agrees they want it. If the databases were implemented using a true database server, it would be a non-issue because the frontend in those cases is always separate from the data storage.

The analogy may be a bit extreme but ask yourself what would happen if the building had to be evacuated during the course of a major meeting. Would you say, "Oh, Ok , you guys can stay where your are if you are not comfortable with leaving just now."

Glenn

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Monday, January 6, 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

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
http://www.viescas.com/
(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