Recent content by DJkarl

Put a routine into your database on startup that relinks the Oracle Table. Use a tabledef and look for the Connect property then RefreshLink. This will prevent the popup box from showing.

Have you stepped through the code on the MDB yet? What line is the error on?

I think in this case you would be better served by writing a query to filter your conditions rather than looping through a recordset to check each record. SELECT * FROM Clients WHERE Priority = True and TimeToCall < Time() If you only want 100 or less records add the following SELECT TOP 100...

What line in particular is throwing the 3265 error?

Function ParsePart(strVal As String) As String ParsePart = Mid(strVal, InStr(1, strVal, "\") + 1, InStrRev(strVal, "\") - (InStr(1, strVal, "\"))) End Function

I've confirmed on my office 2003 machine this behavior exists as well. It seems odd but does not seem to actually impact the code running. I did notice that it only changes once you compile the project, otherwise it happily leaves them as you typed them.

You will likely need to use the Open command with the Append option. This is just a very quick sample. Open "C:\Temp\Yourfile.csv" for Append as #1 Print #1, CommaDelimitedStringHere Close#1

Non-contiguous records...do you mean a random selection of X records? This might help, haven't tried it though. http://fontstuff.com/vba/vbatut02.htm

First you should really get both queries to have the same number of columns, otherwise how can you relate the data together? If they have the same number of columns, in the same order, you can join them together with a UNION statement. create a new query SELECT * FROM query1 UNION ALL...

Strange behavior indeed. I know indexes add size to the database, but I can't imagine it would add enough size in this case to cause a problem. SQL server is an option, but 1 million records isn't an unreasonable amount, unless the record size is huge (lots of columns). What I would do next...

Once indexes are deleted you need to recreate them, it likely deleted them because you changed the datatype. Presumably Access can't index a Decimal the same way it index a Long. In the future I would create a blank table from your existing table basically a Make Table query with 1 row...

Are you getting any errors? You might want to change your error handler to display the error messages, it might help diagnose the problem with the login.

Q: Is there a better way than timers to trigger your file sweeps? A: In this case I don't think so. Since the job is recurring you are reliant on something happening again and again, a timer is pretty much what you need. Q: Is there a more efficient way to handle file copies that allows the...

You can distribute your database as an MDE / ACCDE with the Access Runtime, or you can write your program in Visual Studio using Access as a back-end only, compile your program then distribute the EXE and the database.

You would use a query to get what you need. Any beginner reference on SQL would be helpful, here's one directed at using MS Access. http://office.microsoft.com/en-us/access-help/microsoft-access-for-beginners-part-iii-writing-the-queries-HA010247313.aspx