?
Solved

Cant save modified code in MS Access

Posted on 2012-08-17
6
Medium Priority
?
326 Views
Last Modified: 2012-08-22
Ive inherited an MS Access front end to a mySQL database.
There is a module that contains code that is supposed to run on the mySQL server rather than ms Access for performance reasons.

SOmething is wrong with it and I need to add some debug code to see whats going on.

However although I can change the code, the save button is greyed out.

Any idea why and how I can overcome it?
0
Comment
Question by:stummj
6 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 38304104
If you close Access entirely, are you prompted to save changes to the module (and if so, do the changes get saved)?

Also, just verifying - are you looking at the Save button in the VBA editor (as opposed to the save button in the main Access window)?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38304114
I don't follow at all.
How can code in your Access app run in a different application?
0
 
LVL 85
ID: 38304115
I occasionally run into issues similar to this. I can edit my code, but Access won't allow me to save it (the button isn't disabled in my case, it just won't save).

The only "fix" I have found is to close/reopen all Access sessions. This works most of the time, but sometimes I've had to reboot my machine entirely. Granted I have multiple development sessions open at once - Access VBA, Excel VBA, Visual Studio, Expressions, etc etc - so that may have something to do with it.
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

Author Comment

by:stummj
ID: 38304148
mbizup - yes it's in the VBA editor
peter57r - you do it by using the conODBC.Execute method
LSMConsulting that is the same symptom - except I can never save it!

More infomation:

In the project window, I can see 3 projects. 2 of them I can't save any code changes, one of them I can. Is this relevent?
0
 

Accepted Solution

by:
stummj earned 0 total points
ID: 38304254
I have solved this now. It is code that is held in a seperate database, but (somehow) linked as an additional project in the codebase.
0
 

Author Closing Comment

by:stummj
ID: 38319576
self solved
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question