Oracle link to Access 2000

A

Angie

Does anyone know what versions of Oracle will work with
Access 2000? I just recently converted the database from
97 to 2000. In 97, the oracle linked tables worked just
fine. Once I open the tables in 2000, I get the following
memory error,

ODBC-call failed
[Microsoft][ODBC Driver Manager]Memory allocation failure
(#0)

Any help would be greatly appreciated.
 
J

Joe Fallon

I have used Oracle 8, 8i and 9i with many versions of Access.
Tryit on a different PC and see if there is a problem.
Perhaps it is your machine. (These are the most troublesome bugs to fix!)
 
A

Angie

In my case, I need to figure out a solution with Access
2000 and Oracle 7.3.2. I am upgrading a company database
that is located on a shared network. The company has
recently decided to invest in upgrading the PC's to 2000
but not Oracle at this time. Do you have any suggestions
for using Oracle 7.3.2?

Thank You,
Angie
-----Original Message-----
I have used Oracle 8, 8i and 9i with many versions of Access.
Tryit on a different PC and see if there is a problem.
Perhaps it is your machine. (These are the most troublesome bugs to fix!)
--
Joe Fallon
Access MVP



Does anyone know what versions of Oracle will work with
Access 2000? I just recently converted the database from
97 to 2000. In 97, the oracle linked tables worked just
fine. Once I open the tables in 2000, I get the following
memory error,

ODBC-call failed
[Microsoft][ODBC Driver Manager]Memory allocation failure
(#0)

Any help would be greatly appreciated.


.
 
J

Joe Fallon

I would suggest using A97 if it works!
Then you can use A2000 Front Ends to link to the A97 back end.
--
Joe Fallon
Access MVP



Angie said:
In my case, I need to figure out a solution with Access
2000 and Oracle 7.3.2. I am upgrading a company database
that is located on a shared network. The company has
recently decided to invest in upgrading the PC's to 2000
but not Oracle at this time. Do you have any suggestions
for using Oracle 7.3.2?

Thank You,
Angie
-----Original Message-----
I have used Oracle 8, 8i and 9i with many versions of Access.
Tryit on a different PC and see if there is a problem.
Perhaps it is your machine. (These are the most troublesome bugs to fix!)
--
Joe Fallon
Access MVP



Does anyone know what versions of Oracle will work with
Access 2000? I just recently converted the database from
97 to 2000. In 97, the oracle linked tables worked just
fine. Once I open the tables in 2000, I get the following
memory error,

ODBC-call failed
[Microsoft][ODBC Driver Manager]Memory allocation failure
(#0)

Any help would be greatly appreciated.


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top