Search results

Can Access 365 and Access 2013 coexist and I am not referring to the Access 2013 Runtime. Can these two versions of Access exist and can development take place in both these versions on the same pc?

When I try to create .accde I get the following error In Bitdefender I get I read that Windows Defender can handle this threat. I made sure that Windows Defender runs on my pc. I also ran a System Check in BitDefender. Di dnot help. Any ideas?

I am trying unsuccessfully to connect my O365 Access FE to the SQL Server on a network. On a standalone pc there is no problem. The SQL Server properties and Connect string are shown below: ODBC;DRIVER=ODBC Driver 17 for SQL...

I want to automate downloading an update in the form of an ACCDE. I am able to check a URL for an updated ACCDE and download it to the user's pc. I cannot change the ACCDE which I am running to the update, unless I close the ACCDE. This would require running another program which would simple...

I believe the Access 2021 is the latest version I can get as a standalone. I have not been able to find a download place on the web. There is mention of the Office Deployment Tool below, that may be relevant: Download and install Microsoft 365 Access Runtime - Microsoft Support Can I buy A21...

If any of the Connection parameters to the SQL Server is wrong then I get prompted to enter the SQL server password. Is there a way to check for the presence of the SQL Server without the user being prompted for the password. I use a DSNless connection from A365 to SQL Server Express and the...

Suddenly I notice in the Task Manager that Access tasks continue to run in the background, after I exit the application with Application.Quit. There is of course the nuclear option of a batch file running cmd /c taskkill /F /IM "msaccess.exe" which would kill all Access Tasks, something which...

When the SQL db is on the same pc as the Access .accdb, I can use a connect string like "ODBC;DRIVER=ODBC Driver 17 for SQL Server;SERVER=DESKTOP-KQTNJ42\SQLEXPRESS;UID=savf;PWD=1234;Trusted_Connection=No;APP=Microsoft Office;DATABASE=VF1" To modify the connect string to access the SQL db on a...

I am referring to Method 1 in Create DSN-less connection to SQL for linked table - Microsoft 365 Apps | Microsoft Learn The beginning of the module is as follows '//Name : AttachDSNLessTable '//Purpose : Create a linked table to SQL Server without using a DSN '//Parameters '//...

I have a form A which displays, among other things, the value of a field based on some table values. Form A calls Form B which calls Form C which changes the table values, which affects the field value on Form A. I tried using acDialog when I open Form B and Form C, but when I do this Form C...

All of a sudden (and after a Windows update) I get the following error when I try to Update. Otherwise the program works fine. I use Access 365 and SQl Express The Windows update info is Will try to uninstall Windows update. BTW, I deleted the table tblSerial and recreated it.

I have the following RecordSource SELECT dbo_tblManagementCommitteeInstance.intID, dbo_tblManagementCommitteeInstance.intManagementCommittee, dbo_tblManagementCommitteeInstance.dtmFrom, dbo_tblManagementCommitteeInstance.dtmTo, dbo_tblManagementCommitteeInstance.bitD...

I guess that the latest version of Access with a Runtime is Access 21. Does anyone know whether a newer version will appear soon?

The requirement is as follows: A number of documents (say 10) belonging to different companies get scanned into one pdf file. The user is willing to place on top of every separate document a page where information is stored about the company and the folder that the document will be stored in. It...

I am about to deploy by first application that uses Access as a FE and SQL Server as a BE. In the products that I have developed that use Access as a FE and ACE as a BE, I use the Runtime in this case for Access 2013. Installation is fairly easy and if I want to add a new field in the ACE BE I...

I am running A365 as a frontend to SQL Server I have a form called "frm3" which is made up of 6 subforms I have created a report "rpt3" which shows the same data and is made up of 6 subreports The 6 subreports use the same queries as the 6 subforms When I try to call rpt3 from frm3 I get...

I have Recordset rst1 which is the result of a query dim strSQL as string strSQL = "SELECT tblAppointment.lngAppointID, tblAppointment.lngPatientID, tblAppointment.dtmAppointDate, tblAppointment.dtmAppointTime, tblAppointment.txtAppointDesc, tblAppointment.chkKeptAppointYesNo, " _ & "...

I have an Access FE and an SQL Server BE and I use linked tables. I would like to relink the existing tables and also be able to link to a copy of the SQL Server BE, situated elsewhere.

When running a report I make some calculations and I end up with a value that I want to place in an unbound control on the report footer. The value does not appear on the report footer. I tried using the On Print event and On Format event of the footer, but to no avail.

I use Access as my FE and SQl Server as my BE. I want to be able to insert an image into the SQl Server BE from my Access FE and be able to display this image. I looked at the following link Insert a picture into a Access table with a SQL Server Backend - Stack Overflow but it gets stuck at...