Forms will not save

[Rod]

I'm revising a form and it will not save. When I finish my changes it asks if
I want to save changes and I say yes but it does nothing.

I also have a form that got corrupted somehow every time I open it it give
me a memory error. None of the other form do this and it has happened before.
I constantly have to create new forms just to use my data.

I'm using access 2007 and I've used access for years, I'm very disppointed
with the stability of the product and I'm frustrated.

 

[Arvin Meyer [MVP]]

Have you installed the Service Pack. It fixes a number of problems.

 

[Rod]

Have you installed the Service Pack. It fixes a number of problems.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Rod]

yes

Have you installed the Service Pack. It fixes a number of problems.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

So, here's my instructions for corruption problems:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:

http://www.trigeminal.com/usenet/usenet004.asp

then, compact and recompile, and compact again.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Rod]

the command line in the first solution dos not work

i'm using acces 2007

 

[a a r o n . k e m p f]

if you want to prevent data corruption, you need to move your data to
SQL Server

only through moving to SQL Server can you get a reliable database that
works for multiple users