Search results

During the last update in Office, there were a number of changes made in Access. The most annoying change I have found so far is in the Query Design screen. When you add a table it splits tables into Tables & Links Now to find tables, I need to know whether it is local or linked (most are...

Does Power Apps allow me to setup a proper relational database?

My daughter's company needs some customized scheduling software (her firm is running on-line D&D games for kids). Given the remote nature of her workforce, web browser solution would be best for users. Would this be better handled through Microsoft Power Apps or with Microsoft Access and a VPN?

Are you sure defined this correctly? I would expect that quote numbers be assigned sequentially (AutoNumber) and then displayed in a sorted recordset. Why is there a need to renumber anything?

Yes, it is. I have the same problem with much larger databases, so I was surprised when this small database crashed frequently.

I imported into a new database. I will see what happens. Does it mean anything to decompile a database that has no code?

I have been having problems with Access crashing when a table is selected. Access generates a backup file during this crash. This has been affecting multiple databases over the past few months but this particular small database crashes half the time. Does anyone have any idea about why it is...

I don't see that option. I did uncheck "Name Autocorrect".

This happens when there are no other users in the access database. As this happens with access native tables as well as sql tables, I assume that problem is on the access side.

Over the past few weeks, my main work database has developed a problem where it locks up when opening table interactively. The problem occurs with both Access native tables and SQL server linked tables. It does not happen when things are running without user interaction. Repairing the database...

I have also faced problems with the contents of query string disappearing from a stored query when run. All I could to do was to store the SQL from each query and fix it when is disappeared.

The improvement may have been caused by moving to the latest version of Visual. We were on Access 2013 before. The tip here is that upgrading to the latest version can improve performance.

I recently upgraded from stand-alone Access to Microsoft OfficeProPlus. This resulted in huge improvement in stability, especially in multiple-user situations.

I was able to resolve this. The driver needed to be in c:\Users\<User Name>\AppData\Local\SeleniumBasic. There is a clear explanation on udemy.com

Union Select Queries are always slow, significantly slower than running the 2 queries separately. Could you have a single delivery schedule table, and then update the table when the delivery is received?

I am trying to use Selenium to interact with websites. However, whenever I try to run I receive errors, with a different error for each browser. Is there something else I need to download? My code Function AutomationTest() Dim bot As New WebDriver bot.Start "firefox", "http://google.com" End...

Check out the sourcebook from FMS, https://www.fmsinc.com/MicrosoftAccess/modules/index.asp. It has code to list all objects in the file and lots of other goodies.

I don't recall exactly which program was causing problems, but the issue was at the server level.

We recently converted our ERP from Oracle to SQL Server. While Oracle automatically saved the password, SQL Server demands the password be typed in, creating a problem for activities run overnight. What is the best way to connect to SQL Server automatically?

There is no limit if you are in the Datasheet view. A continuous form looks like a datasheet, but Access treats it differently. That is what confused me, a datasheet view is not the same as a datasheet form.