Search results

Thanks everyone for your feedback. I'll follow the suggestions given here and post back the outcome. TIA Regards,

Thanks, I added the trusted location, copy the FE to users desktops, but I get the following error: TIA Regards,

Greetings, I’m using access 365 in be/fe environment. The be is stored in the shared folder and each user has a copy of the fe on the desktop. Following are some issues I recently start experiencing: 1. Everyone can access the copy of the fe on their desktop, but some people experience issues...

isladogs Unfortunately, I tried this in the past and it's a no go. At this point, I think it's best not to delete the Name AutoCorrect Failure table form the dev & production environments to avoid circular reference and/or other errors. I'll keep researching this issue and post back if I find...

Thank you, Yes, I noticed the error after deleting the NameAutocorrect table I brought the idea of uploading a copy of the db to my supervisor and it's a no go. TIA Regards,

Sorry about the confusion. I have three environments: sandbox, dev and production. 1. I deleted this table only in my sandbox environment. And, only in the sandbox environment is where I get 'circular reference error. As per your request here is a sample SQL view: SELECT tblPICTSDATA.PICTSID...

Yes, but not sure how to go about fixing these issues. In my sandbox environment I can not open/edit all queries after I deleted the the name auto correct save failure table due to circular reference caused by 'tblMytableName' TIA Regards,

I didn't make a a backup of the database prior to deleted the table as I did this sandbox environment. I get name auto correct save failure in both development & production, but not yet deleted the table. TIA Regards,

Thanks, ' yes, (screenshot) 2. I'm not familiar with the two forms listed. I even searched in the front end & they do not exist in the DB. 3. After I deleted the Name AutoCorrect Save failure, I attempted to open existing queries and I get "Circular reference caused by 'my table name' TIA...

1. Where exactly can I locate 'links' so I can post a screenshot and answer your question. Is it in the front end? The info in the name autocorrect save failures given were Object Name frmKickOutDB frmMaxCallID Object Type: Form I'm not sure what exactly this means. I assume this is the...

isladogs, thanks. when I click links, what I see is my table names (screenshot) Before I delete, below is the content of the Name AutoCorrect Save

Noted, thanks for the suggestion!

Hi theDBguy, Thanks for the reply, also for the useful resources. So, whenever creating a query and adding tables, is the screenshot in my OP what I expect to see moving forward? TIA Regards,

Greetings, When creating query and attempted to add table, I noticed few changes: 1. One of the tables has a yellow border in the relationship window. I researched online and learned office 365 has a new feature to allow selection of multiple tables 2. . When I right clicked and selected...

Thank you everyone for your inputs. At this moment, based on the feedback I got from you, and from what I read online on this topic, I was able to convince the management to keep using the remote desktop solution. I appreciate all your help!! Regards,

Greetings, We are using office 365/ ms access db split into BE/FE. The BE is located on the shared folder on the server and each user has a copy of the FE on his/her desktop. Currently, everyone is working from home using their laptops and accessing the database via remote desktop. Which seems...

Pat, thank you for your detailed explanation. 1. Special character: I understand your point, but as I stated in the past the database was created by someone else who no longer with the company. What makes things harder to troubleshoot is that there was no data dictionary and or documentation...

Hi Arnel, Thanks for your suggestion. I'll definitely try to implement your method. I just finished cleaning up the excel file and successfully appended new providers to the database. Now, the provider list grew to 105K. I'll post back if I still notice any performance issues. I appreciate...

Hi, Sorry about the confusion. To answer your question, I’m not 100% sure. But, my understanding, or the intention is when creating a new provider case the system was to: 1. check if the provider is in the exclusion list. The exclusion table currently contains (about 5k records). 2. see if...

Thank you both. Arnelgp: Where do I check to see if the person who design the db maintained an open connection to the back-end db? As for the reason behind for ‘searching’ my understanding is: 1. to see if the provider is in exclusion list (there is a table that stores the excluded providers)...