Please let me post a public comment on questions like:
I'm wondering if someone can help me. We are currently using Access 2.0 with
Max and we'll be updating to Access 7. It is my understanding that I'll need
to go to ODBC to now make the connection to Btrieve. Can you tell me what I
need to do ? Where do I get the ODBC driver ? and what the procedure is to
connect...etc...(is there any documentation available on how to do this ?)
http://www.pervasive.com supplies an ODBC driver. I suggest you go to
Pervasive.SQL 7 as earlier versions are time consuming to problem solve.
Load the ODBC driver, map your MAX\DAT folder to a drive (say P:) then
Start, Settings, Control Panel, ODBC and create a DataSource Name (say "MAX
P"). Open Access 97 and link to the ODBC DSN MAX P, you'll see all the
tables listed. Pick one and you are good-to-go. The nice thing about the MAX
on P method is that you can re-map drive P: to other MAX data folders and
all your programs work without change. (This is also true with Access 2.)
If you need to run Access 2.0, and Access 7 at the same time, please let me
know. I'm proud to say that I've solved this problem when MAX, their
TIPSters, Pervasive, and Microsoft were not able to.
You will notice that Access 97 in some cases runs orders of magnitude slower
than Access 2. The reverse is also true. I have some suggestions here too.
Just last night I turned a 20 minute report into just 15 seconds with some
tweeking. Please contact me if performance is of any concern to you.
I don't take time to check this news group often, so you might want to send
Dale E. Moore