Re: Can't save DB on close

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"John W. Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1f26v3le30pcfhvqcgfvgltkscrmb86fga@xxxxxxxxxx
On Tue, 1 Apr 2008 21:40:20 -0400, "Jan :\)" <abuse@xxxxxxxxxxxxxxxxx> wrote:


Sorry, John, 'saving' may be the wrong word, but, when I exit out of the db
I get a diaglog box that says that the file/locaiton of the db is invalid,
thus it can't close it in the normal manner and it then just shuts down.
I've only been able to get a quick glimpse of the message before it shuts
down, so I'm not able to capture it. When I go to the folder to reopen the
db, it is no longer listed in that folder. When I open Access to try to open
the last db that was opened, it is not in the list. It just disappears, or,
maybe is saved someplace perhaps as a temp file, but, I don't know where.
When I open the backup file it opens fine and it may go along fine for a few
days, then suddenly, the same thing will happen. I have never had this
happen in any of my apps before.

A2007 - which I have *not* yet installed! - is much pickier about security
settings than older versions; and if you have Windows Vista, it also has some
strong opinions about the subject. Do you have *full* privileges to create,
edit, and delete files in the folder containing your database? You need such!

Yes, I do have full admin persmissions, and elevated when necessary. I was on the Vista beta and have fit the battle with the many dragons of the UAC and know them well. :-) And, I am the only one who users the machines here, so I don't need restrictions, but, I have the UAC active.

I would also suggest turning OFF the Compact on Close feature. I'm speculating
that Access is trying to compact; it does so by copying your database to a new
database (named db1.mdb or perhaps database1.mdb, not sure which A2007 uses),
and then deleting the current database and renaming the db1.mdb file. Are
there extra .mdb files in the folder? Does your account have privileges to
delete and rename them?

Yes, that activity is where I do believe the problem is, as it is saying that it can't rename the db and then stops there. So apparently it is deleting it, then saying it can't rename the db, and when I check the folder the original db is no longer there. There is one backup copy of the app in that folder.

The original app was created in 2003, and I have not converted it to the 2007 format yet, as I often access it from another machine that does not yet have the 2007 installed (I know I can install the compatibility pack, but, haven't got that far on that machine yet). My account has full priviledges, and elevated Administrator authorization when required. I have been using this app on this machine in this manner for almost a year now, and this is the first this has ever happened. That is why I wondered if it might be tied to a new Office update, as I did install several updates last week.

I will turn off the Compact on Close for now and see if it happens again. It has only happned twice in the past week. I have several other apps created in 2003 and thus far none have had this happen. Not that it won't, as I don't use them as much, but, was not sure it might also be something with just the one app.

Thanks, John.

Jan :)

--

John W. Vinson [MVP]

.

Relevant Pages

  • Re: Cannot open a project
    ... > I have a dotnet web app that opens & works fine. ... > There's another application on the same server, in a folder below the web ... > work on the server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Cannot open a project
    ... I have a dotnet web app that opens & works fine. ... There's another application on the same server, in a folder below the web ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Help Finding file saved in Temp Internet Files
    ... If you haven't used the app since, you can re-open the application you used ... try Saving another document and see what folder it opens to save. ... recovery, and i've tried to recreate the file path in My computer, ...
    (microsoft.public.windowsxp.help_and_support)
  • Newbie: Saving as Word doc
    ... I've inherited a VB app that experts here say is poorly written. ... Word sees and opens them just fine, they are *not* necessarily Word docs, ... goes back into the folder, opens every doc, and resaves it as a Word doc. ... Set WordDoc = Nothing ...
    (microsoft.public.vb.general.discussion)
  • Re: Microsoft Common Dialog control, version 6.0
    ... Did you try it with a folder on the C: ... Kevin E. wrote: ... "Tom Ogilvy" wrote: ... Microsoft Excel opens the file dialog allowing the user to ...
    (microsoft.public.excel.programming)