Search results

Unfortunately, I'm not a programmer (or DBA for that matter), I'm an engineer and I'm learning a lot of this stuff as I go. I don't really know what you mean by multiple environments. Also, there are a lot of scripts that I have embedded that make the database functional. So it's not just...

It's all in VBA... I think it might have to do with the structure of Win XP 64 Bit... it's notoriously unstable...

I'm having trouble getting a runtime version of access to open a database that has scripts in it. The database opens and runs fine on 32 bit versions of Windows XP, but not on 64 bit versions of Windows XP. Runs fine on Windows 7 64 Bit as well. When the database opens, a script runs to...

I like using parameters in SQL... seems cleaner to me... I think I figured out a work around that is much simpler than the way I was attempting... guess I should stick to KISS...

I'm having some trouble with an insert into SQL statement. For some reason, when I execute the code, it not only inserts a new record, but also changes a random record to match!!! It's really frustrating as none of my other codes have this problem. Here's the background. I've got a table...