By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Access stucks in Before Update

P: n/a
Hello,
I'm moving an Access application to .net +sql server.
First step is to make Access front-end for sql server.
I've moved the tables to the SQL Server and linked them through ODBC.
Mostly it works alright, but ometimes it stucks. It happens like this:
all records on the forms have BeforeUpdate that call SaveChanges
function and it displays "changes ok" message box. Only sometimes it
doesn't get to the message and is stuck.
The strange things are that it happens only once in a while and
sometimes works ok on the same record. And the strangest is that if it
is stuck, but I run some over Access application it continues working
and shows no errors and no sign of problems.

Please help
PS I might crosspost this, sorry. but it is very urgent wince this is
my new job

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I can only ask you is there an error handler in the BeforeUpdate event as:

On Error GoTo ErrorHandler

ErrorHandler:

MsgBox Err.Number &" "& Err.Description

Resume next

Maybe this will help to find out way your application is running into a
trap.

<li*********@gmail.com> schreef in bericht
news:11*********************@f14g2000cwb.googlegro ups.com...
Hello,
I'm moving an Access application to .net +sql server.
First step is to make Access front-end for sql server.
I've moved the tables to the SQL Server and linked them through ODBC.
Mostly it works alright, but ometimes it stucks. It happens like this:
all records on the forms have BeforeUpdate that call SaveChanges
function and it displays "changes ok" message box. Only sometimes it
doesn't get to the message and is stuck.
The strange things are that it happens only once in a while and
sometimes works ok on the same record. And the strangest is that if it
is stuck, but I run some over Access application it continues working
and shows no errors and no sign of problems.

Please help
PS I might crosspost this, sorry. but it is very urgent wince this is
my new job




Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.