Filtering/Displaying records from Access in Visual Studio 2008

  • Thread starter Thread starter jazFunk
  • Start date Start date
  • Tags Tags
    Visual
AI Thread Summary
The discussion centers on the challenges faced by a novice-intermediate VB programmer who is transitioning from SQL Server to Microsoft Access for database programming. The user seeks guidance on using SQL statements to load specific records from an Access database based on a job number variable, without retrieving all fields. They need to transfer approximately 3,622 records into another table for further processing. Despite having experience with VB 2005, the user is struggling with object-oriented programming concepts and ADO.NET in Visual Studio 2008. They express confusion over the DataReader object and its compatibility with OleDb connections, highlighting a critical need for resources or advice to overcome these obstacles in their ongoing project.
jazFunk
Messages
12
Reaction score
0
First I must mention that I'm a novice-intermediate VB programmer.

I have a subtle understanding (I bought a book!) of database programming for a SQL Server db. However, I'm using Access and this book simply isn't cutting it.

Any resources/advice to lead me to be able to using SQL statements, displaying records meeting certain criteria, etc. would be very much appreciated.
 
Technology news on Phys.org
Let me be more specific

I need to load records from an existing Access db where [job #] = (variable). I do not want all fields from the specified records. I then want to put those records (3,622 to be precise) into another table for further processing, etc.

I know how to do this in vb 2005. But this oop/ado.net stuff is not sinking in. I now have Visual Studio 2008 and am stuck here.

I have examples which tell me how to do it using SQL Server, but I don't understand why the DataReader object doesn't work with OleDb connections.

I could use some help getting over this major obstacle. I'm right in the middle of a huge project.
 

Thread 'Who is responsible for the software when AI takes over programming?'

I tried a web search "the loss of programming ", and found an article saying that all aspects of writing, developing, and testing software programs will one day all be handled through artificial intelligence. One must wonder then, who is responsible. WHO is responsible for any problems, bugs, deficiencies, or whatever malfunctions which the programs make their users endure? Things may work wrong however the "wrong" happens. AI needs to fix the problems for the users. Any way to...
View full post »

Similar threads

Java Android Studio: Accessing SQLite Data In RecyclerView
Replies
1
Views
3K
I could really use some help picking my optional module [GameDev]
Replies
2
Views
2K
The Scientist as Hero - or not
Replies
1
Views
3K

Hot Threads

Recent Insights

Back
Top