Connecting to SQL Database

[dannylam4]

Alright, so the company I'm working at has currently decided that they're going to convert their Access (2003) databases to SQL Databases; that's all simple enough I suppose (that's not my job), but they want to keep their Access as a frontend and the SQL Database as the backend.

So basically, what I'm asking is is there anyway to pull the data from the SQL Database and display it in Access?

[JConsulting]

Alright, so the company I'm working at has currently decided that they're going to convert their Access (2003) databases to SQL Databases; that's all simple enough I suppose (that's not my job), but they want to keep their Access as a frontend and the SQL Database as the backend.

So basically, what I'm asking is is there anyway to pull the data from the SQL Database and display it in Access?

You can link SQL tables just like you can other Access tables.

If you go into File/Get External Data/Link Tables

when it opens the link wizard...look for "Files of Type" ODBC.

now you have to define your ODBC connection.

There's more to it...but you didn't really ask for that much in your Q.
J

[dannylam4]

You can link SQL tables just like you can other Access tables.

If you go into File/Get External Data/Link Tables

when it opens the link wizard...look for "Files of Type" ODBC.

now you have to define your ODBC connection.

There's more to it...but you didn't really ask for that much in your Q.
J

You can't happen to explain what an ODBC is can you? Or how to create one? I'm pretty lost on the subject, and I'm asking the admin of the SQL Server and she has no idea what I'm talking about. We're creating our tables in Microsoft SQL Server's Enterprise Manager, and I'm in Access, I found the server name, and connected to it, but I found no tables.

[JConsulting]

You can't happen to explain what an ODBC is can you? Or how to create one? I'm pretty lost on the subject, and I'm asking the admin of the SQL Server and she has no idea what I'm talking about. We're creating our tables in Microsoft SQL Server's Enterprise Manager, and I'm in Access, I found the server name, and connected to it, but I found no tables.

what did you put in for your DSN?

[ADezii]

Alright, so the company I'm working at has currently decided that they're going to convert their Access (2003) databases to SQL Databases; that's all simple enough I suppose (that's not my job), but they want to keep their Access as a frontend and the SQL Database as the backend.

So basically, what I'm asking is is there anyway to pull the data from the SQL Database and display it in Access?

Look into Access Projects which are specifically designed for Access Front End - SQL Back End architecture.

[dannylam4]

Heh, nevermind, it seems that I wasn't able to see the tables because of certain right issues. Thanks for all the help guys!