Search results for query: *

Oh, forgot to mention there are no mdw files involved here, we are running them wide open.

When copying the file to local drive it runs fine, none of the "baggage" comes with it. I have done this several times to make updates and had IT admin later delete the server file and then I replaced it with mine. Then it works fine till the next day.....Currently I experience this problem...

I have verified we can create text files in the subject folder but still have the problem. Had the server reset yesterday and all was well this morning same problem again, cannot access the lockfile and the DB is read only with none in it and I don't believe anyone else has been in it either as...

I have been numerous issues like this with several of our databases, beginning to believe it has something to do with maybe a recent M$ update. Lately I am unable to view the lockfiles. Or cannot get exclusive rights even though i am the only one in. One other case a simple one level(no front or...

Skipvought, Thanks for the comment, I knew that Access converts the dates into integers but that still does not solve my dilemma in that I have dates data that is faulty, for what reason I do not yet know. Either thru operator error or programmatically. Reading this post now however I had a...

All, Currently I have numerous date columns in various tables that all use the following input mask: "99\->L<LL\-00;0;" What i would like to do is force the user to use the day-month-yr format (only in Canada)which is currently left to either day or year first. Was thinking the easiest would...

Thannks Joeatwork, I was afraid I was screwed and you just confirmed it for me. Have a great day!!

NO....it is NOT a text field, all are date fields all formats are set to "yr-mmm-dd" BUT for reasons I won't go into here over time these databases have been wide open and every T,D&Harry have been &^%$$$ around in there with their PC's regional settings NOT being what they should have been. I...

Thanks for the responses, they will help me somewhat, however I guess I did not fully explain my complete dilemma. Currently my data contains a mixture of date formats, most are correct in that they contains:"yy-mmm-dd" some and I would guess approx. 20% are in the "dd-mmm-yr" format. It is the...

I have over 30 tables with mixed date formats any easy way to standardize all to the "yr-mmm-dd" format? I have several tables with over 10000 records and several date columns. I'd hate to have to do this manually, is there a routine that anyone knows of that looks at the date value and...

Why does the date "yr-mmm-dd" change to "dd-mmm-yr" when clicked on a date in the tables, there was a thread I saw on this problem in the archives but no solution or fix was given, anyone know why that is? My regional settings are set to yr-mm-dd.

thanks for the response,I'd still like some clarification though, What does the underscore do for me and secondly should I make all input masks contains that underscore or remove it? IOW what does the underscore really do for me if anything? Furthermore, Crowley16, this is what my F1 produces...

Thanks for the comments, however I had previously checked help on the input masks and the underscore is not shown/mentioned there.

I am rather frustrated with some date issues I have encountered lately, I inherited these 2 databases that have several date fields, all specifying "Medium date" with some also having the input mask as "99\->L<LL\-00;0;" and some as "99\->L<LL\-00;0;_" and some others with no input mask...

Still have trouble understanding why the startup form would prohibit me from splitting the database?? Anyone have any ideas on that one?? Anything to do with naming?? the form in question has the same name as one of the tables??

Ed, The other thing I should mention and correct me if I am wrong, but can I not limit write access thru network security to the back end? Currently we need to provide everyone with Access to the database write access to the folder where the table resides, which is not the case for the backend...

Well, as I understand it it will at least keep the tables safe from inadvertendly being damaged or modified, I know if there is any intention of doing damage well... as you say feed the trolls.... It would I believe be somewhat safer then what we have today, the main problem here is that we...

I have searched for some time for a solution or reason why I am unable to split a (inherited) database we use here @ my company. It haS multiple users and never been secured,runs wide open for all, you can imagine the problems we run into. So I decided it was time to bite the "database split"...

Thanks for the explicit instructions, got it working somewhat..... Problem being I already had a startup form that contains functional items for the user that we cannot do without, and that form does no longer show up, also the timer form does not like to hide.......it comes up each time the...

OK, thanks a bunch but forgive my ignorance on this, can you be more specific on how to get this working? Whatever I tried does not seem to fly for me....... Thanks