Search results for query: *

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>

&nbsp;&nbsp;&nbsp;&nbsp;That's an interesting problem.&nbsp;&nbsp;One way of solving it might be to create a recordset of the archive table and actually do one record at a time, one field at a time, UPDATE's to it.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;In other words, set each of the archive...

That is definetely strange, I tried it here and it worked OK.&nbsp;&nbsp;Maybe an error in one of the source databases fields is causing it to halt early?&nbsp;&nbsp;Not really sure why that would happen, but if you can let me know what was the cause when you figure it out.&nbsp;&nbsp;Good luck...

Vic, yes it was.&nbsp;&nbsp;Multiple NICs actually, it's a complicated story...but you were correct.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;It wasn't the servers NIC, it was a few of the client NICs that were causing problems, it was tough to determine which was the actual problem...

Oh, and also.&nbsp;&nbsp;The cause of the error is when two people update a record concurrently.&nbsp;&nbsp;One of them, the last to attempt to exit the record, will receive a message:<br><br>&quot;This record has been altered since you have started editing it.&quot;<br><br>They then have a...

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You might want to look into Carbon Copy 32, as it allows synchronization of files.&nbsp;&nbsp;I use it quite often, though it is usually a one way deal.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Once you commit the file transfer methods though, you could always...