Troubleshooting question - Access crashes when I copy a row

[Jeff Heikkinen]

If this is the wrong newsgroup for this question, feel free to direct me
to the correct one. I didn't see any obviously better choice.

Anyway, my problem is that whenever I select a row in a certain table
and choose "Copy" from the right-click menu, Access crashes immediately.
There is no error message beyond the standard Windows XP one offering to
send who-knows-what information to Microsoft. Anyone know what might be
causing this?

I am not having any similar problems with any other programs, nor with
copying single cells from the same table. I should mention that just
after a recent incident where I had to reinstall everything on my
computer from the ground up, I had some issues with some .dlls that
Access uses needing to be reregistered, and a few problems due to some
of my old databases having a control in them that I no longer had (it
was not actually used in those databases, and I thought I had fixed all
the problems its little tendrils were causing).

By the way, is there any way (short of exporting to Excel and using
that) to select a range of cells, preferably using the mouse? I can
select one cell or a whole row, but not anything in between, which seems
odd, probably just because I'm more used to Excel.

 

[John Vinson]

By the way, is there any way (short of exporting to Excel and using
that) to select a range of cells, preferably using the mouse? I can
select one cell or a whole row, but not anything in between, which seems
odd, probably just because I'm more used to Excel.

Copy and paste is rarely a good technique in Access... and Access does
not have cells. A Datasheet looks like a spreadsheet, but it's a VERY
different beast!

To create a new record in a table, an Append query is usually the best
approach. Could you explain the nature of the data, and what is is
that you want to copy?

I agree, Access should NOT be crashing; you may have a corrupt Access
install, or perhaps a corrupt database; but I'd suggest that the
method you're using may be partly at fault!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Jeff Heikkinen]

Oh no! It's John Vinson!

Copy and paste is rarely a good technique in Access... and Access does
not have cells. A Datasheet looks like a spreadsheet, but it's a VERY
different beast!

To create a new record in a table, an Append query is usually the best
approach. Could you explain the nature of the data, and what is is
that you want to copy?

Actually, I managed to get it to work. The crash only happens when I
select EXACTLY ONE row; selecting more worked (using the Shift key,
which it turns out works much the same as I'm used to; dragging the
mouse doesn't, nor does the Ctrl key, guess which two methods I tried
first...)

Anyway, it's a collection of spells for a role-playing game. There are
two distinct lists of spells, thus two different tables of them, but
they have many individual spells in common. I wanted to copy the common
ones, then do the necessary changes (a few names and the values in one
field) in a form, after deleting the unnecessary ones. I suppose I could
use one table with all the information for both existing spell tables,
and then use queries to populate the reports to print off for my
players, but to be honest I didn't think of it in time and it would be
more trouble than it's worth to go back and do it now.

I agree, Access should NOT be crashing; you may have a corrupt Access
install, or perhaps a corrupt database; but I'd suggest that the
method you're using may be partly at fault!

Bummer. I've repaired the DB multiple times; if it's potentially corrupt
that's not good news as there's a lot of work in there.

 

[Jeff Boyce]

Pardon my intrusion...

Let's see if I understand this situation ...

You have a collection of spells. When you try to mess with them, your
application becomes haunted and discorporates.

And the question is ...? <G>

Jeff Boyce
<Access MVP>

 

[Lynn Trapp]

You have a collection of spells. When you try to mess with them, your

application becomes haunted and discorporates.

And the question is ...? <G>

<snork>

 

[John Vinson]

Anyway, it's a collection of spells for a role-playing game.

<chuckle> Well, I guess it's good that the Wysard of Information (me)
was the one that happened to answer.

It might not be worth the effort unless this is something that you'll
be doing on an ongoing basis but I'd be inclined to put a command
button on the continuous Form, to clone the record in VBA code or by
running an append query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps