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 |
|
jimmiec
Starting Member
1 Post |
 Posted - 2004-03-13 : 03:09:16
|
I am really confused. I created a database in Access 2000, split it and then upsized the backend to MSDE, and linked to the upsized tables. The linked tables now show a globe icon next to them. Also, local tables were created on the backend. I will be putting the backend on a NT server and the front end on about four workstations. Each workstation has a copy of Access 2000. Here's my confusion. The tables that were upsized look the same. The datatypes are the same including autonumber fields. Have I created a MSDE backend? Do I need to install MSDE on each workstation or does MSDE reside within the backend? Under MSDE do all the queries reside on the front end? What am I missing here-everything works great, but I can't believe I've really connected to a MSDE back end. So far it's way to easy. Appreciate all the help and advice I can get.Thanks.jim |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-14 : 18:13:27
|
| The globe icon appears to remind you that the table is a remote linked table and not contained within the Access database. So that's fine. If the application is working, then I'd say you're in good shape. However when you move the MSDE to a new server, you'll then need to update the connection information for the tables. If you've used an ODBC/DSN definition (which I think is the default direction that Access sends you in their wizard) that is simple to do. You just update the ODBC Data Source to point to the new MSDE/server and you're ready to go.You do not need MSDE on each workstation, and in fact I would discourage that to prevent confusion and future headeaches. As long as each workstation has a currend MDAC (Microsoft Data Access Components, i.e. the SQL Server driver used to make the connection) then you're in good shape.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
|
|
|
Really Confused