Accessing an SQL database with MS Access

looking for the process of accessing an SQL Database through Access

[zolat1]

I am trying to set up Access to access my SQL database and can't remember how. Obviously I haven't touched this portion of it in awhile and need to add this process to my continuity book, but for some reason I can't remember how to set it up. Any help would be appreciated.

[giggle]

If you are trying to upload your MS Access data onto an MSSQL database then you could try using "Import and Export Data" which is a part of MS SQL Server Enterprise Manager.

I also use VisualBasic to upload certain records as they change.

[zolat1]

No that's not what I was trying to do. There is like a "back door" through MS Access to an existing SQL database (Not MySQL). It is hosted on another site and there is a way into it this way. I had it set up on my other computer and didn't have it backed up (first mistake, I know). This site has always helped me so I figured I would present this problem here first. Thank you for your time, I'm sure I will figure something out.

[giggle]

Ah, Zolat, I think that you want to create an ODBC data connection to your SQL database. Then in Access select File > Open > change the selection at the bottom to ODBC Databases and select your SQL ODBC connection.

Hope that works for you...

Mick

<added>Just quickly tried it and it works fine</added>

[zolat1]

Thank you, I don't work with Access that much so don't remember how to use it when I do have to. LOL. Anyway, I figured it out and in case anyone else has this problem, this is how it goes.

open Access
File > New > Project (Existing Database)

It will come up with where you name the file then click ok.

On the connection tab follow the instructions for the database you are trying to connect to. (i.e. db name, username, password, etc.)

Test your connection and if it is a success then all is good and click ok.

Thank you all for your time and input.