Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #12743

Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user

Show all headers | View raw

Does the table has a primary key ?
Are they corrupt ? eg. duplicate

"Patrick Finucane" <patrickfinucanetx@gmail.com> wrote in message 
news:1b368d15-b4ff-4089-98c5-c68ee9bcef45@googlegroups.com...
On Saturday, August 5, 2017 at 12:10:03 PM UTC-4, inso...@gmail.com wrote:
> Op vrijdag 4 augustus 2017 22:25:37 UTC+2 schreef Patrick Finucane:
> > On Friday, August 4, 2017 at 3:19:50 PM UTC-4, inso...@gmail.com wrote:
> > > Hi,
> > > I'm in a large company which is migrating from a windows 32 to 64-bits 
> > > environment. For some reasons the organisation is going to run the 
> > > 32bits version of MSOffice. For years I've maintained a management 
> > > system using a MySQL database-MyODBC(5.3)-MSAccess frontend system. 
> > > This worked perfectly fine in Win2000 and WinXP using Office up to 
> > > 2003. Now in Win10-64bit/Office2010-32bit I run into a problem I 
> > > cannot solve.
> > > Most tables in the MSAccess database are linked. With most tables 
> > > there are no problems. The largest table has few colums, and 600.000+ 
> > > records. I can add records and modify records. There is, however one 
> > > table with a few hundreds of records but with a lot of fields (around 
> > > 80) where I can modify all records up the the 248th row, but any 
> > > record in a row below 248 I get the message that the record is being 
> > > used by another user. The ODBC manager does not drop any line in the 
> > > logs.
> > > Is there anyone who could help me solving this problem. I'm getting a 
> > > bit desperate...
> > > Mike
> >
> > Hi Mike:  I'm ignorant about MySQL so my post is just an attempt to 
> > assist.  Can you compress the backend database?  It would complain about 
> > compression if it were locked by another.  Compression would work if you 
> > are the only user.  If you go to the Navigation window and find the 
> > table, can you open it OK?  Sort OK?  Edit low and high records?  What 
> > happens if you want to modify/update the table structure?  Any software 
> > complaints?  You can only do so with exclusive rights...at least with 
> > Access.
> >
> > It almost sounds like you have a phantom user connected to your db.
>
> Hi Patrick,
> There is no other user, the behaviour is reproducible between the 
> production environment and my local laptop where I run a local copy of the 
> database. When I connect to the database using the ODBC driver with 
> another application I can edit all rows, not only the first 248. I can 
> open the table within msaccess and sort by any field. Even after sorting I 
> can only edit the records which were entered as one of the first 248. The 
> database cannot be compressed, nor can the table structure been edited 
> from within msaccess as the table is linked with an ODBC link. However the 
> table has been checked on the server and is clean and without errors.

Well, my mud throwing failed.  I'd start googling...like msaccess cant edit 
mysql records.  See if any results make sense. 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user insomniux@gmail.com - 2017-08-04 12:19 -0700
  Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user Patrick Finucane <patrickfinucanetx@gmail.com> - 2017-08-04 13:25 -0700
    Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user insomniux@gmail.com - 2017-08-05 09:09 -0700
      Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user Patrick Finucane <patrickfinucanetx@gmail.com> - 2017-08-07 06:46 -0700
        Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user "Phil Hunt" <abc@abc.com> - 2017-08-07 15:53 -0400
  Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user Ulrich Möller <knobbi38@arcor.de> - 2017-08-04 23:36 +0200
    Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user insomniux@gmail.com - 2017-08-05 09:38 -0700
  Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user insomniux@gmail.com - 2017-08-05 09:36 -0700
  Re: Problem in mixed 32/64 bits environment with msaccess 2010: table used by other user insomniux@gmail.com - 2017-08-08 06:56 -0700

csiph-web