Recent content by Paul Chernoff

And thanks for all of the advice.

The database has stopped crashing. we made a number of changes. I put the database with programming code on the local drives and only left the data file on the file server. That reduced problems. Upgrades to VMware also helped. Staff knows to quit from Access if they are walking away from their...

The only hardware that has been shuffled was a phone. No computers were moved. I'm going to check on what you suggest.

I replaced the phone this morning and thought that we got it because no crashes today. Until I tried to get on the database. I can't get on, I get the error. Had someone else try to get one, the same problem. But the person currently on the database, who has the replaced phone, is working...

So swapped phones and the phone that was with the person whose workstation I supported is not working properly. So I will work on replacing that phone tomorrow.

So I just swapped the phone with another and see if this phone has a problem connecting itself to the PB. I have other phones I can swap in once I program them.

The phone setup is very common and we have been using it for 6 years. The phones are 1GB and act as routers. This one phone is giving me problems though, first reported to me today. It has been having problems working as a phone though the routing seems to work fine. But there can be a hiccup...

I am suspecting that one person has a bad connection to the network. Her IP phone reset today, not a good sign. Our Cat 6 wiring first goes into a Cisco phone and then to the computer.

One more question. All programming are macros. Would it make any difference to upgrade the macros to Visual Basic? Feel like I am clutching at straws here. We are slowly ramping on the users to see if one of them might be triggering the problem. Which doesn't make sense because once we put the...

We are running the current version of Access365. I went to each computer and made sure all Office365 updates were installed last week. When we got the database the previous owner was using Access 2003. The developer also moved to the current version of Access. I made sure we were using all new...

Someone recommended splitting the files, and the programmer had already done this back in 1999. I will talk with him about this issue and his experience with other clients.

Of course, FE and BE. I think the programmer has taken care of this issue, though he never mentioned giving each user their own FE app. I will cover this issue with him. The previous database owner ran everything single user, he would simply make multiple copies of the database, with all but...

All of the tables are on the server. So that is probably the problem. The file WPDprog has the programming work. I assume this is what you mean by the FE app. The file WPDdata has the data and I assume that this is what you mean by the BE tables. So I should copy WPDprog to each workstation...

We have Access databases running with simple file sharing. The database files are on a Windows Server 2012R2. The clients are running Windows 10 under VMware. The Windows clients are only running Access, users have been warned not to run any other software. The data is in one file, most of the...

Thanks to everyone who has helped me with Access. I am getting more used to it. Part of the problem is simply that this database is a 28 year old design (yes, it predates Access) and there are so many oddities. For example, I was looking for orders for subscription to a web site and I learned...