Does anyone here use MSDE with Access?

[Jozef]

I'm just wondering if anyone here uses MSDE, and if so, do you use ODBC or
is there a better way to connect? I'd like to start using it just because
of it's scalability if nothing else, but would like to know more about it
from experienced developers.

Any help is appreciated.

Thanks!
Jo

[Steve Jorgensen]

On Thu, 26 May 2005 04:47:15 GMT, "Jozef" <NO****@NOSPAM. com> wrote:

I'm just wondering if anyone here uses MSDE, and if so, do you use ODBC or
is there a better way to connect? I'd like to start using it just because
of it's scalability if nothing else, but would like to know more about it
from experienced developers.

Any help is appreciated.

I've used MDSE with both ADPs and MDBs using ODBC, and it works great. The
only problem is that you don't get the SQL Server client tools. Using an ADP
to manage a server database can replace some of what the client tools would
do, but far from all of it.

Many Microsoft developer packages (such as Access 2002 and Office 2002
developer editions) include the Microsoft SQL Server Developer edition, you do
get the client tools with that, and those client tools can manage an MSDE
server just fine. Note that the license will not allow you to use the
developer edition server in your production environment, so you'll still have
to use MSDE for that until you scale up to the SQL Server standard edition.

[Jozef]

Thanks Steve,

Have you ever tried to deploy that arrangement using the Package and
Deployment wizard in Developers Edition? Is the ODBC datasource difficult
to reliably deploy?

Thanks in advance!
Jo

"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:lg******** *************** *********@4ax.c om...

On Thu, 26 May 2005 04:47:15 GMT, "Jozef" <NO****@NOSPAM. com> wrote:

I'm just wondering if anyone here uses MSDE, and if so, do you use ODBC or
is there a better way to connect? I'd like to start using it just because
of it's scalability if nothing else, but would like to know more about it
from experienced developers.

Any help is appreciated.

I've used MDSE with both ADPs and MDBs using ODBC, and it works great.
The
only problem is that you don't get the SQL Server client tools. Using an
ADP
to manage a server database can replace some of what the client tools
would
do, but far from all of it.

Many Microsoft developer packages (such as Access 2002 and Office 2002
developer editions) include the Microsoft SQL Server Developer edition,
you do
get the client tools with that, and those client tools can manage an MSDE
server just fine. Note that the license will not allow you to use the
developer edition server in your production environment, so you'll still
have
to use MSDE for that until you scale up to the SQL Server standard
edition.

[Steve Jorgensen]

On Thu, 26 May 2005 06:40:20 GMT, "Jozef" <NO****@NOSPAM. com> wrote:

Thanks Steve,

Have you ever tried to deploy that arrangement using the Package and
Deployment wizard in Developers Edition? Is the ODBC datasource difficult
No
to reliably deploy?

I don't know. Hopefully, someone else can answer this one for you.

[Jozef]

Thanks Steve,

I don't think anyone else here uses MSDE, by the looks of it, or at least
not in any great capacity....or at least, none that respond. ;)

Thanks again.

Jo

"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:l8******** *************** *********@4ax.c om...

On Thu, 26 May 2005 06:40:20 GMT, "Jozef" <NO****@NOSPAM. com> wrote:

Thanks Steve,

Have you ever tried to deploy that arrangement using the Package and
Deployment wizard in Developers Edition? Is the ODBC datasource difficult

No

to reliably deploy?

I don't know. Hopefully, someone else can answer this one for you.