Search results

Not exactly - I meant RAID0. For SSD it almost doubles the performance. For HDD it takes more drives to get same performance. I noticed my SSD runs some queries on 1.3million records database about 2-3 times faster than regular hdd - that is why I wanted to know if you guys tried something like...

Yes, I know, but I can't use my SERVER server, I could install SQL server on my pc, which I will build in near future. So, I understand, unless I use fully blown multi-cpu server with loads of ram, I won't get it run faster on regular pc? Even if I get 4 core, 12GB ram, super fast drives in...

What if I build pc with HDDs in RAID to make it faster and install SQl server on it and work on this system - would it make even faster? I just want to optimise my work in some not expensive way... I could buy some SSDs (MLC), but these have low write cycles so I could kill them after few...

OK. I can try that... So you guy suggesting to get SQL server, import tables and run queires from the server? Or for example link those table from server to access and run queries from those linked tables? Would it be better to work on server directly or from linked tables, on pc in the network?

Well, yes, I know what you mean. See, we have SQL server I could use, but I'm not sure if that would help. What I do is: I get 2GB database every week, 2M records. I work on this by importing to Access. Then I compare to other Access files, update records, append tables, etc. I run lots of...

I have a question to you guys: what drive would be the best choice for database? I work with Access databases every day, building, merging, copying data between big files, millions records, etc. Some queries take ages to get results, so I thought I could use some SSD drives to make it work...

Guys I need help please! I have this function I added to modules, that adds random date in given range.. right? Pretty simple: Function RandomDateInRange(LowerDate As Date, UpperDate As Date) As Date RandomDateInRange = Int((UpperDate - LowerDate + 1) * Rnd + LowerDate) End Function Now, I...

Oh, I can't use replace, its 2 millions of rows, it stops every 10.000 rows and need to repeat it manually, which is impossible. Is there anyother way to find string of digits and basically delete them?

now I have a another problem - I got this district part, but I how can I get rid of digits in the district part? For example some are G2, G32, HU21, etc. - How can I keep the letters and get rid of digits?

Thanks, I just came up with solution!:) First I use InStr to get position of space, then I use Left function to cut up to that space position, then I use Trim to cut out the space:) Sweet!:)

Guys, I need to pull the district from postcode, so it would be various length string, from 2 to 4, but basically all up to first space. How can I achieve this? I know how to cut out last 3 characters using right function, but how to cut left side up to first space?

Thanks, but that needs a string to be added, like exact one string from field. What if I need to delete soemthing from the whole column, like all fields in column have AW****, where **** is a string of digits, and I need to delete those AW?

I know, it sounds funny - what I need is to get rid of spaces in fields in one column. Basically it is phone numbers, some have space like 0145 8877657. Thing is when I use replace function it crashes, cause it's 3 million records;) Is there any way I could use.. don't know .. update query...

Hi there again! :) Now I have a pickle...:rolleyes: I have same thing as before, report based on combo box, only thing is this time the name in combo box has the name of the "set", but it is not always first 3 characters - sometimes it is something like "5APhyH1", where the name I would need to...

I think I'm gonna have to start paying you:) That worked fine, as ussusal! :) I have NO IDEA why when I used "no exists" previously it didn't work. As I said, I was loosing reality here, tried all I knew, including "no exists", nothing worked. I rewrote it and it worked, but only after you...

That adds rows from one table to other deleted previous ones. VBA just says copy object. I would like to copy new rows from table 2 to table1 by adding only new ones to it.

Well, almost - I'm getting error - "Duplicate output destination ID" :( Why is that? those rows, those ID fields actually don't exist in table1 so should be ok to add right?

I think I just got it, left join and all ID that are not there:) INSERT INTO table1 SELECT * FROM table2 LEFT JOIN table1 ON table2.ID = table1.ID WHERE table1.ID Is Null;

I must be tired or something, cause I cannot do something that is pretty simple:( Two tables, table1 and table2. Table2 has same rows as table1 + some new ones. I want to append table1 with only new rows based on primary key field - ID. So this query will add all rows from table2 to table1...

Sweet Jesus Holy Batman! It works!:eek: You my friend.. You.. no.. You!!:D Thank you again - this is fantastic, I have to practice more of that VB, you can make amazing stuff in the background of that Access. Fantastic, thank you so much !:D