Solved

Access Database conversion

Posted on 2000-04-25
7
154 Views
Last Modified: 2013-12-28
I have a user that was upgraded from win95 to win98.  Now there are certain libraries my code is not recognizing. My references match.  I browsed through the control panel, under OBDC connection, and under the pooling, Microsoft Access 97 was not being pooled.  Could this be a problem???
0
Comment
Question by:scorp8
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 21

Expert Comment

by:gemarti
ID: 2748602
What version of MS Access was on the Win95 PC? Did you upgrade the database version to MS Access 97 also?

Is this a C++/Delphi/VB application that is interfacing with the database?

If you have upgraded to MS Access 97 on the machine and the above application question is yes then you probably need to recompile your application on a machine that has MS Access 97 installed on it.

0
 
LVL 1

Author Comment

by:scorp8
ID: 2748660
The database was originally in Access 97 (there were no upgrades on the database).  The only thing that changed was the user. he's now running win98 instead of win95.  All my other users have win95.  i'm stumped.  My code is VBA!!!
0
 
LVL 21

Expert Comment

by:gemarti
ID: 2748707
What kind of errors are you getting? You say your code isn't recognizing some of your libraries. Perhaps if you provided message information etc. we can help you.......
0
Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

 
LVL 1

Author Comment

by:scorp8
ID: 2748762
The message that pops up is "Can't find project or library".  It pops straight into my code and highlights the word FORMAT in my code.  I thought it may be my references but they match up between versions...
0
 
LVL 21

Expert Comment

by:gemarti
ID: 2748856
Try reinstalling MS Access 97 on the machine.
0
 
LVL 1

Accepted Solution

by:
ajcortez earned 25 total points
ID: 2751856
You can get exact idea of what you're missing if you run the debugger.  In the module editor, select References, it will identify what libaries are used.  In front of one of them at least you'll see the word MISSSING.  That is what you're missing. It will tell you what files are missing.

Most like it's in the C:\Program Files\...\Microsft Shared\DAO folder. Then it's a matter of copying the contents of that folder from a working machine to the PC in question.

Good luck.

AJC
0
 
LVL 1

Author Comment

by:scorp8
ID: 2752155
that was it, thanks...
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question