Search results for query: *

Hi SkipVoight The code snip below does actually show a second axis legend The FIXME in the code example. As is it defaults to the top of the chart however you can reposition it. However I could not find a way to feed it with data. There is no problem retrieving the data with the SQL criteria...

Hi All I am embracing VB.Net 2010. A far cry from Microsoft Access that I have learned to love, however the new .net Chart tool is fantastic; so many options to choose from. An existing database has the following fields. It is a stock price chart. Date, (Formatted as short date) Time (Formatted...

Hi River Guy, DonQuichote, ZmrAbdulla, PRPhx, HarleyQuinn, and JoeAtWork. Gee I am humbled by the time an attention you all have put in to help me. When I started this project it was just a simple little idea. Now it has grown to 14Gb of data and that just keeps increasing. As you know the...

Thank you for your thoughts. Currently there are 1100 MDB files in the data directory compacted they are about 3 GB in overall in size with 15,227,799 records so far spread among the files. That total has accumulated in a couple of weeks. I redo the schema by copying all the data into a new...

Not every month. The number will only grow if more Market codes are added. The NYSE has thousands of listings; however this project is only following a subset. We are storing times series data for analysis. And access MDB file can store 2 gig max. This sort of market data can generate many...

Hi All A further Update So far 714 MDB files have been created That contain just under 6 million rows of data, so far. in a couple of weeks The largest has 250,000 rows For market data or any other data where there is a clear division between data sets and you have to store large amounts of...

Hi All Just an update. Results to hand indicate that VB.Net may not be the ideal application. Access 2003 (Using DAO File Access) appears to be a lot quicker than VB.Net working with SQL server. MDB files have a maximum size of 2GB far too small to contain share data for an entire market...

Hi Andy It would be worth trying "Bintext" to get the location of the string in the file. You will then need a hex rditor to edit the location bintext displays. It is freeware I found plenty of sites that have it on the web. Cheers

Thank you everyone for your support. My suspicions have proved correct Also found this thread on the Tech forum viewthread.cfm?qid=1310439 (Web address removed) Speed issues mentioned there too. It will be interesting to compare the speed of VB dot net and Access. Microsoft Access currently...

Hi All As A long time Microsoft Access user Using database objects DAO I thought it would be an easy matter to switch to VB.NET Express. Free from Microsoft. Yes the newer ADO and .NET data structures have more power. However my code works. I am hoping to simplify the transferral. I have...