Error in edit Subasins Input step (the microsoft access database engine cannot find the input table or query)

farzad emami

unread,

Dec 17, 2015, 7:57:05 PM12/17/15

to ArcSWAT

Dear all,

I hope a happy new year and merry christmas for you without any new error in your SWAT model.

I have faced an error when I was editing the mgt data in my ARCSWAT model.

(I had some crops and I was editing the autoirrigation data subbasin by subbasin.)

In a moment during editing the last subbasins I got the attached error two times.

The problem is the mgt2 table in access file of project is automatically vanished (deleted) in that moment and the mgt menu of model didn't work at all until I copied the mgt2 table from other project access file but the thing is I need the changes to be done.

I searched in the groups and through the web but I couldn't reach any solution yet.

So I would appreciate if you can consult me how to solve this error.

Thank you in advance.

Best Wishes.

Farzad

2015-12-17_17-42-07.jpg

Jim Almendinger

unread,

Dec 18, 2015, 10:48:02 AM12/18/15

to farzad emami, ArcSWAT

Farzad et al. --

If your project database reaches 2GB, the editing capabilities can fail and cause data loss, I think. The only solution is to "compact and repair" the database occasionally before you reach this limit. It's a good idea to make a copy of the project database (or at least critical tables) around just in case things like this happen.

I believe I got this same error last week. I had spent 4 hours carefully modifying management operations in selected HRUs, using ArcSWAT's "edit subbasins" dialog boxes -- when suddenly the process stopped and could no longer find the mgt2 table. During all these edits, the project database had grown huge and had just reached the 2GB limit. I repaired and compacted the database (which reduced its size by about 90%), but I had lost the mgt2 table and all my work. I had a copy of mgt2 from other model runs, so it wasn't a catastrophe, but it was still frustrating.

Remember, a Jedi faces each set-back with calm resolution...

Cheers,

-- Jim

From: "farzad emami" <farza...@gmail.com>
To: "ArcSWAT" <arc...@googlegroups.com>
Sent: Thursday, December 17, 2015 6:57:04 PM
Subject: [ArcSWAT:7782] Error in edit Subasins Input step (the microsoft access database engine cannot find the input table or query)

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.
To post to this group, send email to arc...@googlegroups.com.
Visit this group at https://groups.google.com/group/arcswat.
For more options, visit https://groups.google.com/d/optout.

Spam
Not spam
Forget previous vote

--

Dr. James E. Almendinger
St. Croix Watershed Research Station
Science Museum of Minnesota
16910 152nd St N
Marine on St. Croix, MN 55047
tel: 651-433-5953 ext 19

farzad emami

unread,

Dec 18, 2015, 7:15:41 PM12/18/15

to ArcSWAT

Dear Jim,

Thank you for your reponse.

I have done your recommended solution and the error is fixed.

Furthermore, I am very pleased with your nice last sentence.

Many thanks for your kind support and sympathy.

Cheers,

Farzad

Alieh Saadatpour

unread,

Dec 28, 2015, 8:21:29 AM12/28/15

to ArcSWAT

Hi,
I have the same problem and after I edited the mgt data in my ARCSWAT model, I had updated the database to see the results and I got this error:"the microsoft jet database engine cannot find the input table or query mgt1rng"

My project database file is only 12 MB, I had copied the mgt1 table from other project and compacted and repaired my database but as I update the database the table delete automatically again.