PasteAppend - Clipboard not responding

[bwesenberg]

I have created an Access Front End Database that many people in one of the
departments use. Each user has their own copy of the Front End on their
Computer. The Back End is on a SQL Server.

On one of the forms I created a Duplicate Record Button using the Wizard in
Access. I have ONE user who has trouble using this button.

She uses it to copy records over and over and over. Then she changes just a
few pieces of data as needed.

She often gets one of two error messages:
The Clipboard isn't responding, so Commercial Workflow(name of DB) can't
paste the Clipboard's contents.

or

The command or action 'PasteAppend' isn't available now.

I have tried to recreate these errors on my computer with my front end. My
Front End is the master they copy from. But I can not recreate the error.

I did check a few things on her front-end and my front end and found 1
setting different
On the Clipboard there is an options button and the first setting “Show
Office Clipboard Automatically" on my front end is not checked and hers was
checked. I changed that and the next day she was still having problems.

I have done a lot of searching on this and I just keep coming up at a dead
end. Can anyone out there help me?

--
bwesenberg
MOS Master Instructor XP, 2003

[Rich P]

If you are using ODBC to connect to the sql server then that is probably
the source of the problem. The solution is to use ADO with sql server.
With ADO you can retrieve a record from the sql server DB and write that
record to a temp table within the Access mdb and do as you wish with it.
The clipboard should not be an issue.

If you are not an ADO user you can google ADO and get a ton of examples
on connection strings and usage.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[bwesenberg]

Rich,
Thanks for the post. I am using ODBC to connect to the SQL server.
If that is the case then why is it that 40 other people who connect the same
way do not have this issue?
Rich P wrote:

>If you are using ODBC to connect to the sql server then that is probably
the source of the problem. The solution is to use ADO with sql server.
With ADO you can retrieve a record from the sql server DB and write that
record to a temp table within the Access mdb and do as you wish with it.
The clipboard should not be an issue.

If you are not an ADO user you can google ADO and get a ton of examples
on connection strings and usage.

Rich

--
bwesenberg
MOS Master Instructor XP, 2003