Recent content by xtreme1

No dice, whatever happened, it's in bad shape...=( I'm going to have to try and salvage as much information as possible from this I suppose. I'll check back shortly to see if any other suggestions have been posted, but from the looks of things, I'd say this is not going to be easily fixable...

I appreciate the help, and I'll post back as soon as I try the utility you mentioned. Access repair just completely corrupts the file by the way, so that's a no go. Thanks for the help so far though, I appreciate it. xtreme1 rbio@excite.com

I'm running into a reserved error (-1601) when attempting to change a date field of a table. I successfully copied the record containing this problem, so I would now like to be able to delete it. Unfortunately, any deletion attempts result in that same error. Has anyone ever experienced this...

What error is created with the double quotes? xtreme1 rbio@excite.com

Gracias Paul, was very helpful. =] xtreme1 rbio@excite.com

Is it possible to compact a database while it is open? I've tried the CompactDatabase method, as well as DoCmd.RunCommand acCmdCompactDatabase. I feel like there must be some way for me to automate this from a single module, instead of having one that runs a program and a seperate one that...

I'm going to be receiving e-mails on a daily basis that will include a batched text file with comma delimmited records in it. Obviously, the person working on this could manually save the attachment to disk at the end of each day, but if I would like to have as little human intervention as...

I wasn't even aware of that...that's cool stuff. I'm going to look into it, but if you do find out could you post the info here? I'd definetely like to know about that one...=] Good luck! xtreme1 rbio@excite.com

It doesn't work because it should be: OpenExplore = Shell("C:\Windows\Explorer.exe") not: OpenExplore = Shell("C:\Windows\Explore.exe") xtreme1 rbio@excite.com

Sure, you could just write another MDB thats only purpose is to compact the other. Just write the code necessary to compact the external database, then include a macro named "Autoexec" which executes that code. The compacting code should also exit the entire...

Can any computer access the database file in any way? I don't honestly understand why yet, but in most the two occurences of that problem I've had, one to three computers on the network have still been able to access the file. If this is the case, I recommend exporting the queries to another...

I sent you an example database doing what I think you'd like to accomplish.&nbsp;&nbsp;I hope it helps. =] <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>

&nbsp;&nbsp;&nbsp;&nbsp;The front end may be growing due to appends to tables that occur frequently.&nbsp;&nbsp;In other words, if you're appending data to a table temporarily with a query of some sort, and then deleting it, the memory the deleted records once occupied is still...

I have the same problem with memo fields in Access97, I assume the same would happen in a text field but it has never occured.&nbsp;&nbsp;The computers here also substitute the black bar for the three periods, let me know if you find a solution to this strange problem.&nbsp;&nbsp;I'll ask around...

Try &quot;VbCrLf&quot;, I think this is what you're looking for. =] <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>