I have a client that has asked me to modify an existing Access MDB. My
question is they want me to populate their SQL server(2000 I believe). How
can I accomplish this in Access 2000? Are there things I should be aware of
first?

Another question, where can I get a copy of SQL server to test with? Isn't
there a "personal" version I can attain for development purposes? It seems
ridiculous for me to have to "buy" SQL server for testing purposes.
Especially since no more than one user will access it, me.

Thanks in advance...

A2000 and 2002 (and 2003) can connect directly to SQL Server using Projects
(.adp files).
They also support linked tables in .mdb files (the old way).

If you link to the SQL Server tables you can use them in queries just as if
they were Access tables.
So you can write Append queries to "populate" their other tables.

MS dropped the price of SQL Server Developer edition from $449 to $49.
That is a real bargain!!
The Developer edition has full functionality - it is just licensed
differently.
--
Joe Fallon
Access MVP



"Scott Simonson" <(E-Mail Removed)> wrote in message
news:TVL7b.11401$(E-Mail Removed)...
> I have a client that has asked me to modify an existing Access MDB. My
> question is they want me to populate their SQL server(2000 I believe). How
> can I accomplish this in Access 2000? Are there things I should be aware
of
> first?
>
> Another question, where can I get a copy of SQL server to test with? Isn't
> there a "personal" version I can attain for development purposes? It seems
> ridiculous for me to have to "buy" SQL server for testing purposes.
> Especially since no more than one user will access it, me.
>
> Thanks in advance...
>
>

When using ADP files, what makes that different from just running Access? If
I have an Access application can it intermingle with both Access and SQL
server tables?

When linking to a SQL server, what do I do to connect to it? If I select
LINK TABLES, the only option that I think to use is ODBC? Is that correct?

Where is this price and where do I get it?

Thanks...

"Joe Fallon" <(E-Mail Removed)> wrote in message
news:O4JeW$(E-Mail Removed)...
> A2000 and 2002 (and 2003) can connect directly to SQL Server using
Projects
> (.adp files).
> They also support linked tables in .mdb files (the old way).
>
> If you link to the SQL Server tables you can use them in queries just as
if
> they were Access tables.
> So you can write Append queries to "populate" their other tables.
>
> MS dropped the price of SQL Server Developer edition from $449 to $49.
> That is a real bargain!!
> The Developer edition has full functionality - it is just licensed
> differently.
> --
> Joe Fallon
> Access MVP
>
>
>
> "Scott Simonson" <(E-Mail Removed)> wrote in message
> news:TVL7b.11401$(E-Mail Removed)...
> > I have a client that has asked me to modify an existing Access MDB. My
> > question is they want me to populate their SQL server(2000 I believe).
How
> > can I accomplish this in Access 2000? Are there things I should be aware
> of
> > first?
> >
> > Another question, where can I get a copy of SQL server to test with?
Isn't
> > there a "personal" version I can attain for development purposes? It
seems
> > ridiculous for me to have to "buy" SQL server for testing purposes.
> > Especially since no more than one user will access it, me.
> >
> > Thanks in advance...
> >
> >
>
>

ADP files connect directly to SQL Server so you do not have local tables
anymore.
This means that you have to use SQL Server tables (or temp tables) for
things that are per user like configuration information. (When each user had
their own .mdb file the data was local to the .mdb file.)

ADPs let you leverage the power of the SQL Server.
If you aren't really ready for that you can always use .mdb files and linked
ODBC tables.
(I still do all the time.)

You buy SQL Server from Microsoft. <g>
http://www.microsoft.com/sql/howtobuy/development.asp


--
Joe Fallon
Access MVP



"Scott Simonson" <(E-Mail Removed)> wrote in message
news:YUM7b.22390$(E-Mail Removed)...
> When using ADP files, what makes that different from just running Access?
If
> I have an Access application can it intermingle with both Access and SQL
> server tables?
>
> When linking to a SQL server, what do I do to connect to it? If I select
> LINK TABLES, the only option that I think to use is ODBC? Is that correct?
>
> Where is this price and where do I get it?
>
> Thanks...
>
> "Joe Fallon" <(E-Mail Removed)> wrote in message
> news:O4JeW$(E-Mail Removed)...
> > A2000 and 2002 (and 2003) can connect directly to SQL Server using
> Projects
> > (.adp files).
> > They also support linked tables in .mdb files (the old way).
> >
> > If you link to the SQL Server tables you can use them in queries just as
> if
> > they were Access tables.
> > So you can write Append queries to "populate" their other tables.
> >
> > MS dropped the price of SQL Server Developer edition from $449 to $49.
> > That is a real bargain!!
> > The Developer edition has full functionality - it is just licensed
> > differently.
> > --
> > Joe Fallon
> > Access MVP
> >
> >
> >
> > "Scott Simonson" <(E-Mail Removed)> wrote in message
> > news:TVL7b.11401$(E-Mail Removed)...
> > > I have a client that has asked me to modify an existing Access MDB. My
> > > question is they want me to populate their SQL server(2000 I believe).
> How
> > > can I accomplish this in Access 2000? Are there things I should be
aware
> > of
> > > first?
> > >
> > > Another question, where can I get a copy of SQL server to test with?
> Isn't
> > > there a "personal" version I can attain for development purposes? It
> seems
> > > ridiculous for me to have to "buy" SQL server for testing purposes.
> > > Especially since no more than one user will access it, me.
> > >
> > > Thanks in advance...
> > >
> > >
> >
> >
>
>