Very frustrating: "Unable to create new table. Cannot perform edit. Someone else is currently editing this table"

[Rgermond]

Hello all, I have an error that is extremely frustrating. anyone
happen to know a resolution ot this?

Windows XP SP2. Mapinfo 8.5. Microsoft Access 2000.

Can open the database and create points in mapinfo with no problem.
However, if I try to edit any of the fields in a browser I get:

"Unable to create new table. Cannot perform edit. Someone else is
currently editing this table"

If I try to change the symbols once they are created (like color,
symbol, size...) I get the same error.

Hopefully someone has seen this before and can offer advice.

Thanks in advance.

[David Reid]

One issue I know of, if you simply open the Access table in Mapinfo, and if
you have Access open at the same time, this error will appear due I presume,
both apps attempting to access the *.ldb temp file that is created in the
same directory as the Access db, whenever that db is opened either by Access
or Mapinfo.

I seem to recall Bill Thoen and others discussing opening the Access table
via a linked, DBMS connection to Access. I'm not sure if this resolved the
issue or not. You could search the archives at Directions Magazine for that
post, or hopefully, someone will reply here soon.

David

-----Original Message-----
From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On
Behalf Of Rgermond
Sent: Thursday, March 01, 2007 9:43 AM
To: MapInfo-L
Subject: [MI-L] Very frustrating: "Unable to create new table. Cannot
perform edit. Someone else is currently editing this table"

Hello all, I have an error that is extremely frustrating. anyone happen to
know a resolution ot this?

Windows XP SP2. Mapinfo 8.5. Microsoft Access 2000.

Can open the database and create points in mapinfo with no problem.
However, if I try to edit any of the fields in a browser I get:

"Unable to create new table. Cannot perform edit. Someone else is
currently editing this table"

If I try to change the symbols once they are created (like color, symbol,
size...) I get the same error.

Hopefully someone has seen this before and can offer advice.

Thanks in advance.

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date: 2/27/2007
3:24 PM

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date: 2/27/2007
3:24 PM

[James Strieb]

Hi there,

This problem can also occur if the table you are working with is too big for MapInfo. Columns in MapInfo tables have a character limit of 254, and this number multiplied by the number of columns in the table can not exceed 4096. Tables created in Access are often assigned character limits greater than 254.

If you go Table > Table Maintenance > Table Structure, you can change the character limits on your columns to be as short as appropriate, and you can remove extraneous columns. After that, you will be able to edit the layer.

[BillW]

Can also occur if you have too many indexes set  on this table.  There is a limit of 29 indexes maximum, 28 if you want to be able to edit the table, as MIPro needs to be able to create a temporary one when editing.  If you have 29 indexes set, then MIPro basically 'locks' the table since it cannot create the temp index for editing.

[Maciej Puna]

In the table structure, remove the "Indexed" check box

[David HILPIPRE]

Sorry to barge in so late after the discussion, but trying to save or export a query similar to this one :
SELECT mytable.col1 ", mytable.col2, "" "NewCOL" from mytable
will produce the same message. the culprit is the last column of the query : "" "NewCOL". Removing it will remove the error when saving. As for the explanation, I don't have any. Maybe it has something to do with a wrong field definition for "NewCOL" ? Just trying to guess...

David

[Warren Vick]

Hello David,

 

You have a stray quote after mytable.col1, but perhaps that was just a typo.

 

The third column, which you’ve selected as a blank string rather than anything from a table, already inherently has the name “COL3” and does not need to be explicitly named so. I don’t know if that the reason for the problem, but try changing “COL3” to, say, “blank_field”. There’s also no need to prefix col1 and col2 with ‘mytable.’ unless you have local variables with those names, which you should avoid anyway!

 

Regards,

Warren

 

From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of David HILPIPRE
Sent: 18 July 2017 08:35
To: MapInfo-L <mapi...@googlegroups.com>
Subject: [MI-L] Re: Very frustrating: "Unable to create new table. Cannot perform edit. Someone else is currently editing this table"

 

Sorry to barge in so late after the discussion, but trying to save or export a query similar to this one :

SELECT mytable.col1 ", mytable.col2, "" "COL3" from mytable
will produce the same message. the culprit is the last column of the query : "" "COL3". Removing it will remove the error when saving. As for the explanation, I don't have any...

David

Le jeudi 1 mars 2007 16:43:26 UTC+1, Rgermond a écrit :

Hello all, I have an error that is extremely frustrating.  anyone
happen to know a resolution ot this?

Windows XP SP2.  Mapinfo 8.5.  Microsoft Access 2000.

Can open the database and create points in mapinfo with no problem.
However, if I try to edit any of the fields in a browser I get:

"Unable to create new table.  Cannot perform edit.  Someone else is
currently editing this table"

If I try to change the symbols once they are created (like color,
symbol, size...)  I get the same error.

Hopefully someone has seen this before and can offer advice.

Thanks in advance.

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.