• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

How to set ListBox as Read Only in Access 2000

I am trying to figure out how to make a ListBox's rowsource recordset be Read Only.
I am assumming it is not by default. When opening a recordset using Set RS= "sql string, etc, etc", I know I can specify a dbOpenSnapshot option, but can't figure out how to accomplish this in a SQL statement within Access.

This is an example of how I am defining the row source for the list box:
SqlString="Select * from tblCustomers"
ListBox.Rowsource=" SqlString

I don't want a lock on that table when filling the list box.

Thanks.

0
rfmassa
Asked:
rfmassa
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Can I ask why you need to do this?  By definition, the Row Source of a List box is 'read only' ... in the context of using this SQL in a list box, ie, no data can be changed when connected to a list box.

mx
0
 
rfmassaAuthor Commented:
I am getting record locks when users are accessing this data, and I am trying to make sure this is not the culprit. I was not able to determine if list boxes were read only or if the recordset that opens were read/write (although I saw no reason why they would be, but could not verify this). If they are read only, then I have no issue at this point as the list box must not be the problem.

-Ray
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
List box is definitely not the problem ...

mx
0
 
rfmassaAuthor Commented:
Thank you for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now