Search results

I will make sure that the Option Explicit is placed in all modules, forms, reports. If it is not present then it can compile but may cause problems. So it has to compile with Option Explicit present to be on the safe side. When I close my .accdb the locking file will close if no-one else is...

The number is at least 2048. Would it help if I set the Has Module to False for many of the forms and reports? Edit: There is no problem in creating .accde for the smaller dbs

Could this be the problem?

I will try the above. Well I spoke too soon. I was able to create once the .accde and then I get the same problem. Basically that the .accdb is already in use. In the Help it mentions that there may be too many TableIDs

I fixed the problem by moving everything on a new pc. The old pc was a generation 6 pc which was taking its time to respond and maybe this has something to do with the problem. It's been a few months now that the creation of the .accde was a matter of luck. Sometimes it worked and sometimes it...

To create the .accde you must be inside the .accdb.

What would zipping achieve?

Rebooted several times. No lock file.

Only Access. FE and BE

I created a simple one table DB and I can open it exclusively and create the .accde

DB FE is linked to DB BE. Both are in a folder under the root folder. Still it will not let me open exclusively

It is telling me that it cannot open the .accdb for exclusive use because another user has the database open or because I do not have permission to open exclusively.

I have compiled the code ... 1000 times😊

I forgot to mention that I am using A2013

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?

The following works CreateObject("Shell.Application").Open ("C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe")

I had tried this before Dim myPath2 As String myPath2 = """C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe""" Call Shell(myPath2, 1) Same problem

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

Let me repeat what I want to achieve: Depending on the value of a control in a footer, I was to be able to set the Height of both control and footer. I can retrieve the value of the control prior to calling the report.