Search results for query: *

Hi there, shortly I will be investigating an issue regarding an Access 2007 database which is supposedly "corrupted", and some time last week it lost 55,000 records. The details of what went wrong and caused the corruption are very unspecific, all I know is that it happened at some point between...

Hello, I was having a bit of trouble connecting to an access 2007 database. Before I get into the details, I'll give you a little background. I had a tool running off of Word in the old .doc format, and the code originally connected to an older access 97 database with the old mdb format. The...

This might be a shot in the dark, but is there a way for me to speed up this snippet of code? Even a second would count, as this code gets called repeatedly. [code]Me.RecordSource = "SELECT * FROM [" & tbl_task_table & "] where [Task ID] = " & curw_rs.Fields(1).value & ";"[code] I tried to...

Hey there, I had a form in access 2007. I had recently upgraded it from 97 where it ran within seconds. Now when I run it it takes something like 20-30 seconds. I pinpointed one of the areas where code was running really slow. 'Unbinds all text and combo boxes from the work form Sub...

Hey there, I will soon be taking on a project regarding optimizing a series of Access databases to run with better performance. In Access 97 these databases ran queries and modules with no trouble at all, however, after upgrading to 2007 there's been a huge impact on speed. I was wondering if...

Hello, I was wondering what the difference was between using Cstr() and Str() in Access 2007 queries. Where would you use either? From what I've heard, str converts a number to a string but leaves an additional trailing blank space to accommodate negative numbers with the minus symbol at the...

Hey all, Recently I've been running into issues concerning library reference integrity. Essentially, I have a series of databases that were developed on a different system (and much older system), and I'm now in the process of remediation so I can upgrade these databases to later versions...

I was wondering if JET SQL performs any implicit conversions behind the scenes. For example, I've seen a SELECT clause in the past that would select a number field from a table and simultaneously combine it with a text value. For example: SELECT Table.number & "TEXT" FROM Table; Which would...