Recent content by Minty

Without seeing the current system, it almost impossible to gauge the time it might take to "fix", as we don't know what works, what doesn't, and what new functionality might be required straight away. A very basic method to get an idea of time scales would be to look at each form, and allocate...

I would have a read here, about how to validate records correctly. https://www.access-programmers.co.uk/forums/threads/bad-data-is-bad-for-business-1-and-2.324342/

Not that I can remember. There has never been a inbuilt method to create an .exe in Access. Have a read here for how to secure your database: https://isladogs.co.uk/compare-access-file-security/index.html

We took over a well documented and well written, but in need of modernising system that sounds very similar to yours. It was having issues with size performance, occasional corruption and wasn't split! We decided to move it to Azure SQL server, as they had a new requirement for web based portal...

The T-Sql should be identical, if anything you will have newer features available in Azure SQL than an older locally based one, depending on SQL Server versions used. Assuming the current SQL Server is local and the Azure server is stuck in the cloud, there will be a performance hit, unless you...

SQL Server does indeed tend to grab as many resources as the OS it's mounted on will sensibly allow. I have 64Gb RAM on my laptop, and if I fire up SQL Server on it it will pretty much grab ~30Gb or more straight away. That has nothing to do with Access, it's to do with SQL Server allowing...

^^^ This is the big problem. It's just too expensive for a SME to justify. I can get a simple but well built website connected to a Azure SQL backend and hosted for 100's of users for £25-30 a month as a single cost. Okay, there is the initial development cost of the website, but that is tiny...

Just as a FY I - You can still build power apps and flows on a Azure SQL back end.

I'm not sure if setting a form to data entry stops it loading the entire table in the background? What if you set the recordsource to tblCustomerInvoices where 1 = 0 ?

You need to open it using the correct parameters, so you need to set the query def to return records. Something like (untested) strQuery = "; With myCTE as ( blah blah blah)" Set qDef = db.QueryDefs("qPT_Generic") qDef.SQL = strQuery qDef.ReturnsRecords = True qDef.Close set rs =...

If you want to judge price differences simply look at a UK site like eBuyer https://www.ebuyer.com/ That will give you some idea of the cost in the UK. How that translates to a local India suppliers costs, I have no idea, but it would give you an idea of specification and a comparison.

I don't think you could use Lag or any of the other windowing functions available in SQL other than in a pass-through, unless I'm missing something?

I have a large system that we have recently taken over supporting and have moved to Azure BE. It uses Docmd.SendObject extensively, and I was looking to refactor it to use Outlook Automation instead as it's more customisable. However, I may hold fire if it's not going to work long term, what's...

Although long winded and possibly unnecessary if the other suggestions work, you could use OpenArgs in the form open options, to Pass in a string "New" when opening the form, and use that in the forms load event to go to a New Record

Is there any update on the future status of this, I have had a client asking me?