Search results

I have convinced the owner and we have replaced 4 of the old pcs. Things are now fine and hope that they will continue to be. I came across one strange issue. All pcs use the 365 Access runtime. On some pcs the custom toolbar does not appear on the forms that it should appear on. Any ideas?

Can you please explain what you mean? Thanks.

Many thanks for your comments. If you have something and is not a hassle please forward. Meanwhile I just installed on the specific server (not actual server, merely data storage) a proper backup software and have disabled the Task Scheduler events. If interested in the specific backup...

Yes, most of the forms are bound

We do have lots of experience with SQL Server. That is why I am saying that it will take a long time. I am just thinking of one of the forms that has 500 controls. Unfortunately, there isn't a one to one correspondence between .accdb and SQL Server.

Thanks. Can you please elaborate on what you mean by utility to locate corrupted or slipped records?

Also. I read that Access Runtimes may cause problems. Never had a problem with A2013 Runtime, but It appears that there may be a problem with later versions. Would replacing the runtime with Access help?

I never used VSS. In a .bat file, it would translate to something like the following. Will try it out set source="C:\SourceFolder\MyDatabase.accdb" set destination="C:\DestinationFolder\MyDatabase_Copy.accdb" REM Copy the file (overwrite if exists) copy %source% %destination% /Y Edit: Just...

As I mentioned, we also have a VB.net version of the software, which uses SQL Server on Azure. We have moved the .accdb data to SQL server for many of our customers and were able to move most of the data. Changing the Access FE which works with .accdb, so that it works with SQL Server, would...

I use a .bat file to first create a copy of the .accdb and then I copy the copied file to OneDrive with a timestamp. I include the .bat file below, which runs with Task Scheduler @echo off for /f "tokens=1-4 delims=,: " %%i in ("%time%") do ( set hour=%%i set minute=%%j set second=%%k set...

I agree with most of your analysis. We also have a vb.net cloud version of the software on Azure. The specific 300MB db is the result of a dentist who has been a client for about 20 years and grew from 1 to 15 dentists. We have specific db on about 150 other locations with no problem. Some the...

Only a copy of the .accdb is copied

The db is local, the copy (backup) is copied to the cloud, basically OneDrive

Until about a year ago I also used A2013 and it did serve me well. I was using 32 bit and invested the time and made it work on both 32 and 64 bit. I now use A365 and even though it runs on both 32 and 64 bit, I have upgraded all clients to 64 bit. It makes my life a bit easier, since I do not...

As far as I know no, but will confirm.

As I mentioned, it failed to install and was searching for a url that could not find. Seems like the product is not supported.

Goes up to A2016. I use 365. Towards the end there was a problem with the installation.

Also, what is not helping is that the tables are linked. The patient table has 20 000 records, each record has many fields, so each time it deals with this number of records. The software also has a connection to a telephone system and can dial telephone numbers and lookup incoming telephone...

In our case the forms are complicated, one has 500 controls with graphics etc

The corruption is in the BE. The same FE works fine in the non-corrupt BE