Hello,
I have a completely new system (windows xp prof.),
office xp 2002 with sp 3.
When I create a new and empty Accesss database,
create an empty table and then create a new form
using a wizard, Access 2002 crashes when I go to
the next record using the little black arrow at the
bottom of the form...
I get a "send error report to microsoft..." message but this
is of no help for me.
Why? What is the problem and how to fix it?
By the way: If I create a button on the form, access creates code like this:
Private Sub Befehl0_Click()
On Error GoTo Err_Befehl0_Click
DoCmd.GoToRecord , , acNext '==> set breakpoint hier, breakpoint is reached
Exit_Befehl0_Click:
Exit Sub
Err_Befehl0_Click:
'==> this code here is never reached!!!!!!!!!!!!!!!!!!!!!!!!
MsgBox Err.Description
Resume Exit_Befehl0_Click
End Sub
This code does never goto to the label "Err_Befehl0_Click",
which I checked by debugging it using a breakpoint.
So I can't catch this error!!!
After this the database is destroyed, I can not use it any more.
Even the following strategy does not work:
%PATH_TO_ACCESSEXE%\MSAccess.exe /decompile %PATH_TO_ACCESSMDB_FILE%\db1.mdb
The database is repaired, by the problem stays...
Thank you very much for your support. 4 3489
It sounds as if something is corrupted or there is a conflict somewhere.
Things to check:
1) Current Video Driver (yes, even if this is a new machine)
2) www.windowsupdate.com (install the available updates, there will be about
45 MB of updates for a new machine. You can skip the dotNet framework v1.1,
unless you have programs that use dotNet, and other "add-ins" such as Media
Player and Windows Journal Viewer for these testing purposes. You may want
to go back and get them later. If WinXP SP1 is NOT installed, install this
update FIRST.)
3) Run a memory check ( www.memtest86.com or http://oca.microsoft.com/en/windiag.asp)
4) Get the hard drive manufacturer's testing utility and test the hard
drive.
5) Uninstall and Reinstall Office. Run chkdsk in between and clean out your
temp folders (%temp% and %windir%\temp)
--
Wayne Morgan
Microsoft Access MVP
"hinrich" <h.******@printpool-honsel.de> wrote in message
news:75**************************@posting.google.c om... Hello,
I have a completely new system (windows xp prof.), office xp 2002 with sp 3.
When I create a new and empty Accesss database, create an empty table and then create a new form using a wizard, Access 2002 crashes when I go to the next record using the little black arrow at the bottom of the form... I get a "send error report to microsoft..." message but this is of no help for me.
Why? What is the problem and how to fix it?
By the way: If I create a button on the form, access creates code like
this: Private Sub Befehl0_Click() On Error GoTo Err_Befehl0_Click
DoCmd.GoToRecord , , acNext '==> set breakpoint hier, breakpoint is
reached Exit_Befehl0_Click: Exit Sub
Err_Befehl0_Click: '==> this code here is never reached!!!!!!!!!!!!!!!!!!!!!!!! MsgBox Err.Description Resume Exit_Befehl0_Click
End Sub
This code does never goto to the label "Err_Befehl0_Click", which I checked by debugging it using a breakpoint.
So I can't catch this error!!!
After this the database is destroyed, I can not use it any more.
Even the following strategy does not work:
%PATH_TO_ACCESSEXE%\MSAccess.exe /decompile
%PATH_TO_ACCESSMDB_FILE%\db1.mdb The database is repaired, by the problem stays...
Thank you very much for your support. h.******@printpool-honsel.de (hinrich) wrote in message news:<75**************************@posting.google. com>... Hello,
I have a completely new system (windows xp prof.), office xp 2002 with sp 3.
When I create a new and empty Accesss database, create an empty table and then create a new form using a wizard, Access 2002 crashes when I go to the next record using the little black arrow at the bottom of the form... I get a "send error report to microsoft..." message but this is of no help for me.
Why? What is the problem and how to fix it?
By the way: If I create a button on the form, access creates code like this:
Private Sub Befehl0_Click() On Error GoTo Err_Befehl0_Click
DoCmd.GoToRecord , , acNext '==> set breakpoint hier, breakpoint is reached
Exit_Befehl0_Click: Exit Sub
Err_Befehl0_Click: '==> this code here is never reached!!!!!!!!!!!!!!!!!!!!!!!! MsgBox Err.Description Resume Exit_Befehl0_Click
End Sub
This code does never goto to the label "Err_Befehl0_Click", which I checked by debugging it using a breakpoint.
So I can't catch this error!!!
After this the database is destroyed, I can not use it any more.
Even the following strategy does not work:
%PATH_TO_ACCESSEXE%\MSAccess.exe /decompile %PATH_TO_ACCESSMDB_FILE%\db1.mdb
The database is repaired, by the problem stays...
Thank you very much for your support.
+++++++++
Thanks for the hints!
Unfortunately, it's not a problem of my system, rather it must be a
microsoft bug, since we tried it on a notebook and on another desktop
system, the problem stays.
If I create a table, a form for this table using a wizard and then
enter data, now on a different system (the access database was created
on the original pc),
we have the same crash!!!
I will continue doing my work with java, this seems to be a much
better aproach. h.******@printpool-honsel.de (hinrich) wrote in message news:<75**************************@posting.google. com>... Hello,
I have a completely new system (windows xp prof.), office xp 2002 with sp 3.
When I create a new and empty Accesss database, create an empty table and then create a new form using a wizard, Access 2002 crashes when I go to the next record using the little black arrow at the bottom of the form... I get a "send error report to microsoft..." message but this is of no help for me.
Why? What is the problem and how to fix it?
By the way: If I create a button on the form, access creates code like this:
Private Sub Befehl0_Click() On Error GoTo Err_Befehl0_Click
DoCmd.GoToRecord , , acNext '==> set breakpoint hier, breakpoint is reached
Exit_Befehl0_Click: Exit Sub
Err_Befehl0_Click: '==> this code here is never reached!!!!!!!!!!!!!!!!!!!!!!!! MsgBox Err.Description Resume Exit_Befehl0_Click
End Sub
This code does never goto to the label "Err_Befehl0_Click", which I checked by debugging it using a breakpoint.
So I can't catch this error!!!
After this the database is destroyed, I can not use it any more.
Even the following strategy does not work:
%PATH_TO_ACCESSEXE%\MSAccess.exe /decompile %PATH_TO_ACCESSMDB_FILE%\db1.mdb
The database is repaired, by the problem stays...
Thank you very much for your support.
+++++++++
Thanks for the hints!
Unfortunately, it's not a problem of my system, rather it must be a
microsoft bug, since we tried it on a notebook and on another desktop
system, the problem stays.
If I create a table, a form for this table using a wizard and then
enter data, now on a different system (the access database was created
on the original pc),
we have the same crash!!!
I will continue doing my work with java, this seems to be a much
better aproach.
hello,
if I read the help it could be a syntax-error.
"DoCmd.GoToRecord , , acNext" could contain 1 comma too much.
probably if the objecttype-parameter misses it doesn't expect a name
for the objecttype, and instead expexts the record-constant as second
parameter.
"DoCmd.GoToRecord" without parameters should do the same because
acNext is default.
the fact that the error-routine is not reached is probably because
'docmd' calls back the access-runtime and doesn't return to VBA after
the error.
Using the VBA-recordset to manipulate the cursor (or a
clone-recordset) doesn't need to exit VBA-contol and is - i think - a
more robust method if applicable in the context. Al least it gives
better control on error-conditions.
I did not test your problem, but I think this could explain it.
marc h.******@printpool-honsel.de (hinrich) wrote in message news:<75**************************@posting.google. com>... h.******@printpool-honsel.de (hinrich) wrote in message news:<75**************************@posting.google. com>... Hello,
I have a completely new system (windows xp prof.), office xp 2002 with sp 3.
When I create a new and empty Accesss database, create an empty table and then create a new form using a wizard, Access 2002 crashes when I go to the next record using the little black arrow at the bottom of the form... I get a "send error report to microsoft..." message but this is of no help for me.
Why? What is the problem and how to fix it?
By the way: If I create a button on the form, access creates code like this:
Private Sub Befehl0_Click() On Error GoTo Err_Befehl0_Click
DoCmd.GoToRecord , , acNext '==> set breakpoint hier, breakpoint is reached
Exit_Befehl0_Click: Exit Sub
Err_Befehl0_Click: '==> this code here is never reached!!!!!!!!!!!!!!!!!!!!!!!! MsgBox Err.Description Resume Exit_Befehl0_Click
End Sub
This code does never goto to the label "Err_Befehl0_Click", which I checked by debugging it using a breakpoint.
So I can't catch this error!!!
After this the database is destroyed, I can not use it any more.
Even the following strategy does not work:
%PATH_TO_ACCESSEXE%\MSAccess.exe /decompile %PATH_TO_ACCESSMDB_FILE%\db1.mdb
The database is repaired, by the problem stays...
Thank you very much for your support.
+++++++++
Thanks for the hints! Unfortunately, it's not a problem of my system, rather it must be a microsoft bug, since we tried it on a notebook and on another desktop system, the problem stays.
If I create a table, a form for this table using a wizard and then enter data, now on a different system (the access database was created on the original pc), we have the same crash!!!
I will continue doing my work with java, this seems to be a much better aproach. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: JK Peck |
last post by:
I have a fairly large Access application that ran correctly in Access
2000. After upgrading to Access 2003 (and recompiling and updating
references), it reliably crashes at a certain point. If I...
|
by: James P. |
last post by:
Hello there,
I have a bound-form using Navigator so that the user can move back and
forth to update record in the form. Every time a record was modified
and the user clicks the Navigator to...
|
by: danit58 |
last post by:
Anyone use il software ESRI ArcView GIS?????
In a DB Access I store information about plot of land, house and related
ownership.
By click a button in a specific record, I want to open ESRI...
|
by: MS |
last post by:
Access 97 here.
I want a simple way to "lock" certain records on a form. Some records remain
"live" until all data is available which happens over time. When all the
fields are complete, I want...
|
by: Mell via AccessMonster.com |
last post by:
Is there a way to find out where an application was created from?
i.e. - work or home
i.e. - if application sits on a (work) server/network, the IT people know the
application is sitting...
|
by: Frav |
last post by:
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from...
|
by: scsTiger |
last post by:
I am using Access 2000 as the front end and MS SQL 2000 as the backend.
I have a one record form that I set using something like:
strSQL = "SELECT * FROM dbo_WBACCT WHERE...
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I...
|
by: ramprat |
last post by:
I am using a Dlookup to pull a value from my traffic table for a record prior to moving that record to a traffic_history table. I want to take the value and store it in a variable and then populate a...
|
by: MeoLessi9 |
last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
| |