Rt Click on Table Name - "Select Top 1000 Rows" OR "Edit Top 200 Rows"
OR, Probably more to your liking:On your workstation, create an ODBC Connection to your new server and database. When it asks you for server name, you'll need to use the format SERVER\DB INSTANCE.
If I remember right, this value is pretty obvious from the SQL Mgmt Studio... I think it shows it when you click on the server name.
Once the ODBC connection is made, open a new Access database. You want to create new tables via linking to an external data source.
I attached what it looks like in Access 2007. This should let you browse to your new ODBC connection and select all the tables you would like to connect to. You want to LINK tables, NOT import.
Once they're linked, you can run queries, forms, reports... all your usual Access magic, but the data is really stored in the SQL Server.
btw, it drives Curtis nuts when I do this... he says anything new should be web based, but I say that every tool has it's place. ;)
Later, Abe On 9/14/2010 10:01 AM, Rickey Oeth wrote:
Looking to move some data from Access to MS SQL Server 2008R2 to update some ColdFusion websites. I found out that the x64 version of ColdFusion doesn't support poor old Access (imagine that). MS SQL Server 2008R2 installed easy enough, I can create the databases, tables, etc. Importing from Access is straight forward. Call me wimpy but I'd like to access (no pun intended) the SQL data in the grid format Access has. I can't seem to figure that out. Is this possible in MS SQL Server 2008R2? Rickey Oeth Sparta CUSD #140 Sparta, Illinois | Subscription info at http://www.tech-geeks.org |
<<attachment: Clipboard01.gif>>
| Subscription info at http://www.tech-geeks.org |
