converting access 2002 to mssql 8.0

[leah f via AccessMonster.com]

I have been asked to convert an access 2002 application to mssql 8.0 (keeping
the front end in access).

I have searched your site for information.

1)How do I actually transfer the mdb tables to mssql? I could not find this
information in mssql or access.

2)From what I have read on your site, "Simply switching an Access database to
use SQL tables will probably cause a dramatic SLOWING of performance and
likely other problems as well - you'll need to do a fairly thorough redesign.
" What exactly does that mean? What should I be checking?

3)Also from what I understood in your site, simple select queries might be
used as views, but complicated queries (queries calling queries calling
queries…) will need to be rewritten as procedures. Anything to add to this?

4)The forms and reports remain the same, but exactly what is in the script?
Is it possible to give me a brief workplan how to go about this? Will I be
basically rewriting everything?

Thanks for your help.
Leah

 

[aaron.kempf]

Leah

wow.. i would keep things in an Access Data Project.

i just think that MDB linked tables is a waste of time; it does make
thigns slower.

ADP is a LOT faster; a lot easier to manage.

-Aaron