By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,872 Members | 2,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,872 IT Pros & Developers. It's quick & easy.

Connecting to SQL Database

P: 6
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?
May 10 '07 #1
Share this Question
Share on Google+
5 Replies


JConsulting
Expert 100+
P: 603
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
May 10 '07 #2

P: 6
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.
May 14 '07 #3

JConsulting
Expert 100+
P: 603
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?
May 14 '07 #4

ADezii
Expert 5K+
P: 8,628
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.
May 14 '07 #5

P: 6
Heh, nevermind, it seems that I wasn't able to see the tables because of certain right issues. Thanks for all the help guys!
May 14 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.