how to connect ms access to sql

[RuralGuy]

I wanted my database to be big. because I read an article that ms access is just small.

There is a 2GB limit to each mdb but there in no practical limit to how many mdb's you can have open at the same time. It is not fair to describe Access as small. I believe you need to do a little more research.

[marianne]

ok but how about my previous question?

so does that mean that, on that code presented, the sql server does not exist? but still able to connect to sql tables?

[RuralGuy]

so does that mean that, on that code, sql server does not exist? but still able to connect to sql tables?

I'm pretty sure only SQL Server knows how to run queries on its tables and return records.

[thhui]

You must have a SQL Server installed so that you could connect to it.
Either a MSSQL Server, MSDE, Mysql will go.

[RuralGuy]

Thanks for the input thhui!

[marianne]

if you may read thhui, it was already cleared that yes sql server is needed.

However I provided there a passage from an article that connection can still be established without the dsn. so I am asking for its confirmation if that is true. Coz if that code in that article is true, ms access can connect directly to sql tables without passing sql server.

[Matrix]

If you believe SQL server is really needed for your project, install it first and do some experiments, you really need more research on your side. ODBC is often the last way for DB connection, because most databases can be configured as ODBC data source, and most programming languages can access ODBC data sources.

[thhui]

In fact, ODBC is just one of the common ways to connect front end access to back end sql server.