Zlatko Matiæ said:
All right,
but I already have an ADP aplication with lot of stored procedures and
in-line functions that are record sources for my forms and reports. Now,
If I want to go to MDB it would require that I write all the queries from
the beggining ?
NO NO...you do not want to do that!!! My ONLY point here is that if you got
a mdb, then there is LITTLE need and LITTLE advantage to converting the
application to adp project. No one is suggesting that you try and convert
from a adp to a mdb.
I was using Access as front-end for MSDE and it was very user-friendly way
for designing MSDE database. If I go to MDB I will not be able to design
stored procedures anymore...
You will still be able to design stored procedures etc, and also change
tables etc. However, to do this, you can't use ms-access, but then you need
to use the sql server enterprise tools, or the manager that comes with sql
2005 express. So, yes, you can't create, or manage the table structures from
inside of ms-access anymore. However, web developers have to use the manger
tools. And, c++, or most VB developers also have to learn, and use a set of
management tools to run sql server anyway (this a good (marketable) skill to
learn anyway!!). Often, that server data is going to be used for web stuff,
other developers etc, and even reporting services that sql server has. So,
really, the main advantages of a ADP project is to be able to not have to
use the Enterprise Manager to "manage" SQL server. However, this "problem"
as mentioned is not really such a big problem.
I thought that the .adp is future of Access and now it seems it will
become obsolete very soon...
I am not sure who told you the above!!! ADP's are great for companies do NOT
want any data on each desktop. Further, it does allow users to much more
easily learn/use sql server with ms-access.
Anyway...how to attach my existing MSDE database to SQLEXPRESS?
I believe you can set SQLEXPRESS into sql 2000 compatible mode, and it
should work for you.....
I have not yet tried the above...and am just too busy right now..but I do
plan to try the above asap.