MS Access data problem on Vista

[BH]

I created an app with BCB 5 that uses an Access 2000 db. The app runs as
expected on XP, but returns the following when I try to run it on Vista:

General SQL error.
Out of Memory.
Alias
Alias: MyAlias.

I've tried several configs in the bdeadmin, but still get the error. What
could be causing this issue? Any and all ideas would be appreciated.

[Bob Swart]

Hi BH,

> I created an app with BCB 5 that uses an Access 2000 db. The app runs as
> expected on XP, but returns the following when I try to run it on Vista:
>
> General SQL error.
> Out of Memory.
> Alias
> Alias: MyAlias.

Alias? You're not using the BDE to "access" your Access 2000 db, are
you? I would expect that you use dbGo for ADO (or ADOExpress as the name
still is in C++Builder 5).

> I've tried several configs in the bdeadmin, but still get the error. What
> could be causing this issue? Any and all ideas would be appreciated.

Could you please confirm if you are using the BDE (which is generally an
issue on Vista) or ADO to work with your Access 2000 db.

Groetjes,
Bob Swart

--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml

[BH]

I created the app with BCB5 Professional (no ADO). I have a User DSN set up
in Windows ODBC Administrator for the Access 2000 db. The Database Name
property for the TTable and TQuery components in the app all point to the
User DSN.

"Bob Swart" <b.s...@chello.nl> wrote in message
news:46C531A7...@chello.nl...

[Bob Swart]

Hi BH,

> I created the app with BCB5 Professional (no ADO). I have a User DSN set up
> in Windows ODBC Administrator for the Access 2000 db. The Database Name
> property for the TTable and TQuery components in the app all point to the
> User DSN.

OK, so you are still using the BDE (ODBC through the BDE, right?).

In that case, if you get an "Out of Memory" error, try increasing the
SHAREDMEMSIZE (using the BDE Administrator tool), for example:

SHAREDMEMSIZE to 16384 (on a 1GB machine)
SHAREDMEMSIZE to 60000 (on a 2GB machine)
MAXBUFSIZE to 20480
MAXFILEHANDLES to 128

[BH]

Bob,

The machine shows 1.8 GB RAM. I tried the settings you suggested for the 1
and 2 GB setups and still get the same errors. I installed an earlier
version of the program that uses Paradox tables and it works as expected
with either setting, but I would still like to get the Access version
working.

"Bob Swart" <b.s...@chello.nl> wrote in message

news:46C7F471...@chello.nl...