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

Best Practices to access a MS Access database from VB

It's been a while since the last time I've been using VB .Net, and now I'm in the situation of requiring to access an MS Access database.

Back then to the days when I was a noob, I used to use a custom SQL string to perform everything from Select to Updates, ecc. ecc.
Is there a better way to do things? Do you, mighty Experts, know a more efficient and elegant way to do this?
0
Emanuele_Ciriachi
Asked:
Emanuele_Ciriachi
  • 4
  • 3
2 Solutions
 
CodeCruiserCommented:
Depends on the size and type of project, your skills, and time scales etc. The best practice for large projects is to divide it into independent layers especially separating the Data Layer.
0
 
Emanuele_CiriachiAuthor Commented:
This is a small project; I am a senior developer, but my specific experience with VB .Net could at best be described as intermediate.

Only one user at a time will use this application.
0
 
CodeCruiserCommented:
You have the option of using the SQL Statements from the program or saving queries in Access and then just calling from the program.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Emanuele_CiriachiAuthor Commented:
These queries can be parametrised? Is there any sort of performance improvement in using them?
0
 
CodeCruiserCommented:
There is security improvements at least. There is definitely performance improvement when using stored procedures in sql server but I am not sure about performance of access queries.

http://support.microsoft.com/kb/209126
0
 
Emanuele_CiriachiAuthor Commented:
Ok, last question: can those saved queries be parametrised, in a similar manner to the way you define input and output parameters in stored procedures in other databases?
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: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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