Access Shuts Down

[Terence]

Whenever I save a query, Access automatically shuts down.

Can anyone help me with this problem?

Thanks.

 

[RobFMS]

I may recommend that you create a new .MDB and import the objects from your
old .MDB. In some cases (not all), if things get a bit hokie in your
application, it may be that your .MDB is becoming (or is) corrupted.

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Terence]

Rob,

I created a new database and imported the tables and
queries and the new database shuts down when I try to
save. I have even re-installed Access and also some
service packs from Microsoft. This has happened in other
database I use.

Is there anything in the Total Access Developer Suite
2000, that may help me detect the problem.

By looking at your below message I think you work for FMS.

 

[RobFMS]

Trace the problem to determine which object the "shut down" is occurring.
Rather than a corrupt DB, you may be experiencing a corrupt object. Once
found, create a new object and use that new object. Does the corrupt still
occur?

What code is being executed that the "shut down" is occuring? Are you using
Database, Recordset and/or QueryDef objects? If so, are you closing these
objects at the end of your procedure?

Yes, I do work for FMS, Inc.

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-