These queries were INSERTS and UPDATES, so I can see now how indexing could slow things down. The difference in performance is incredible, though. A typical query goes from taking 30 seconds to taking 30 minutes with no apparent progress, then I kill it.
Another interesting item is that Field...
I have a large Access 97 database (~500MB) that has a large table with about 250,000 records. This table has a lot of different indexes. There is no primary key set on the table, but many queries I use do a join on fields A and B (both text fields and indexed) as if they were a composite key...
Has anyone here seen the behavior in Access 97 where the text boxes on a report drift to the left as you advance through the pages?
I have a 200 page report, and by the time you get to page 150, 2 or 3 of the characters on the left side disapear. I am really at a loss on this one, so any help...
I need to make a composite key in a table, and of course I can't do that until I have deleted the duplicate keys already there. Is there any way to do this with an SQL statement? I can select the records to delete with:
SELECT [Account_ID] & [CowID] FROM tblCowEvaluation
GROUP BY [Account_ID]...
Thanks every one, this is working much better. Just curious, is this just the way Access likes it, or should I stay away from "NOT IN" queries with SQL Server, etc?
-A.J.
I have an application with an Access backend and I am trying to populate a list box with all the records from table A that aren't in table B. Right now, I am doing this with the following statement:
"SELECT Name, FROM A WHERE [Active] = 'Yes' AND Name NOT IN (SELECT Name FROM B WHERE...
I am using a JET replication object to compact/repair an Access DB, then I ftp the DB to a server. I am using the following code to do the repair:
jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sirematchd\smbackup.mdb"...
I have the following code to import a text file into access:
db.Execute "DELETE * FROM tblTest"
DoCmd.TransferText acImportDelim, "ImportSpec", "tblTest", "c:\Test.txt", True
The problem is that I imediately run some queries through ADO that...
I have an 8 byte text field that represents a date in YYYYMMDD format that I want to convert to a date type in Access. I can get the query to work from the query designer in Access, but I can't get it to work from an ADO connection object. Below is the query:
"UPDATE tblHerdImport SET...
I wrote a macro which attempts to copy some forms from this Access 97 database to another using "Copy Object". One of the forms copies fine, but the other two cause the macro to blow up and the message "Object invalid or no longer set" appears. From time to time the whole...
Thanks Mr. Lowell, your /decompile tecnique appears to have fixed the situation. That saved me quite a bit of time cutting and pasting tables/macros/queries...
And Michael, any relation to the pop singer?
-A.J.
I have a bit of code in a Module that has become corrupted somehow. If I even try to view the code, Access imediately crashes and exits. It even crashes if I try to delete the code module.
Repairing the database did nothing, so I am wondeirng if anyone has experienced a similar problem, and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.