MS ACCESS ERROR 3197
hi skunks every time I try to access this dbase it gives me the below error The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)the MS Access Center are advising me to look for MS Access 97 of which has been so elusive any easier way out, pls help -- Regards martin "Good advice is often confusing, but example is always clear."
---------- Forwarded message ---------- From: maina martin <martinafrique@gmail.com> Date: Fri, May 8, 2009 at 11:29 AM Subject: MS ACCESS ERROR 3197 To: skunkworks@my.co.ke, Skunkworks forum <skunkworks@lists.my.co.ke> hi skunks every time I try to access this dbase it gives me the below error The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)the MS Access Center are advising me to look for MS Access 97 of which has been so elusive any easier way out, pls help -- Regards martin "Good advice is often confusing, but example is always clear." -- Regards martin "Good advice is often confusing, but example is always clear."
Specifics man! What do you mean 'access the database'? From code? Opening the MDB directly? On Fri, May 8, 2009 at 11:57 AM, maina martin <martinafrique@gmail.com>wrote:
---------- Forwarded message ---------- From: maina martin <martinafrique@gmail.com> Date: Fri, May 8, 2009 at 11:29 AM Subject: MS ACCESS ERROR 3197 To: skunkworks@my.co.ke, Skunkworks forum <skunkworks@lists.my.co.ke>
I mean the access database has password so when i try to open it,it gives the below error The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197) hope am clear now
There are 2 usual causes for this 1. Corrupt database 2. Corrupt data in a memo/OLE field You will need to compact and repair the database to resolve this (BACKUP FIRST!) On Fri, May 8, 2009 at 12:27 PM, maina martin <martinafrique@gmail.com>wrote:
I mean the access database has password so when i try to open it,it gives the below error
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197) hope am clear now
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
I have already done that but I end up where I began ....enter password......ok same error The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)
1) What version of access?2) Locate and delete the *.ldb file of the same name then try again On Fri, May 8, 2009 at 12:50 PM, maina martin <martinafrique@gmail.com>wrote:
I have already done that but I end up where I began ....enter password......ok
same error
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
my gmail is in crisis error 500 but am back online access version 2003 I can trace *.ldb file??
I also experienced it. Seems like this was global. http://news.cnet.com/8301-13577_3-10236377-36.html -----Original Message----- From: maina martin <martinafrique@gmail.com> Reply-to: Skunkworks forum <skunkworks@lists.my.co.ke> To: Skunkworks forum <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] Fwd: MS ACCESS ERROR 3197 Date: Fri, 8 May 2009 13:41:26 +0300 my gmail is in crisis error 500 but am back online access version 2003 I can trace *.ldb file?? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
This is a totally honest question; are there people out there using Ms Access as a database? Is there is a business case for using Ms Access instead of the OSS databases? By 2008, lecturers in the campus i was were refusing software projects done using Ms Access, requiring the use of MySQL. And that campus was rather backward in terms of technology. So why would anyone in real life want to use Ms Access? On Fri, May 8, 2009 at 2:24 PM, Alex Nderitu <nderitualex@gmail.com> wrote:
I also experienced it. Seems like this was global.
http://news.cnet.com/8301-13577_3-10236377-36.html
-----Original Message----- From: maina martin <martinafrique@gmail.com> Reply-to: Skunkworks forum <skunkworks@lists.my.co.ke> To: Skunkworks forum <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] Fwd: MS ACCESS ERROR 3197 Date: Fri, 8 May 2009 13:41:26 +0300
my gmail is in crisis error 500 but am back online
access version 2003 I can trace *.ldb file??
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Let me give you a list of reasons.... 1. The MS Access database is available with the MS Office suite of business products (pirated copies freely available) therefore no additional database software is required 2. MS Access database is likely to be available and supported for years to come because Microsoft is the premier software company in the world 3. MS Access is the most widely used desktop database system in the world 4. If database support is important to you then MS Access may be your best choice since it has more support and development consultants than any other desktop database system 5. It is significantly cheaper to implement and maintain compared to larger database systems such as Oracle, MySql (now owned by Sun) or SQL Server 6. Company consulting rates are typically lower for MS Access database consultants compared to Oracle or SQL Server consultants 7. Fairly complex databases can be setup and running in 1/2 the time and cost of other large database systems (the simpler the database the greater the cost advantage) 8. MS Access integrates well with the other members of the MS Office suite of products (Excel, Word, Outlook, etc.) 9. Other software manufacturers are more likely to provide interfaces to MS Access than any other desktop database system. 10. When designed correctly, MS Access databases can be ported (usually with zero difficulty) to SQL Server or Oracle. This is important if you want to start small or develop a pilot database system and then migrate to the larger database management systems 11. An Access database can be placed on a website for access for remote users. Simple screens can be developed within Access, Data Access Pages. Or full control and functionality can be implemented using Active Server Page (ASP) programming. Most of the problems that users have with MS Access and can be replicated with other DBMS are largely due poor relational design, too much duplicated data, no (appropriate) primary keys or attempt to overly control the database forms with custom controls for everything like: deleting records; moving to the next record; adding records (also for external apps coded in VB5/6). Most importantly the selected programming platform by coders determines what they are likely to use. 1. Oracle (has MS Access style forms and scripting) 2. ASP/VB5/6(MS Access/SQL Server) 3. NET(MS focuses on SQL Server coz its not free beggining the step of easing out MS Access which is free) 4. DELPHI (Supports multiple databases internally largely because of a wide component palette and third party vendors. Preffered database application tool for advanced database programmers..Sybase, Blackfish, Interbase, MS Access, SQL Server, My SQL, PostGres, Paradox, Oracle...etc 5. C/C++ (Not sure. Used for system level programming) 6. PHP (MySql, Postgres, SQL Lite) 7. you can add any that I have left out...
pls if you are a true database guru like you claim acces is a simple dbase and MICROSOFT has not faced it out.I did not enqure on the current complex dbase to use I asked for a psecific error problem before you lecture on huge complex dbase give us a solution not your suggestions. whats the way out of the above error boss!!!!!!!!!!!!!!!11
I believe there was a service pack for office 2k3 for the jet database engine, which has a different compact and repair tool. Have you patched your access? On Mon, May 11, 2009 at 1:49 PM, maina martin <martinafrique@gmail.com>wrote:
pls if you are a true database guru like you claim acces is a simple dbase and MICROSOFT has not faced it out.I did not enqure on the current complex dbase to use I asked for a psecific error problem before you lecture on huge complex dbase give us a solution not your suggestions.
whats the way out of the above error boss!!!!!!!!!!!!!!!11
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Is the database in a CD or somewhere you can write to due to permissions? On Mon, May 11, 2009 at 2:01 PM, Rad! <conradakunga@gmail.com> wrote:
I believe there was a service pack for office 2k3 for the jet database engine, which has a different compact and repair tool. Have you patched your access?
On Mon, May 11, 2009 at 1:49 PM, maina martin <martinafrique@gmail.com>wrote:
pls if you are a true database guru like you claim acces is a simple dbase and MICROSOFT has not faced it out.I did not enqure on the current complex dbase to use I asked for a psecific error problem before you lecture on huge complex dbase give us a solution not your suggestions.
whats the way out of the above error boss!!!!!!!!!!!!!!!11
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
I have several ideas.. 1. i can give you a copy of MS Access 97 which you are still looking for 2. you can email me the database to look for myself as the details you are giving arent sufficient to give a concrete solution lastly i have not claimed to be a "database guru" I was only answering a previous post. On 5/11/09, bernard kioko <bernsoft@gmail.com> wrote:
Is the database in a CD or somewhere you can write to due to permissions?
On Mon, May 11, 2009 at 2:01 PM, Rad! <conradakunga@gmail.com> wrote:
I believe there was a service pack for office 2k3 for the jet database engine, which has a different compact and repair tool. Have you patched your access?
On Mon, May 11, 2009 at 1:49 PM, maina martin <martinafrique@gmail.com>wrote:
pls if you are a true database guru like you claim acces is a simple dbase and MICROSOFT has not faced it out.I did not enqure on the current complex dbase to use I asked for a psecific error problem before you lecture on huge complex dbase give us a solution not your suggestions.
whats the way out of the above error boss!!!!!!!!!!!!!!!11
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
sorry jacob that was not meant for *you *it was for the one you were actually answering to "*By 2008, lecturers in the campus i was were refusing software projects done using Ms Access*" please am sorry about it. now in regards to the data I cant zip it for you because it has vital data.but am trying RADS solution. about the details of the error again are as follows.allow me to explain in access you restrict access to data by giving them passwords.ok so thats what i did then once the data got corrupted the application linked to that data began to give the above error. so to get to the problem I got the database,and I tried to open it and ofcourse it asks for the password. After entering the password,...ok instead of opening up,it brings the above error hope am clear now if it works I will let skunks know On Mon, May 11, 2009 at 5:39 PM, Jacob Ayienda <jacobayienda@gmail.com>wrote:
I have several ideas.. 1. i can give you a copy of MS Access 97 which you are still looking for 2. you can email me the database to look for myself as the details you are giving arent sufficient to give a concrete solution
lastly i have not claimed to be a "database guru" I was only answering a previous post.
On 5/11/09, bernard kioko <bernsoft@gmail.com> wrote:
Is the database in a CD or somewhere you can write to due to permissions?
On Mon, May 11, 2009 at 2:01 PM, Rad! <conradakunga@gmail.com> wrote:
I believe there was a service pack for office 2k3 for the jet database engine, which has a different compact and repair tool. Have you patched your access?
On Mon, May 11, 2009 at 1:49 PM, maina martin <martinafrique@gmail.com>wrote:
pls if you are a true database guru like you claim acces is a simple dbase and MICROSOFT has not faced it out.I did not enqure on the current complex dbase to use I asked for a psecific error problem before you lecture on huge complex dbase give us a solution not your suggestions.
whats the way out of the above error boss!!!!!!!!!!!!!!!11
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- Regards martin "Good advice is often confusing, but example is always clear."
participants (6)
-
Alex Nderitu -
bernard kioko -
Jacob Ayienda -
maina martin -
Peter Karunyu -
Rad!