Results 1 to 5 of 5
  1. #1
    wawinc is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2010
    Posts
    5

    Changing the name of a record source - it wont save...

    I have changed the name of a record source. When I open the form I get a standard error msg: The record source "queryname" specified on this report does not exist.... Click the Properties button and then set the RecordSource property to an existing table or query.

    I do that, and Access wont allow me to save the report. Clicking save does not work. The only way to close out of the report is disgard changes and click 'No' to the 'Do you want to save?' popup.



    This also happens when I attempt to change the caption...go figure.

    Can anyone help?

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    is there anything that you can change and save?

  3. #3
    wawinc is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2010
    Posts
    5
    Quote Originally Posted by weekend00 View Post
    is there anything that you can change and save?
    No - no changes can be saved.

    Usually I'd try to recreate the query/form or report from scratch. But this one was designed by someone else, and I dont know how.

    Any fix's? (Please, please, this is one of the key reports for our annual financials...)

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    maybe fiel mdb file is read only, or insufficient priviledge to write.

  5. #5
    wawinc is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2010
    Posts
    5
    Quote Originally Posted by weekend00 View Post
    maybe fiel mdb file is read only, or insufficient priviledge to write.
    Never has been before. I am the only user of the database. If this is the case, how can I fix it/change it?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-29-2010, 11:16 AM
  2. change print preview record source
    By alaric01 in forum Reports
    Replies: 10
    Last Post: 10-07-2010, 09:51 AM
  3. Duplicate Record Cannot Save
    By magicscreen in forum Programming
    Replies: 2
    Last Post: 09-15-2010, 08:15 AM
  4. Forms' Record Source
    By Progress2007 in forum Programming
    Replies: 11
    Last Post: 07-27-2009, 11:04 AM
  5. Changing the record source in a form
    By lmichaud in forum Forms
    Replies: 1
    Last Post: 07-09-2006, 09:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums