how to export odbc information from access 2010

Anonymous

Is there a way to export linked information in access 2010. For instance the odbc, server& database names associated with each table? I found the documenter but that is only for one table and is a mess in excel.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Please post the SQL view of the recordsource of the form and the rowsources of the four combo boxes.

The relationship DOESN'T ACTUALLY MATTER at this point. You do need the relationships, but they won't affect how the form works!

My idea was that you would have tblTablenames with fields (I don't remember and can't scroll back to see them) for AccessDatabaseID, ODBCID, SQLDatabaseID and ServerID, as the Recordsource for your form; the form would not have ANY other tables involved at all. It would have a textbox for the table name and four combo boxes, based on the appropriate tables (AccessDatabases, ODBC, SQLDatabases, Servers) and bound to those four ID fields. You would type in the tablename, and then select the appropriate choices from the four combo boxes. Then you'ld move to the next tablename, and so on.

I haven't any trace of a clue what you mean by "it doesn't work... it shows four records at the bottom".

Again: If you're basing the Form on this multitable query, DON'T. That's not how relationships work, that's not how forms work!!!!

0 comments

Answer accepted by question author

Anonymous

Add fields AccessdbID, ODBCID, SQLdbID and ServerID to tblTableName.

You can then use a Form with combo boxes bound to those fields, based on your database, odbc and SQLdb and Server tables.

It's not quite normalized but a) I think it will meet your current needs and it will be quick and b) it can be used to populate normalized tables if you need to move there.

0 comments

70 additional answers

Anonymous

2012-02-19T01:16:34+00:00

Just bear in mind that there's only ONE table per table. It's not an ODBC table and then a separate Access table; what you see in Access is just a link connecting you to the server table.

If there's an autoID in the server table... that's your primary key; Access will recognize it as such and use it.

Close your eyes, take five deep breaths, and say "I trust my computer..." <g>
Was this answer helpful?

0 comments No comments
Anonymous

2012-02-19T01:59:00+00:00

This is stand alone access. Im not connecting. See im making it hard I know but my kids eating depends on this being a good database. Its just for conversion information no one but us will see it.

I should have made it more clear.

my tables are to be

Servers-> ODBC->Database->AccessName->TableName

We are inputting information the names and locations of all our access databases. We are converting sql servers and all our access databases. We need a listing of the flow from server down to table. That is the information that is going into the database. Its just to help with the conversion so nothing is missed.

I keep having to scrap my databases I can't get them connected right on the tables...ughhh ...i'm such a blonde.
Was this answer helpful?

0 comments No comments
Anonymous

2012-02-19T04:25:37+00:00

Does anyone have a sample database of one to many..many to many ..tables? I've got a deadline and i'm new if i could just see a database get an idea I can move forward with mine. Its five tables all are connected and all only have one field. I'm really desperate and i've never worked in access 2010. If anyone knows of where I can get a sample. Microsofts samples are no help in this situation.
Was this answer helpful?

0 comments No comments