Search results

Even the ones that are simple run like syrup with most taking at least 2 seconds to resolve. Although that might just be web stuff and not form specific. My googlemail account takes about 4 seconds to resolve. Pages on this forum resolve quite well for me still takes 2 seconds. My wordpress...

IMHO - the only reason to move away from an ms access application is to take advantage of the web and even then you can get round that with cisco / terminal services. I can't see why I will stop using some of the applications I have already built if they continue to work - it would take me too...

Hi Z Here are a few templates that I use for EAVs / child tables Firstly if I have multiple child records but I want to pull out specific maximums or minimum based on date or vector. When placed in a table this can nicely assist between comparison of entitities. EG - Please give me a list of...

I think your choice of the EAV is right on the money. The SQL Server types that I've come across have disliked it in certain circumstances because they have been focused on applications that are externally facing with 1000 of concurrent occasional users that have little or no focus on the system...

I like EAV models for storing information about entities the attributes of which are not particularly predictable. I will typically have the entity as a FKID to the parent. Attribute might be a lookup and then Value will typically be largish text and sometimes even a memo. I quite like it for...

Creating your own software to be used in a professional environment urgently is a serious undertaking either if you do it yourself or you commission another. Either way it is like writing a book - it is likely to take months at the least and is usually something that people come to slowly after...

For anyone following this I would always recommend 32 bit windows drivers and 32bit version of MS Access. Here's a link to database drivers. https://dev.mysql.com/downloads/connector/odbc/ Be very careful with primary keys as well - in SQL SERVER big int which is often standard primary keys...

If you are just staying with desktop environment there is little point in re-development the best of the rest is only as good as MS Access in my opinion. The next step would probably be to go to the web - that way you get round the issue with Mac / Windows dual development. And when selling to...

As per Uncle Gizmo there are two common paths - PHP or ASP There are low coding environments for the web I actually use something called php runner which I find excellent which is made by a company called Xlinesoft Xlinesoft - PHPRunner and ASP Net Runner And this is a basic review of my...

You might find this helpful My investigations on the same subject https://rounduptheusualsuspects.org/?p=1360

Once you have an account and have created a database it is very easy to link it to MS Acces FMS inc have a great web page on how to link Acces (most versions) to MS Azure Its actually very easy http://www.fmsinc.com/microsoftaccess/cloud/link-to-azure-sql-database.html

Think this might require money :cool: As a long term project I would suggest Learn about SQL Azure - a developer database monthly pay as you go is about £5 a month for a 2gb 5DTU basic SQL Server database. Its actually very easy to spin up a database now. Getting information in and out of...

I believe 2016 has big int support but I guess this has not been an issue for you. I also read that somewhat crazily this did not extend to the runtime version. https://www.devhut.net/2018/06/05/access-runtime-the-database-you-are-trying-to-open-requires-a-newer-version-of-microsoft-access/...

Top work MajP thanks for assisting.

I tend to build systems where there my popups are set to modal yes and I only have one of these open at any one time. I just find it easier to manage.

Not sure yes its possible to run a vba function from the desktop using a vbscript I have something sorted so I can run compacts. http://rounduptheusualsuspects.org/?p=1386 This is the vbscript which shows where you put your function name it doesn't entirely run it from the desktop though. It...

Congratulations from a newbie

Here are some musings I have seen a number of systems like this that send stuff. Be aware that you are probably not going to be sending anything anywhere in the design. You simply have a case file that gets allocated to different individuals. I would suggest that that information is held in...

Firstly I would recommend looking at SQL Azure databases which is the first step into experimenting with web databases. I am essentially echoing Gizmo - experiment with Web but I wouldn't deprecate Access. At the end of the day if you have any form of LAN then it is likely to be cheaper to...

I think with patience and a following wind that strategy might work.