What do I need to do to upload MSAccess Database to SQL Server and make it searchable and limit ..

[santapro]

11/9/04

Total newbie here as far as SQL. I have a MDB with 250 records, each with 75 fields. I want to make it searchable using a combination of 1, 2, or 3 fields max with a limitation on viewing results to only 10 results per query. Please give me guidance as to what book or books or other resources will be very clear and direct for a "newbie". Time is important consideration, and if you think it would take longer than 8 hours for me to do, please indicate what I should ask for as far as paid help to accomplish the above. Thanks a lot. Paul

[tommyuk04]

Hi Paul,

Are the fields you want to search the same fields all the time?

What language (asp, .net etc?) is this to be in?

If the fields are the same then I'm sure it could be accomplished quite quickly with knowledge of the particular language.

Tom

[santapro]

Thank you Tom for your reply.

The database I am using is large. It is some 250 records each with 85 fields.
With this size of main databaase, I am looking to create a form with checkboxes, to be selected by the viewer in any combinattion, to search for the matching fields of interest.

This is well beyond me but guidance into a direction would be helpful.

Thanks again,
Paul.

[tommyuk04]

Paul,


Firstly, I would expect this to take more than 8 hours due to the sheer number of fields, can this be reduced?


I don't know your programming skills, the sql would probably be quite simple but the underlying forms using any language would take some time to set up, with 85 search fields and this leads to me my second point. Assuming the fields have data and not a yes/no then you need (as you already know) a two stage process, firstly to select the search fields and then the search criteria. This could be optimised in one large form depending onthe field types and the yes/no ratio to text etc. but this depends on the data structure.


This is quite a reasonable size database I would say, with 250 records thus I expect no problemsthat issue.. (how large is the .mdb file anyway)


Tom