As per the DB, a cloud-based solution would help to remote the database, avoiding a local server, while for the front end, either a local ACCDB or web based solution (probably more costly) would be fine for us
This is a great and simple idea, which will cut development costs. Efforts will be required to convert the OCX grids (Gridex 2000) to some sort of native ACCDB supported grids, updating the VBA code accordingly.
More info for everyone:
Current System Details:Database: Hosted on SQL Server 2008...
To all:
Two users, both remote
Used to be in LAN, clients running on WIndows 10, server Windows Server 2019 + SQL Server Express
This is best forum section to ask for advise. Developers must know the Access/ADP logics and migrate logics behind forms (maybe using ChatGPT, haha) to the new cloud...
Not sure what you meant exactly, but the database connection is often lost by the client, requiring Windows Server 2019 to be restarted. Also, Anydesk has downtimes too
Well we want to avoid service interruption, and the only idea that comes into my mind is to convert/migrate the app in an other environment/platform. Users are currently accessing the client through AnyDesk, which is bad. Network connectivity interruption and database disconnections are very...
Hello George,
I used to be the developer, however I am now focused on other projects and don't have enough time to spend on the migration. Therefore, a decison has to be made: keep the project as is, whit all the risks this entails or migrate.
Cloud based: yes. Since the users who are involved...
Hello and thanks for your thoughts!
This was developed with Access 2003 32 bit and Gridex 2000 OCX.... none are supported anymore. It might happen that on a future Windows update, the app could stop working!
Is there anyone here interested to develop a new front end and migrating the database...
Hi everyone,
I’m looking for guidance on the easiest way to convert an existing Access 2003 ADP (Access Data Project) to a modern cloud-based solution. The application connects to a SQL Server backend and includes several forms, reports, and VBA-based logic.
Here’s what I’m trying to achieve...