Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jleiker
Starting Member
13 Posts |
 Posted - 2005-09-23 : 13:24:59
|
| I thought I just posted this but then couldn't find it? oh well...here again...We have an ms access frontend.........upsized the backend tables to sql server. So frontend is linked to an msaccess db containing tables LINKED to Sql server. 3 layers. can this be done? I can't 'see' the tables in the ms access middle layer db to be able to link...here's what was explained to me about why we did it this way...Oh… I just remembered why the backend database was there. You have to create and ODBC DSN to point to the SQL Server database. That’s find for you and me but not fine for 50+ users. The backend database connected with a File DSN so the user wouldn’t have to create a DSN on their computer. And the frontend connected to the backend. Sorry, I forgot about that. Recap- We need—Frontend MS Access database – This is the application that links to the backend databaseBackend MS Access database – This is just the linked tables to the SQL Server database File DSN - This is the ODBC connection to the SQL Server database so every computer that uses the frontend doesn’t have to have a DSN I can setup the backend database and File DSN. Where are the files again? |
|
|
|
|
|
SQL server backend/ms access frontend