Datasheet View

  • Thread starter Thread starter Brian Smither
  • Start date Start date
B

Brian Smither

Here's a complete mystery...

I was using Access 2003 to open and manage an MDB located on a remote
server. In the datasheet view of tables and queries, I've adjusted the
width of the various columns to that which I am comfortable. All OK and
good. The geometries persist.

Then I upsize the table into SQL Server 2005 Express - still on the remote
server. The SSMSE shows the columns all having an equal width. I can adjust
each individual column's width, but the geometries do not persist.

So, I decide to have Access link to SSE - the method chosen was ADP. I
create a brand new .adp file and have it connect to the requisit SSE
database that was just created. New ADP, new SSE tables, new connection...

Guess what? The geometries of the columns (as set by the old MDB table)
manifest themselves in the datasheet view of the (new) SSE table! How does
that happen? And why can't SSMSE honor those geometries?
 
Access ADPs store the table layouts, column widths, etc., in different
properties than SSMSE does. I believe Access is intelligent enough to try
using SSMSE's layout if the Access properties aren't already present, but
SSMSE doesn't try to read Access'.

As to SSMSE, I can't speak to why it's not respecting its own layout, as I
have no experience with SS 2005.


Rob
 
On Mon, 11 Feb 2008 22:13:10 -0500, Robert Morley

Too Many Acronyms.
Frankly I had a hard time following your original post because of all
the abbreviations. And I use this stuff every day...

-Tom.
 
Visitbazaar.com is a secure online shopping mall where you can shop over 200
stores and save up to 60% and more with coupons, deals and discounts. Since
October of 2007, we have helped many customers save money on products &
services ranging from arts and crafts to web services. At Visitbazaar.com,
we are strongly committed to keeping our online mall a safe place to shop
at, and to help our customers save money on a wide selection of products &
services.

My Window is a browser application which increases the internet browsing
speed by applying various compression techniques and protocol optimization.
Reduces the upload and download time in FTP. To switch on MyWindow feature,
log on Visitbazaar.com now.

Regards
Visitbazaar Info
 
Wasn't MY original post. :)
On Mon, 11 Feb 2008 22:13:10 -0500, Robert Morley

Too Many Acronyms.
Frankly I had a hard time following your original post because of all
the abbreviations. And I use this stuff every day...

-Tom.
Click to expand...
 
Back
Top