User Profile
George_Hepworth
Silver Contributor
Joined Mar 07, 2018
User Widgets
Recent Discussions
Re: Move Existing Sharepoint Linked Database to a different Sharepoint Site
I have never tried to copy SP lists from one site to another, so I'm unsure what to suggest with regard to that. I somewhat doubt that is an easy thing to do. However, perhaps one way would be try to export the existing linked SP's to the new subsidiary site. Make backups first, of course. See if that accomplishes the goal. You may have to also relink this accdb to the new SP lists. I've not tried this, but it seems like it ought to work. Of course, you'll also want to avoid moving the data. Years ago, I wrote a series of blog articles, when Access with SP lists were relatively new. Maybe there's some relevant content there. https://www.gpcdata.com/search?q=sharepoint check out the articles on migrating data and tables.Re: Move Existing Sharepoint Linked Database to a different Sharepoint Site
Trust settings refer to the location of the accdb on your computer. You have to designate the folder where the Front End accdb is stored as a Trusted Location. You must have done that already for the existing deployment. Take a look at how that was done. You will not actually export the Access file itself to the new SharePoint site. You will only link it to the new SharePoint lists there. When you do that, a dialog will open asking you for the location of the SharePoint lists. Enter the URL and select the lists/tables. This is assuming that you have already created the lists needed for the subsidiary on their SharePoint site.Re: Access adds brackets to text in quotes in Iif statement
I suspect you've fallen prey to using a Lookup field for the field named [PRM Pre-Medicare Plan ID] Presumably it has a suffix of ID because it stores the foreign key for the Plan. The ID for that related Pre-Medicare Plan is not a text string, it is the numeric value. In other words, despite that fact Lookup fields SHOW strings like "NOCOV", they actually store a number. Therefore, when you try to use the string value displayed in that Lookup field, Access isn't able to resolve what the heck you mean and assumes you are trying to reference something else. The better solution is to rip out Lookup fields in tables and explicitly store ONLY the relevant Foreign Key value for the ID. That disambiguates a lot of things, such as this IIf() expression. A work-around would be to use the actual number for the "NOCOV" record's ID, not the display text. I may be wrong, of course, but this scenario, along with the tell-tale "ID" in the field name suggests it is a likely reason for the errorRe: Move Existing Sharepoint Linked Database to a different Sharepoint Site
It would help us to help you if we knew what struggles, specifically, you have encountered. In theory, the steps would involve Recreating the SharePoint lists for the database application on the subsidiary's SharePoint site. Creating a copy of the accdb Front End with whatever customization is needed, such as replacing organization names in labels, etc. Putting that accdb Front End on a computer in the Subsidiary's network. This can take various paths, so tell us what you tried and what happened. Relinking that accdb Front End to their SharePoint links. Putting a copy of that master accdb Front End on the computer of each intended user. Where in that path, specifically, did you encounter problems?Re: Attachment.Add issue
There are a few different ways to handle this. One might be: ... .Attachments.Add Iif(Option1 =-1, OrderEntryProcedure, "") ... Another might be: ... If Option1 = -1 Then OrderEntryProcedure = "File location" Else OrderEntryProcedure = "" End If Both assume that a ZLS would satisfy the requirement .Attachments.Add must have a value. As an alternative, you could wrap the line .Attachments.Add OrderEntryProcedure in a conditional and only include it when Option1 <> -1. Try those options and pick one that works in this context, or let us know if you need further refinement.Re: 3044 error in Access
You can use the Linked Table Manager to fix the path for the errant database, You'll find it under External Data on the Ribbon. One possibility is that the original link was created on a Mapped Drive, rather than the UNC path to the back end. It's always safer to rely on UNC paths for linked tables.Re: Should be easy...... Open a form to a specific record
It can be helpful to incorporate fully qualified parameters in cases like this to avoid the problem of putting parameters in the wrong position. Consider, for example: DoCmd.OpenForm formName:="frmYourFormNameGoesHere", view:=acNormal, FilterName:="SavedFilterNameGoesHere", WhereCondition:="ID= " & LngValue, datamode:=acFormEdit, WindowMode:=acDialog, OpenArgs:=lngAnotherValueIDRe: Microsoft Access and Outlook
Your new laptop now has "New" Outlook, which no longer supports COM automation--in this case the ability to automate sending emails. The solutions available include rolling back to "Classic" Outlook, and developing a different approach to automating the sending of emails from Access. https://www.accessforever.org/post/new-outlook-the-situation-in-december-2024Re: Database in an "inconsistent state" and other errors
Access is telling you the truth. This particular accdb has been corrupted and is no longer usable. The alternatives are trying to find a repair service which you can pay to recover as much of it as possible, or going back to the last previous working backup copy. Depending on what is in that database, the cost of a repair service might not be justifiable. If you decide to try that approach, check out https://www.everythingaccess.com/accessdatabaserepair_info.asp Since you indicate that the most recent backup you have is also corrupted, you may have to go back to an even earlier saved backup, or perhaps it can be used to recover the objects that are not corrupted. Create a new empty accdb and try to import the tables, forms, reports, etc. from that partially working accdb. After each import check to see if is okay at that point, then proceed to the next. When you get to the point where an imported object doesn't work, or fails to import at all, you'll know where the corruption is. Good luck with the recovery.Re: Access SQL Syntax Highlighting, Autocomplete, and Formatting
Here's the key: " ... there is a checkbox for the Monaco query editor in Access on my laptop, but not my desktop." The Monaco query editor is actually the feature that supports enhancements to the SQL editor. If you do not even have the checkbox to enable Monaco SQL Editor available in the version of Access on your computer, that would probably indicate it is actually an older version of Access, not M365. If it is there, check it to enable Monaco. Can you verify the version of Access on both in case you don't see the option for Monaco? You'll find it under File-Account.Re: You must start microsoft access by double click
Apparently, the trial version of Microsoft 365 which you installed does not include MS Access. The version of Access on that computer is NOT the full version. It is the runtime version only. The runtime version only allows you to open existing accdb (Access database) files. It doesn't allow you to create or modify databases.Re: Access Abfrage Schaltfläche Ausführen! deaktiviert
If you are talking about the disabled option to "Run Selected" as shown in your screenshot, then you should know that it applies in SQL view, not in the QBE view. It is part of the Monaco SQL Editor. It allows you to select part of a query and run only that part, not the whole query. If you are saying that the button itself, and not just the option below it, is disabled, that is a different matter.Re: Troubleshooting Queries in Access
We don't have enough information to know what the problem could be. Why are you deleting old tables at all? Why are you then importing "new data for these tables"? Does that mean you are actually re-creating those same tables with new data? Why not delete the data from those tables and simply reimport new data? In fact, deleting data is probably not something we'd normally expect to see anyway, so please elaborate on the business purpose being supported. SHOW us the query that is expected to populate the table. What table would that be, by the way? Is it one of the ones being deleted and re-created? Or a different table? What data is being used for this repopulation? We need to see the SQL from this query, not a screenshot of the query design view. Once we have a better picture of what's going on, we can offer useful suggestions.Re: Access Query Finding Old/Deleted Data
What does it mean to say that you uploaded a new version of the "Medical Department and Chair" table to override the existing version? Uploaded to where? Again, I am not sure that you actually replaced the table as it is used in the current database. To repeat, please describe, step-by-step how you did that. It does appear that you have a split database, with a Front End (FE) accdb contains the interface and logic objects and a Back End (BE) accdb containing only tables. That's good. The problem appears to be that the link from the FE to the table in the BE was not changed when you "uploaded" a new version of that table to the BE. That implies a) the new table is there in the BE in addition to the old table and that b) the process did not include changing the link to that table. That's why I want to see a screenshot of the Navigation Pane showing all of the tables, please.Re: Impossible d'installer Windows 10 22h2
Unfortunately, you posted your Windows Installation question in a forum for support of the MS Access application, which is used to create relational databases. Please repost your question in a forum that supports Windows Installation to get the attention of people who can provide pertinent suggestions.Re: Access Query Finding Old/Deleted Data
Please explain what you mean by "replacing outdated tables". Please describe, step-by-step how you did that. Queries can only retrieve data from tables when the tables are available, so that old data does exist and that implies the original tables are still available, not replaced. It would be very helpful to see a screenshot of your navigation pane showing ALL of the tables in the accdb. Thank you for helping us help you.Re: Access Not Responding
Unfortunately, it's very hard to guess what the problem in this particular situation could be, based only on knowing that Access stops responding. In order to help us help you, provide a step-by-step description of what you have to do to produce the error. Include information about the version of Access and about the version of SQL Server involved. The more detail you provide, the better the chances are that someone will recognize potential problems in your environment and procedures.
