Recent content by cikVOU18
-
C
Database hit 2GB, split only decreases to 1.81GB
Thanks - I'm working on this now. -
C
Database hit 2GB, split only decreases to 1.81GB
theDBguy, I started to do this, but is it possible to split one table up? 95+% of all data is in one table. -
C
Database hit 2GB, split only decreases to 1.81GB
I'm not storing any attachments. We have a weekly vulnerability scan that runs, and it generates a CSV file. I import the CSV after the scan completes. -
C
Database hit 2GB, split only decreases to 1.81GB
I'm not sure what to do - It hit the 2GB limit today, and I did a Compact and Repair, followed by splitting the database. The database from the split with the tables is only 1.81GB, which doesn't give me much to work with. Can someone point me in the direction I need to investigate? I probably... -
C
When count function doesn't get a hit, there is no entry - need a zero
It's working. Thanks for all your help! -
C
When count function doesn't get a hit, there is no entry - need a zero
Thanks, arnelgp. I figured that's what it was, but when I make this change, I don't get a result (the run won't stop) and I have to forcibly close Access and restart. I'm pretty new to this, but it seems reasonable that I should be able to run what's in the parenthesis by itself, something like... -
C
When count function doesn't get a hit, there is no entry - need a zero
Thanks for the replies. arnelgp, I'm trying to work through your suggestion, but I'm having a problem understanding "where t1=[risk] = [vulnerability info].[risk]" on the third line. Do you mind elaborating? Thanks -
C
When count function doesn't get a hit, there is no entry - need a zero
We have various vulnerability scans that send out a CSV file upon completion. The various sites are each put into a separate table, and then a query is run to determine how many vulnerabilities are present for length of time. For example, the following simply calculated whether a vulnerability...