Re: Access and SQL
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Tue, 10 Jan 2006 16:52:21 -0500
I suspect this is really an Access issue so you would probably get a better
answer if you post in an Access NG. But do you issue a SELECT with no WHERE
clause anywhere? Do you have Primary Key constraints defined on the table?
--
Andrew J. Kelly SQL MVP
"Scott T" <ScottT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:28282103-A602-48A8-AACB-8BCADE1336E2@xxxxxxxxxxxxxxxx
>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: login failed db-library network
- Next by Date: Re: Redistribute Client connectivity components SQL 2005
- Previous by thread: Re: login failed db-library network
- Next by thread: Re: Access and SQL
- Index(es):
Relevant Pages
|
Loading
