Two Questions

[Steven Stadelhofer]

Question1:
When copying/pasting a column of data in an access table
I got a message saying 'File Sharing Lock count
exceeded'...'Increase MaxLocksPer file registry entry'
Can you tell me what this message means or what I should
do to resolve?

Question 2.
While trying to run a Crosstab query I got a message
saying 'Property Not Found'. Can you tell me what this
means?

Thanks - let me know if I should make two posts for two
questions - or if it is ok to combine 2 questions on one
post.

 

[John Vinson]

Question1:
When copying/pasting a column of data in an access table
I got a message saying 'File Sharing Lock count
exceeded'...'Increase MaxLocksPer file registry entry'
Can you tell me what this message means or what I should
do to resolve?

Well... don't copy/paste. It's a VERY inefficient way to get data into
Access. Instead, link to the data source and run an Append query.

Question 2.
While trying to run a Crosstab query I got a message
saying 'Property Not Found'. Can you tell me what this
means?

I don't know, because I can't see the query. Please open the Query in
SQL view and post the SQL text here.

Thanks - let me know if I should make two posts for two
questions - or if it is ok to combine 2 questions on one
post.

It's really preferable to keep each thread to one question.

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