Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 23rd, 2004, 01:45 AM
Registered User
 
Join Date: Jan 2004
Location: Adelaide, South Australia, Australia.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Will not save

I have a very large Access 2000 database used by my mechanic. It works well except I am no longer able to make changes. Any simple change to a form tests correctly, the form appears to save, but the changes are gone when MS Access is next restarted. Changes to a module appear to save when I click the "diskette" save icon, but when I come to close the code form it displays the message, "The database Jet database engine could not find the object ''. Make sure the object exists and that you spell its name correctly."
Note the empty single quotes after the word "object".
After clicking OK it displays -
"You tried to commit or rollback a transaction without first beginning a transaction."
This is displayed after editing code - I have not opened the form for display.
It finally comes up with a messae "Do you want to save the changes to the design of the form 'sfPurchaseLines'. After recycling through the messages I have to click no, and loose everything.

The bahaviour is the same on both PCs. Both have 500 meg ram and are over 2000 mhz.
My mechanic purchased new Win XP and Office 2000 because his hardware supplier told him that was where the problem was.

I sure would appreciate help on this one.
  #2 (permalink)  
Old January 25th, 2004, 09:50 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Have you check that the database is not and MDE file. It is possible to be read only and you are restricted from making design changes.

  #3 (permalink)  
Old January 26th, 2004, 04:38 AM
Registered User
 
Join Date: Jan 2004
Location: Adelaide, South Australia, Australia.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by jemacc
 Have you check that the database is not and MDE file. It is possible to be read only and you are restricted from making design changes.

 It is not anMDE file.
  #4 (permalink)  
Old January 26th, 2004, 01:21 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Your problem is not your hardware. Hardware folks do not know a thing about software. It is an Access 2000 problem (known bug). The problem is that MS Access can not find the code file associated with the form. That is the object it can not find. Also this is the reason that you can not save the code. The only way to fix this problem (before your database gets completely corrupted) is to:

-Create a new database
-import all tables and queries.
-Cut the code out of each form that has any code and paste it into a text file.
-under the properties of the form on the old dastabase click on “Has Module and select “No”
-save the form and import it into the new database.
-go into the form on the new database and paste the code on the code window. Save the form.

If you just import all of the items into the new database, the database will also get corrupted. (I know, another Access bug). Never import a form into access if the form contains code. It will corrupt your database.

This process will take some time, but it works (and you do not need to buy anything).

Make sure you keep an untouched copy of your full database before you begin this process.

Hope this works, I have had to do this many times before.




Sal


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to save form Omomani Infopath 0 January 3rd, 2008 06:15 AM
save time umeshtheone Pro VB 6 1 October 23rd, 2007 09:01 AM
save an image ming C# 2005 0 July 11th, 2006 07:14 PM
"Save As" issue patrokolos BOOK: Excel 2003 VBA Programmer's Reference 0 November 18th, 2005 03:35 PM
How do you save a form as is? flyingfox VB.NET 1 May 21st, 2004 03:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.