use a udl file for ado connection purposes. it will save you a lot of time and hassel, you will find out how to make them on the microsoft web site or just look through google, its really worth your while and only takes a few seconds.
I am using access 2000 database on windows xp.
I have ado 2.7 library referenced in my VBA code. The code works fine but there is a synchronisation problem occuring which is resolved when i switch to DAO.
I Created a table in the database called temp which can hold integers in its only field...
not a chance .... but thanks for the thought cycles
the problem seems to be a driver issue or something,
the records go into the database but the form just does not see them fast enough
I am using access 2000 database.
I have ado 2.7 library referenced in my VBA code. The code works fine but there is a synchronisation problem occuring which is resolved when i switch to DAO.
I Created a table in the database called temp which can hold integers in its only field 'Data'. I...
I was faffing around with this problem for an hour or two also. I am using winxp and access and Excel XP. I found that if you have a excel function call that is not called off the excel application object then the thing hangs. Look below as all the functions hang off the objExcel object.
Before...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.