SQLEXPRESS and Access Projects ?

[Zlatko Matiæ]

I tried to migrate (attach) a database from MSDE (MS Office XP D) to new
beta SQLEXPRESS using MS Access (.adp), but it seems that Access Project
can't recognize existence of SQLEXPRESS although SQL Computer MAnager shows
that the Server is working regulary...Installataion of SQLEXPRESS was
successful, without any problem...
Any idea?
Does Access support SQLEXPRESS, as replacement for MSDE ? MAybe the problem
lies in .NET framwork 2.0 beta that is required for SQLEXPRESS ?

Does anyone have success in connection to SQLEXPRESS ?

Thanks.

 

[Jesse Aviles]

If I remember correctly, Access XP doesn't recognize SQLExpress. You are better off keeping the
MSDE.

 

[Zlatko Matiæ]

Really?
Oh, I was so enthusiastic about it

If I remember correctly, Access XP doesn't recognize SQLExpress. You are
better off keeping the MSDE.

--
Jesse Avilés
(e-mail address removed)

Reply Only To The Newsgroup

 

[Albert D. Kallal]

You can still used linked tables, and still use ado reocrdsets.....

I mean, a adp project is really only useful if you are writing a new
application from scratch. However, there is little loss by using a standard
mdb, and using linked tables...they work very well, and in many cases the
added troubles of using a adp is not worth the extra trouble anyway.
Further, with a mdb you can still have local tables etc..which you can't
have with a adp.

For an existing ms-access application, I would go to linked tables..and not
bother with a adp project. You should be able to get very good results using
this approach, and the sql express is MUCH better then the desktop msde (no
throttle for example!).

 

[Zlatko Matiæ]

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 ?
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...
I thought that the .adp is future of Access and now it seems it will become
obsolete very soon...

Anyway...how to attach my existing MSDE database to SQLEXPRESS?

 

[Albert D. Kallal]

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.