Thank you Joe,
I bought a book, Access to SQL Server which seems pretty good so far and
explained it like you did. I got it installed.
I'm confused about a lot of things, naturally, and hope you can answer this.
Is seems that the way to go is to use an Access Data Project rather than to
link tables from my existing DB. I tried the linking which turned out to be
a big mess becuase there doesn't seem anyway to manage the links.
I created an ADP and imported the object from my existing DB into it, minus
the queries (could I nave just converted my DB to an ADP?). Then I
connected to the SQL database I created testing the table links. I opened a
form copied a query from the working version. It seemed to work fine,
howver, this project has hundreds of forms and queries. Do I need to
recreate them all manually or is there a tool to convert the Access queries?
Thanks if you can help me on this.
"Joe Fallon" <jfallon1nospamtwcny.rr.com> wrote in message
news:ecd11zKWDHA.1280tk2msftngp13.phx.gbl...from> MSDE *is* a version of SQL Server.
> It is the exact same engine.
> It has a couple of tweaks to keep it from being used on a large scale.
> (2GB limit and 5 concurrent processes governor.)
> Check out SQL Server Developer edition - I think MS is dropping the price
> from $449 to $49 soon.
> The tools alone are worth that price! (Enterpise manager, Query yzer,
> Joe Fallon
> Access MVP
> "Mark A. Sam" <msamPlan-It-Earth.Net> wrote in message
> news:evh6IdIWDHA.1280tk2msftngp13.phx.gbl...> opened> > I found out on the Microsoft site that MDSE is on my Office Xp Cd. I> > a readme file which gives instructions for installing SQL Server 2000configure> a> don't> > Cd. Is this a mistake or am I missing something here.
> > If it is a mistake, I want to install MDSE. I'll take a chance that I> > need instruction, but how does Access know it is there? Does it>> > itself to Office automatically?
> > Thank.
> > Mark