Re: Access and SQL
- From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 11 Jan 2006 19:43:17 -0500
Whenever you upsize an Access/Jet application to SQL Server, you have
to be aware of the fact that data which used to reside on the client
computer now consumes both server and network resources. When
constructing your Access front-end, you need to follow the golden rule
of "fetch only needed data". Never do a 'select * from' or open the
table directly in the UI. FWIW, you would be better off storing the
pictures on a network drive and only storing the path to the file in
the database. OTOH, if you had done that to begin with, then you
wouldn't have had a problem with your Jet database exceeding 2GB.
If you don't want to store the pictures on the file system, then in
your application, only load a single picture on demand, not all of
them at once.
--Mary
On Tue, 10 Jan 2006 13:10:02 -0800, "Scott T"
<ScottT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I have an access database that is currently at the 2GB limit that I would
>like to convert to SQL. I used DTS to load the database into SQL and created
>an .adp project in Access to get at it. The problem occurs when I try and
>open the .adp project it kills whatever PC I am on because it loads the
>entire 2GB database into memory on the client. The database only has one
>table inside it .. but that table contains pictures which constitute the 2GB.
>Why does it try and load the entire table into memory, when before I
>converted it to SQL it loaded just fine?? Any suggestions on improving the
>performance?
.
- Prev by Date: Re: Redistribute Client connectivity components SQL 2005
- Next by Date: Re: Weird One
- Previous by thread: Re: Access and SQL
- Index(es):
Relevant Pages
|
Loading
