We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

how do I handle an Access 95 table through VB6 running on XP?

RUSS_EMI
RUSS_EMI asked
on
Medium Priority
283 Views
Last Modified: 2013-12-25
I am running XP Pro with Access 2000.  Access will allow me to append records through the table view, but I can't create any new form, report, query etc.  I do have VB6.  An Access expert suggested I use the MS Jet Engine.  I downloaded it, but didn't install it yet.  I am unfamiliar with the product.  Using debug -d I noticed that the Access file was created or modified at some point by Jet engine.  The file is used as an overlay to legacy mapping program called Falconview.
What I wish to do is create a form for end users to append map point data to this file, then be able to query and run reports against it.  This is urgently needed.
Thank you,
Russ
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
Beside that,Please :
1.Update VB6 Latest service Pack -> SP5
2.Update MDAC to latest verison -> MDAC2.8
3.Latest Jet Engine Service Pack ->8.0

Author

Commented:
Thank you.  Does this code allow for appending, if not would you show a sample?
My table only consists of 4 items; ID, Latitude, Longitude and Description.
Russ
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.