how to export odbc information from access 2010

Anonymous
2012-02-17T17:33:20+00:00

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.

Microsoft 365 and Office | Access | For home | Windows

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
2012-02-20T05:56:32+00:00

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!!!!

Was this answer helpful?

0 comments
Answer accepted by question author
Anonymous
2012-02-20T04:33:26+00:00

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.

Was this answer helpful?

0 comments

70 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-02-20T00:13:03+00:00

    Many to many relationships always use junction tables (in Access 1.0, Access 2010, SQL/Server, DB/2, ANY relational database).

    I was suggesting forms with Subforms rather than five standalone independent forms. You can drag a "child" form onto a "parent" form in design view to have Access create a subform, or you can use Form Design view to add a subform from the Toolbox, specifying the correct master/child links (Access will do it for you if you have the relationships).

    You don't need any command buttons. Access gives them to you already, unless you go out of your way to turn them off - the navigation buttons in the lower left of the form. The *> button on the right goes to the new record.

    Having five nested forms may be a real hassle, but having five unlinked independent forms will be a real hassle too! I still have no idea where you're getting the data that will go into these tables, or what order you want to enter the data, so I'm a bit at a loss what to advise.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-02-19T23:34:10+00:00

    OK I created 4 queries...one for each tables except server table and five forms.  On the forms do i add the command buttons for new records or wait till the final form?  That is if this all works.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-02-19T23:19:54+00:00

    I went ahead and did it that way but what do i do know..i'm going to create the forms the way we discussed with just one table.  I'm going to finish that now and hope you have some brilliant idea for me...Wait i know you will.  I have to tell you I sure have learned alot today thanks to your help.

    Was this answer helpful?

    0 comments