Another set of eyes.....

[phillikl]

Good day,

I have inhereted an Access DB that is used to ask people questions about network maintance. I have been tasked with ripping this thing apart and creating a new version. I have most of everything figured out, but need some advice on the actually query of the questions.

*DB Operation* When the user first uses the db, they create a user profile; login name, password, phone, etc..... They also define which types of networks they administer (over 60 flavors). Once they have completed the profiler, I have a query setup to pull all the questions related to thier types of installed networks. I have several different ways of doing this, but am not quite sure on how to keep the database managable; for performance, size, and programming. As of right now, I have a semi-working If/then statements, but the performance is lacking and I have added about 50 additional network types.

Any Ideas would be greatly appreciated!

Thanks!!

Kendall

[PianoMan64]

Good day,

I have inhereted an Access DB that is used to ask people questions about network maintance. I have been tasked with ripping this thing apart and creating a new version. I have most of everything figured out, but need some advice on the actually query of the questions.

*DB Operation* When the user first uses the db, they create a user profile; login name, password, phone, etc..... They also define which types of networks they administer (over 60 flavors). Once they have completed the profiler, I have a query setup to pull all the questions related to thier types of installed networks. I have several different ways of doing this, but am not quite sure on how to keep the database managable; for performance, size, and programming. As of right now, I have a semi-working If/then statements, but the performance is lacking and I have added about 50 additional network types.

Any Ideas would be greatly appreciated!

Thanks!!

Kendall

Hey Kendall,

First of all, Welcome to Bytes.com

To answer your general question, there are many tweeks that can be done to improve performance. The main one is make sure that all your primary keys are indexe, and searched items are also indexed as well. Making sure that any table lookups and or links are also indexed. Make sure about having cleaning written code.

If you're need more detail about your specific project, it would help if you posted any table structures, queries, VBA code and so on. Then you can feel free to ask any questions that you have about your project.

I hope that helps,

Joe P.

[NeoPa]

If you have 60 or so If/ElseIf statement then you could certainly look at tidying that up.

I would recommend the Select ... Case construct instead, except that if you have this information in a table (you certainly should.) then you should be looking at something SQL based to process through the data.

We would need more details to progress with this, but I'm sure there is scope for improvement.

[phillikl]

Thanks for the help, do to company policy and information I am working with; I am going to have to put this differently from the orginal. Once I get my architecture rebuilt, I will back for questions For Sure!!


Thanks again,

Kendall

[NeoPa]

We'll look forward to that.

Welcome to Bytes!