Search results

I get, "Could not use <Specific filename.accdb>. File already in use." when I try to create the .accde using 64-bit A365. The .accde is created ok when I use the 32-bit A365. Both the 32-bit and the 64-bit use the following Version and Build

Was wondering whether Access 365 installed on a pc can update the calendar of 365 Business, which apparently is stored on the cloud? If this is possible, then the next requirement would be to update a specific calendar belonging to a specific user.

I am having a problem with finding the 64-bit version of the following Declare. I notice that its Lib is "msaccess.exe" Public Declare Function ezGetFileInfo Lib "msaccess.exe" Alias "#56# (FSI As ezGetFileInfo, ByVal fOpen As Integer) As Long The function does not exist in...

Can A2013 Runtime coexist with A365 Runtime? More specifically, if A2013 Runtime already exists, can the A365 Runtime be installed?

I have a .accdb which is 92Mb and lately it is difficult to create a .accde. It is telling me that the .accdb is still in use. Does this have to do with the TableIDs that are created during the .accde creation process? Any ideas?

In the Target of a shortcut I run the following .exe successfully "C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe" When I try to execute the same with Shell, Dim myPath2 As String myPath2 = "C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe"...

Does anyone have a sample .accdb which can communicate with Google Calendar, both read and write? Thanks

I have a Report Footer called "GroupFooter1" and in this footer a Bound Object Frame called OleSignature. We check the value of OleSignature inside the Footer and if it is Null, then then there is no need to have OleSignature displayed. Ideally I would like to set its Height to 0 and at the...

The following used to work. Now it cannot find the file and WinHttpReq.status = 404. On Error GoTo Failed Dim oStream As Variant Dim WinHttpReq As Object Set WinHttpReq = CreateObject("MSXML2.ServerXMLHTTP.6.0") WinHttpReq.Open "GET", FileURL, False, Username, Password...

Am I correct to assume that the latest perpetual version of Access is 2021? If yes, is another version expected in 2024? At present I am using A13 for development and A13 Runtime for deployment. I understand that Microsoft is pushing O365, which I have and have done development using A365. I...

I am trying to make my 32bit Access 2013 work with 64bit. The following works in 32bit: Option Compare Database I tried the following for 64bit compatibility Option Compare Database I receive a problem as seen in the attachment.

We have a dental practice management software (www.VisualDentist.com) and we would like to be able to show a picture of the patient, in the patient details. There is the obvious solution where a picture is taken and stored in a file, which we can link to. The ideal scenario would be to operate...

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...