Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Urgent - Save Disabled

Discussion in 'Information Technology' started by Jim Bunton, Nov 9, 2005.

  1. Jim Bunton

    Jim Bunton
    Expand Collapse
    Guest

    I have Access 97 & Access 2000 installed on win 2000

    I AM UNABLE TO SAVE ANY DATABASES

    If I open an app which hides the database window the save button on the
    toolbar and the save option on the Files menu show active.

    HOWEVER as soon as I open the database window and click on a table then

    The Save Button Greys and the save option on the file menu Greys out!

    VERY BIG HELP!

    Tools > Options No Locks, Open in shared mode

    NB this occurred whilst develpoping an application front end connecting to
    SQL Server.
    The modifications I had made disappeared after closing and reopening the app
    and it has since become unsaveable.
    I then discovered the extent of this 'feature' !!!

    I have
    rebooted
    reinstalled Access 97
    to no avail

    Apart from checking that the same was true of the 2000 installation I had
    not had a 2000 app open for some days.

    Jim Bunton






    Jim Bunton
     
  2. Loading...

    Similar Threads Forum Date
    URGENT PLZZ HELP: KAAM LUST BODY MASSAGE SPA ISSUE Sikh Youth Jul 9, 2015
    Sikh News Spate Of Attacks By Islamist Insurgents Rattle Sikh Community In Pakistan Breaking News Apr 19, 2015
    SciTech Urgent Need to Remove Space Debris Breaking News Apr 25, 2013
    Urgent! Need help with some gender equality questions! Questions and Answers Jan 7, 2013
    General URGENT! Video on reality of sexual grooming gangs in the UK - please share Hard Talk Nov 21, 2012

  3. [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    There are lots of things to troubleshoot....
    1. mdb with Linked tables or ADP with direct connection?
    2. Do you have permissions to the tables?
    3. Is the unsaved change a structure change?
    4. Do you get the warning when opening to design view that the table changes
    cannot be saved?


    --
    Steve Clark, Access MVP
    http://www.fmsinc.com/consulting
    *FREE* Access Tips: http://www.fmsinc.com/free/tips.html

    "Jim Bunton" <jBunton@BlueYonder.co.uk> wrote in message
    news:MI7cf.26785$j5.4435@fe1.news.blueyonder.co.uk...
    >I have Access 97 & Access 2000 installed on win 2000
    >
    > I AM UNABLE TO SAVE ANY DATABASES
    >
    > If I open an app which hides the database window the save button on the
    > toolbar and the save option on the Files menu show active.
    >
    > HOWEVER as soon as I open the database window and click on a table then
    >
    > The Save Button Greys and the save option on the file menu Greys out!
    >
    > VERY BIG HELP!
    >
    > Tools > Options No Locks, Open in shared mode
    >
    > NB this occurred whilst develpoping an application front end connecting to
    > SQL Server.
    > The modifications I had made disappeared after closing and reopening the
    > app
    > and it has since become unsaveable.
    > I then discovered the extent of this 'feature' !!!
    >
    > I have
    > rebooted
    > reinstalled Access 97
    > to no avail
    >
    > Apart from checking that the same was true of the 2000 installation I had
    > not had a 2000 app open for some days.
    >
    > Jim Bunton
    >
    >
    >
    >
    >
    >
    > Jim Bunton
    >
    >
     

Share This Page