Search results

When I met Gen. James Woolnough. He was a four star General and I was a lowly lieutenant. Came to my Signal Detachment in RVN for a Christmas visit. I spent weeks preparing for his visit and was prepped by my various commanding officers on what to show him, how to act, etc. I was terrified...

Thanks. Unless it causes problems, I will not worry about it.

All users settings are the exact same. That I already checked.

My settings are exactly like that.

OK, thanks for your input. I guess I am so used to seeing a locked back end file that I was mystified when I didn't see one. Not going to worry about it until I have a problem with it. The reason i asked in the first place was that the user told me she had a problem access the data. She could...

Front end on desktop, back end on server. Before even if only one user, both front end and backend have small locking file. Other DBs on same front end backend setup both have locking files. Just don’t understand why this one doesn’t

No locking file. Access 2019 When I open my DB, usually there are two locking files. One for the front end and one for the back end. Yesterday one of the users was having problems so I checked the DB and noticed that the small locking file for the back end was not there. I did a compact and...

Only way to avoid any of the bad guys from stealing your data. The guy wants to know why he keeps getting ads for things he might have looked up on the internet. When he finds out he takes appropriate action. From the TV series Parks and Rec.

It's been four days since the changes and there have been no problems. Actually I'm posting this to see if my jinx factor holds. But the one user with the terminal has been using the Db since Monday and no problems! May be too early to say, but thanks for all your suggestions. It definitely...

OK, the following was done today: 1. The power settings were checked on the network card again which were off but after digging a couple more power settings that could cause issues were disabled. Set Auto Disable Gigabit to Disable. Set Green Ethernet to Disable. Set Energy Efficient Ethernet...

Unfortunately they are all hard wired. So goes on the search for the missing clue.

The crashing occurs when someone is using the Access DB. But I will pose the question to our Tech gu anyway. He sent me the following two screen shots if they are any help in diagnosing the problem. Much appreciated the help so far.

Thanks, I will pass that suggestion on to our outside tech.

Spoke too soon. Worked for three days and now getting the message: Disk I/O Error During Read. New I would jinx it. The computer is hard wired into the server. So, either there is too much running in the background and not enough memory, or the LAN port is bad, the cable is bad, or ?? The...

I work remotely from the main office, mostly retired but helping out the Access Databases. For some time now the back end of the DB has been crashing with regularity. We finally narrowed it down to one computer terminal that seemed to be the culprit. For months I have been telling them to check...

My input on this is that without this site I would never have completed my databases. This is my go-to for information and help. I thank all those who let me sleep at night knowing that my conundrums would be solved.

So, is here a way of supressing it? Or do I just have to live with it?

This is the code: Public Sub Zip(ZipFile As String, InputFile As String) On Error GoTo ErrHandler Dim FSO As Object 'Scripting.FileSystemObject Dim oApp As Object 'Shell32.Shell Dim oFld As Object 'Shell32.Folder Dim oShl As Object 'WScript.Shell Dim i As Long Dim l As Long Set FSO =...

There is a popup showing the compressing of a file when executing the standard Zipping File code that displays when the file is zipping. How do I suppress the pop-up? I believe it is in the following line of code: ' Wait for compression to complete before exiting Do While...

OK, the Day1 field is text, a three letter abbreviation for the days in a week. Sun, Mon, Tue, Wed, Thu, Fri, Sat. Seven days. My original query where I used the code in Post #1 worked fine in Access 2010 but didn't work in Access 2019. The query from Isaac in Post #8 works in Access 2019...