The Microsoft Access database file which serves as my library contains "linked" SharePoint lists. Within that library, I read and write to those SharePoint lists via Microsoft Access functionality.
I then link that library file via the "reference" method to two other Microsoft Access applications, and call the public functions within the library, which read and write to the SharePoint lists.
drumahh
Last Activity: Nov 3 '16, 02:14 PM
Joined: Apr 17 '14
Location:
-
Very happy, although somewhat disconcerting about Microsoft's obscure features. Within my library database I had to set an option for SharePoint caching, which I would not have thought of. But I have successfully referenced two library access databases and opened them using two apps, so it appears to be a go.
I found the answer here:
http://www.access-programmers.co.uk/...d.php?t=214875
From the...Leave a comment:
-
So I found the specific locking issue. In my library database, I have a linked SharePoint list. When I delete the link to the list, I can open up both applications that reference the same library file.
So, it is indeed related to "table" access. So now I need to figure out if the way I'm linking the SharePoint list can be modified so that it is "shared" - you'd think SharePoint could "share" :)Leave a comment:
-
My hope is not only to include one library database in our main applications, but multiple library databases with distinct functionality. For example, common file writing techniques, imports and exports from Excel or PDF, common SQL routines, logging routines, common open and close Access recordset and query routines, common logon methods etc.
If it works out, it will really streamline our existing and future applications.Leave a comment:
-
Thank you for your reply. I think you are on to something. I used a very simple "HelloWorld " library which has a function that returns a "Hello World". I created 2 apps that call it and they both open without issue.
I will see where I can make references to other tables/Select statements in the prior database and see if it may be causing the lock issues.
Thanks, I'll try and let you knowLeave a comment:
-
Sharing a Microsoft Access reference with multiple databases
I have created a "library" Access Database. I "reference" this library file within another Microsoft Access database by using Tools->References->Browse->
File Name: (Libraryfile.ac cdb)
Files of Type: Microsoft Access Databases (*.accdb)
This works as planned.
When I create a second Microsoft Access that references the same library, it works.
Unfortunately, it... -
drumahh replied to Append Query runs slower in VBA than if I click on it in Access 2007 interface. Why?in Access>>why I asked for the stored query's SQL in hopes that somehting there would help explain.
So does the 1 join SQL statement or the ODBC connection explain anything?Leave a comment:
-
drumahh replied to Append Query runs slower in VBA than if I click on it in Access 2007 interface. Why?in AccessI used Mr. Riggs solution by using a Pass-Through query, and then an Append query referencing the Pass-Through query. The time for the execution is now about 15 seconds. It was 5 minutes using VBA and just over a minute clicking the interface. So, I will be using a Pass-Through queries as much as possible, and bypassing the Access Jet layer when I can. It is truly the best solution
Regarding the SQL and ODBC, here is the neutered SQL...Leave a comment:
-
drumahh started a topic Append Query runs slower in VBA than if I click on it in Access 2007 interface. Why?in AccessAppend Query runs slower in VBA than if I click on it in Access 2007 interface. Why?
My query, "Append_History _Query," appends Oracle data to a local Access table. It has 2 date parameters. It has one join from one Oracle table to another. It is appending approximately 20,000 records, with about 20 fields.
The originating tables are on the Oracle server. There is a primary key - foreign key to the linked Oracle tables it is linking to. The local table it is appending to is empty and is not indexed.
... -
I just ried ByRef and that produced the same error. I tried ByVal just to see and that failed as well.
Code:Public Function ChangeHeight(ByRef SubFormObj As Access.SubForm) Debug.Print SubFormObj.Height End Function
Leave a comment:
-
Thank You
This will work.
I have reattached the zip file of the small sample with the working code.
Fundamentally, the form or subform object should be expected to be used, but this appears to be a better workaround than the one I had....Leave a comment:
-
>>you the to tell the function where is the object..
Yes, that is the crux of the issue. I can't "tell" the function that this is my form object without getting a "Type mismatch" error.
I SHOULD be able to, but Microsoft Access is not letting me.
Thanks!Leave a comment:
-
Workaaround and why I'm doing this
I wish to have a function that dynamically changes the height of a Subform, for any SubForm on any form.
This workaround works, BUT I’d rather pass the form object than calculate it by passing the name of the form and the name of the subform:
...Code:Public Function ChangeHeight(MainFormName As String, SubFormName As String) As Boolean 'Public Function ChangeHeight(SubFormObj
Leave a comment:
-
Attached picture
Hi. Thanks for your reply. The error is:
Run-time error '13':
Type mismatch
I’ve attached a screen shot of the error as well.
I have a workaround in place but it is not elegant, so I don’t mind the delay. Thanks for looking at this in more depth.
[imgnothumb]http://bytes.com/attachment.php? attachmentid=75 98[/imgnothumb]...Leave a comment:
-
Attached Zip File
Hi,
I've attached a very simple zip file with the source that replicates the issue. It has a MainForm containing a Subform.
I did attempt to print out the name of the subform.
I needed to add Me.Subform_grou pNames.Name to your suggestion to print out the name of the Subform....Leave a comment:
-
Using a Form or Subform object as a parameter within a function
From within a form module, I am calling a public function attempting to pass a Form or Subform object.
Unfortunately, I continue to get a “Type mismatch” error when calling the function.
Calling function within Form module:
Public...Code:Debug.Print TypeName(Me.Subform_groupNames) 'Prints out: “SubForm” ChangeHeight (Me.Subform_groupNames) 'Type mismatch #13”
No activity results to display
Leave a comment: