Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Errors + Error Handling _ Access 365 - Form Crashes Access On Single Workstation.

Posted by: amcintosh Sep 25 2019, 08:33 AM

Got a weird issue with my access i'm wondering if somebody may have encountered this before

My computer, and only my computer that Running Access 365 ver 1908, seems to hangs on opening up a certain form, which opened up in the past just fine
This happens before and after i had wiped my computer (non-related reasons)

Other computers, some running the same version of Access, and one running Access 2013 have no problems with it (form opens and works as intended)

The Form that I'm opening basically contains Navigation pages to sub forms with 5 datasheet, which essentially only reference 3 tables that is hosted on a SQL Server 2012.
I had recreated the ODBC connection using SQL Native Client 11 and opened up the linked tables within access that seems to be fine.
Try de-compiling and compacting the database to no success

any ideas? got me stumpted

Posted by: Jeff B. Sep 25 2019, 08:55 AM

Although it (sounds like it) is working on other machines, have you also looked into deleting and recreating that particular form?

Posted by: GroverParkGeorge Sep 25 2019, 10:03 AM

We can't see the code or other objects, so we'll need to ask some clarifying questions.

When you say "hangs on opening up a certain form", does that mean nothing happens but the spinning circle of patience? Or that an error is raised?

One possibility is that there are library references in this accdb which are not available on this computer. Have you checked that?


Posted by: amcintosh Sep 26 2019, 06:29 PM

Thanks

Was hoping I didn't have to rebuild the form in question, but looks like I may have to

I had a look at the VBA references, although I have only deployed the standard references such as...





Posted by: amcintosh Sep 26 2019, 06:32 PM

QUOTE
When you say "hangs on opening up a certain form", does that mean nothing happens but the spinning circle of patience? Or that an error is raised?


No error, spinning of circle of patience, occasionally it appears to have loaded but when click on something it just hangs.
Normally I have to kill Access process to exit.