ADOX problems

  • Thread starter Thread starter Igor
  • Start date Start date
I

Igor

When I set a reference to the ADOX library, I can use the
objects to manipulate database structure, but I get errors
in other parts of my application, for example, using the
Date() function results in error messages.

Is ADOX confusing the definitions of other libraries?
 
Not much I know of that conflicts with the Date() function. Only thing I've run into personally is when someone has named a field
"Date." This conflict can usually be solved by putting [ ]s around the field reference. I.e.: rsTable![Date]

Otherwise, this is usually 9 times out of 10 an indication of a missing reference.

Have you checked Tools/References from inside the VBA editor?

Look for a reference marked "Missing."

Also, can you get a clean compile, Debug/Compile, without any errors?

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top