By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,761 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,761 IT Pros & Developers. It's quick & easy.

Does anyone here use MSDE with Access?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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.com...
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.

Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

P: n/a
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.com...
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.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.