Search results

How can I check that X workstations are connected to the database server and block the X+1 workstation that tries to connect?

How can I automatically communicate with an Access-based management system and e-commerce systems, such as eBay, from a seller's perspective? By 'communicate,' I mean: - create sales listings - receive purchase order notifications - manage tracking messages for shipped items

I use MZ-tools, and one of the features I use most frequently is adding error routines, line numbering, and line de-numbering Many forum users will surely be familiar with Mz-Tools, as it's a truly useful tool How can I achieve the same effect (inserting a few lines of code with variables taken...

What PC hardware/software is needed to run Microsoft Access quickly? Suppose Access is the only application running on a computer What hardware, operating system, and configuration is recommended to maximize the performance of the running application?

How can SQL Server send a "message" to an Access procedure when a certain condition occurs in the data? For example, suppose we have an ARTICLES table that, in addition to other fields, also has ARTICLES_ID as the primary key Suppose the condition is "any change to a record" Suppose the article...

Sometimes it might be useful to 'interlock' two different structures to execute a query and feed a recordset For example, a physical database table called ARTICOLI and an in-memory string array ARTICOLI_CODICI containing only the item codes to be displayed could essentially be 100-200 strings...

What's the best way to implement TCP socket communication for 64-bit Access? The winsck.ocx library works fine in a 32-bit development environment, but what can I do to use 64-bit Access? I saw this code on Spiceworks Have any of you used it with good results?

I see that specific add-ins for Access already exist that allow you, , by leveraging the capabilities of ChatGpt or other similar systems, to both create code based on a text query and optimize/verify existing code The question is: how are these tools built? I mean, if you want to build a tool...

I see that n8n also has connectors for Microsoft Sql Server, so connecting to an Access project could start with the data Has anyone experimented with n8n and offer some advice?

I have an Access procedure that searches for newer versions upon startup If available, downloads them to the root program directory and creates a new icon on the desktop to launch them Sometimes, newer versions require an additional library in the references; otherwise, the code won't work...

Why the row InserisciRecordPrincipale = rs("ID_FERICEVUTE") not recognize rs("ID_FERICEVUTE")? When RS.UPDATE is invoked, rs("ID_FERICEVUTE") lost his value Going step by step, you can see that the rs("id_fericevute") is correctly readable up to the rs.update line Without Close, or...

Rather than access code, it's a matter of how to perform a file copy and read procedure without having to reread the files already read These are XML invoices; they normally arrive in the directory c:\fatture and remain there forever When the operator decides to acquire them into the...

Has anyone ever used DaDaBik? It's a project designed to create forms and reports connected to a database, accessible via the web with a simple browser Essentially, it prepares HTML/PHP/CSS code that is then executed on a local/public web server I personally tried this program many years ago and...

Ask ChatGpt, and it seems it's possible to connect to the router's TCP port 1012, which is what their Call Monitor program does But I can't find any information on which commands can be received from the router to the PC and vice versa wich command to send from pc to FritzBox to strat a call, to...

Is there an automatic system for converting Access code from 32-bit to 32/64-bit? I'm asking this because, after manually adapting some parts, I see that it essentially involves duplicating the definitions of functions called from external libraries and adapting the code by replacing the Long...

I have a procedure that I'll call procedure10.accde, which is normally launched from a desktop icon whose properties contain the path and name of Procedure10.accde Procedure10.accde (and possibly subsequent versions) are connected to data on a database server via an ODBC driver A function within...

I have a project created with Access 2013, 32-bit I normally use this procedure to export the entire project to a text file and archive it (VCS_ImportExport.bas / ExportAllSource) After the last export, I also followed the reverse procedure, and then tried recreating the project from the newly...

Using Visual Studio, you can appreciate the ability of external extensions like Gemini Code Assist to support developers in creating new code fragments useful for the current project. For all non-specialized tasks that require specific optimization, the assistant is an excellent tool and allows...

https://www.tomshw.it/hardware/piattaforma-ai-cancella-database-aziendale-per-errore-2025-07-21 ...Its automated system deleted an entire company database containing thousands of records, then attempted to cover up the incident with what many called "dishonest behavior." ... It's learning to...

Which is the best way to select rows in the current recordset? How do you filter the recordset to display on a form/report? Are there any specific reasons for using the first or second method? Personally, I almost always tend to use SQL string selections, which are then passed in their entirety...