Recent content by Ronnie101

OK, I've worked out how it's getting the weird results with the Format() function in METHOD 4. It's auto-converting the input date string into an integer, and reporting the date which is that number of days on from 30 December...

I have an Access 2003 database which is soon going to run out of space when we hit the 2Gb limit for the linked MDB that holds our biggest table of 2.5 million records. So, management decided that we had to migrate the table to linked-Oracle - however, the performance of the large queries that...

Can you explain some more, please? How can I refresh a connection that Access does not let me create in the first place? Thanks

I'm using Access 2003 under Windows XP. I have a very large linked table that is growing daily, and will soon exceed the 2Gb size limit of a single MDB file. So, my management have told me to host this table in their big Oracle system that does not have this limit. However, there are many...

I'm accessing an Access 2000 backend MDB via VB6.0 (SP6). When I run it in the VB interpreter it runs fine. When I run it as compiled native code I get an "Automation error: CoInitialize has not been called" error at this line:- Set gobjConnection = New ADODB.Connection I've tried...

PS - I'm using Access 2003 under Windows XP

I have a simple table consisting of a MainCategory column, a SubCategory column and a DataValue column. The MainCategory and SubCategory values are not intended to be edited, but the DataValue values are required to be user-editable (one way or another). I have been tasked with building a...