Access 2000 connecting to SQL server questions

  • Thread starter Thread starter Scott Simonson
  • Start date Start date
S

Scott Simonson

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.
 
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...
 
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
 
Back
Top