Make a connection to a backend database

[Syerston]

I want to be able to fill a combo box with values from a non local table (an address database (400MB) held on a backend server ).

Is it possible to make a connection and use a "SELECT FROM WHERE" SQL statement to populate the combo box on a form.

I can get it to work from a local table but not from the backend database eg.

SELECT DISTINCT [tblCouncil].[Town], [tblCouncil].[Council] FROM tblCouncil WHERE (([tblCouncil].[Council])=[Forms]![frmMain]![Combo27]);

These statements are placed in the row source of each combo box on the form with each combo box using the value of the previous one to narrow the search.

 

[jebry]

Hi!

I'm not sure that I understand your question. If you need to make a connection to another Db, just select new from the table tab and link. Form there you will be able to link to any database, of a type Access recognizes, that you physically have access to over your network. If you have already established the link and can't write queries against the table, then I am not sure what is happening. After you link to a table, you should be able to query it like normal.

Jeff Bridgham

 

[CosmoKramer]

I don't know if this is your problem, but when I link to a SQL Server db, my table name references must be preceeded by the database owner and an underscore, i.e:

dbo_tblCouncil