[MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Hi to All,

 

I am trying to connect and link MySql table with Ms. Access, but every time using wizard it shows following error:

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

 

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

 

Any help/suggestion will be highly appreciated.

 

best regards

 

Ahmed Hashim

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116418) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

[MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116419) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Import XML file

Valentino, there is probably also an XML header file but you didn't specify that -- do you have one? Excel brings everything in as flat data whereas Access should separate data into different tables. This isn't an easy task!

kind regards,
crystal

On 29/07/2023 4:20 am, avvisati wrote:

 

Yes I understand this, this is why I asked for help since I'm not an expert

I know that there are two ways to go on:

 

1. Transform the XML from attribute centric like this one  to element centric using xls language- file

And transform from an XML as this one  

 

<person sex="female">

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

 

Try to get something like this one

<person>

  <sex>female</sex>

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

And after import because the Element centric is compatible with Access

 

 

2. The other way is read informatio using VBA, and I wanted to try this

I tried  to google and try to get some example like this one

But I do not succeded  to get the information, or better I can  I can retrive some informaton but but

 

This is why  I ask support of somebody can give some preatical indicatoin where to see

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Arnelito Puzon
Sent: Saturday, July 29, 2023 5:02 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

it is obvious that the xml file is not a well-formed access xml file so it is

not being imported. you need special VBA to create a structure for those

fields in your xml.

 

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

Re: [MSAccessProfessionals] Import XML file

 

Yes I understand this, this is why I asked for help since I'm not an expert

I know that there are two ways to go on:

 

1. Transform the XML from attribute centric like this one  to element centric using xls language- file

And transform from an XML as this one  

 

<person sex="female">

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

 

Try to get something like this one

<person>

  <sex>female</sex>

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

And after import because the Element centric is compatible with Access

 

 

2. The other way is read informatio using VBA, and I wanted to try this

I tried  to google and try to get some example like this one

But I do not succeded  to get the information, or better I can  I can retrive some informaton but but

 

This is why  I ask support of somebody can give some preatical indicatoin where to see

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Arnelito Puzon
Sent: Saturday, July 29, 2023 5:02 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

it is obvious that the xml file is not a well-formed access xml file so it is

not being imported. you need special VBA to create a structure for those

fields in your xml.

 

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

 

--

Arnelito G. Puzon

Re: [MSAccessProfessionals] Import XML file

it is obvious that the xml file is not a well-formed access xml file so it is

not being imported. you need special VBA to create a structure for those

fields in your xml.

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

--

Arnelito G. Puzon

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116415) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Import XML file

Hello to all,

I'm trying to open this file and import In access

I can open in Excel but access importation  do not work,

https://groups.io/g/MSAccessProfessionals/files/8028195.xml

 

 

Somebody has some idea how to import this file in Access?

Valentino

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of avvisati via groups.io
Sent: Wednesday, July 26, 2023 7:17 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

yes

i uplaoded 

you can find it here 

https://groups.io/g/MSAccessProfessionals/files/8028195.xml

it is possible open in excel with no problem but not possible import in Access. I'm almost sure that the reason is that is an "attribute"  based XML and I should transform in an ELEMENT based XML, but I do not know how to do. 

thank you 

 

 

Il giorno mer 19 lug 2023 alle ore 02:02 Arnelito Puzon <agpuzon@gmail.com> ha scritto:

can you upload a sample xml file so that viewers can see it's structure?

 

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

 

--

Arnelito G. Puzon

Re: [MSAccessProfessionals] Import XML file

yes

i uplaoded 

you can find it here 

https://groups.io/g/MSAccessProfessionals/files/8028195.xml

it is possible open in excel with no problem but not possible import in Access. I'm almost sure that the reason is that is an "attribute"  based XML and I should transform in an ELEMENT based XML, but I do not know how to do. 

thank you 

Il giorno mer 19 lug 2023 alle ore 02:02 Arnelito Puzon <agpuzon@gmail.com> ha scritto:

can you upload a sample xml file so that viewers can see it's structure?

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

--

Arnelito G. Puzon

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116413) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Import XML file

can you upload a sample xml file so that viewers can see it's structure?

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

--

Arnelito G. Puzon

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116412) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

Sorry for being late to the party here, but with the situation you're describing, she may just have to use a program that isn't installed on other users' computers and which is being a resource hog. Prior experience tells me that can be especially bad with proprietary fiscal programs, like for accessing trading networks, but really if it's a program more than fifteen years old with security features added over the years, that stuff gets nasty, and it can sometimes even be more helpful to move that program to its own terminal that she just remotes into, even when daisy-chaining the remote set up.

So, have her run her TaskManager and see what programs are taking up her CPU, memory, and network at the time she's trying to run the report. 

Regards,

Shay Holmes

On Wed, Jul 12, 2023 at 7:03 PM Bill Mosca <wrmosca@comcast.net> wrote:

When one computer is exceedingly slower than all others it's time to focus on the slow one. My money is on a malware infection or bad RAM .  Steps I would take:

*Run a full virus scanner like MalwareBytes

*Run CCleaner to remove junk files

*Run a hard drive diagnostics (right click on drive letterin windows explorer & pick properties). 

*Check windows event log for errors.

Better yet  spend some money for professional help. They have the diagnostics. 

Regards,

Bill Mosca 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io>
Sent: Wednesday, July 12, 2023 3:03:04 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

hi Jim,

perhaps her machine has less RAM? That's the biggest bang for the buck, imo.

Or maybe it's time to run malware software? Maybe some program(s) is stealing her machine's resources

To find out what version and build she has:

File, Account --> click 'About Access' command button on right. The top line of the dialog box will tell you -- and it can be copied. Mine is:

Microsoft� Access� for Microsoft 365 MSO (Version 2306 Build 16.0.16529.20100) 32-bit

best regards,
crystal

On 12/07/2023 4:27 pm, Jim Wagner wrote:

There is no errors other than it takes 10 times longer to run the same process. Right now it is a report that is taking forever for her. others can have this run in about 30 seconds. 120K records of historical data

Thank You

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Mark Burns <mburns_08109@comcast.net>
Sent: Wednesday, July 12, 2023 8:50 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>; Jane <jcross@crossproducts.plus.com>
Subject: Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

�

You can build code to check the version and Build # for Office365 for help in diagnosing/isolating office365 patch/versioning issues.

On 07/12/2023 11:07 AM EDT Jane <jcross@crossproducts.plus.com> wrote:

�

�

Hi Jim
It might be that she is running a different version to the rest of you -especially if using a 365 subscription. Sometimes it seems a significant portion of my working day is spent trying to figure out why the same database runs well on 9 out of 10 PCs, but doesn't on the other one.� Invariably it's down to different versions of Windows or Access.
What specifically is the error that she sees that you dont?
Best regards
Jane

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116411) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

[MSAccessProfessionals] Import XML file

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116410) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

When one computer is exceedingly slower than all others it's time to focus on the slow one. My money is on a malware infection or bad RAM .  Steps I would take:

*Run a full virus scanner like MalwareBytes

*Run CCleaner to remove junk files

*Run a hard drive diagnostics (right click on drive letterin windows explorer & pick properties). 

*Check windows event log for errors.

Better yet  spend some money for professional help. They have the diagnostics. 

Regards,

Bill Mosca 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io>
Sent: Wednesday, July 12, 2023 3:03:04 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

hi Jim,

perhaps her machine has less RAM? That's the biggest bang for the buck, imo.

Or maybe it's time to run malware software? Maybe some program(s) is stealing her machine's resources

To find out what version and build she has:

File, Account --> click 'About Access' command button on right. The top line of the dialog box will tell you -- and it can be copied. Mine is:

Microsoft� Access� for Microsoft 365 MSO (Version 2306 Build 16.0.16529.20100) 32-bit

best regards,
crystal

On 12/07/2023 4:27 pm, Jim Wagner wrote:

There is no errors other than it takes 10 times longer to run the same process. Right now it is a report that is taking forever for her. others can have this run in about 30 seconds. 120K records of historical data

Thank You

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Mark Burns <mburns_08109@comcast.net>
Sent: Wednesday, July 12, 2023 8:50 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>; Jane <jcross@crossproducts.plus.com>
Subject: Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

�

You can build code to check the version and Build # for Office365 for help in diagnosing/isolating office365 patch/versioning issues.

On 07/12/2023 11:07 AM EDT Jane <jcross@crossproducts.plus.com> wrote:

�

�

Hi Jim
It might be that she is running a different version to the rest of you -especially if using a 365 subscription. Sometimes it seems a significant portion of my working day is spent trying to figure out why the same database runs well on 9 out of 10 PCs, but doesn't on the other one.� Invariably it's down to different versions of Windows or Access.
What specifically is the error that she sees that you dont?
Best regards
Jane

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

hi Jim,

perhaps her machine has less RAM? That's the biggest bang for the buck, imo.

Or maybe it's time to run malware software? Maybe some program(s) is stealing her machine's resources

To find out what version and build she has:

File, Account --> click 'About Access' command button on right. The top line of the dialog box will tell you -- and it can be copied. Mine is:

Microsoft� Access� for Microsoft 365 MSO (Version 2306 Build 16.0.16529.20100) 32-bit

best regards,
crystal

On 12/07/2023 4:27 pm, Jim Wagner wrote:

There is no errors other than it takes 10 times longer to run the same process. Right now it is a report that is taking forever for her. others can have this run in about 30 seconds. 120K records of historical data

Thank You

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Mark Burns <mburns_08109@comcast.net>
Sent: Wednesday, July 12, 2023 8:50 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>; Jane <jcross@crossproducts.plus.com>
Subject: Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

�

You can build code to check the version and Build # for Office365 for help in diagnosing/isolating office365 patch/versioning issues.

On 07/12/2023 11:07 AM EDT Jane <jcross@crossproducts.plus.com> wrote:

�

�

Hi Jim
It might be that she is running a different version to the rest of you -especially if using a 365 subscription. Sometimes it seems a significant portion of my working day is spent trying to figure out why the same database runs well on 9 out of 10 PCs, but doesn't on the other one.� Invariably it's down to different versions of Windows or Access.
What specifically is the error that she sees that you dont?
Best regards
Jane

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

There is no errors other than it takes 10 times longer to run the same process. Right now it is a report that is taking forever for her. others can have this run in about 30 seconds. 120K records of historical data

Thank You

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Mark Burns <mburns_08109@comcast.net>
Sent: Wednesday, July 12, 2023 8:50 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>; Jane <jcross@crossproducts.plus.com>
Subject: Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

 

You can build code to check the version and Build # for Office365 for help in diagnosing/isolating office365 patch/versioning issues.

On 07/12/2023 11:07 AM EDT Jane <jcross@crossproducts.plus.com> wrote:

 

 

Hi Jim
It might be that she is running a different version to the rest of you -especially if using a 365 subscription. Sometimes it seems a significant portion of my working day is spent trying to figure out why the same database runs well on 9 out of 10 PCs, but doesn't on the other one.  Invariably it's down to different versions of Windows or Access.
What specifically is the error that she sees that you dont?
Best regards
Jane

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

You can build code to check the version and Build # for Office365 for help in diagnosing/isolating office365 patch/versioning issues.

On 07/12/2023 11:07 AM EDT Jane <jcross@crossproducts.plus.com> wrote:

 

 

Hi Jim
It might be that she is running a different version to the rest of you -especially if using a 365 subscription. Sometimes it seems a significant portion of my working day is spent trying to figure out why the same database runs well on 9 out of 10 PCs, but doesn't on the other one.  Invariably it's down to different versions of Windows or Access.
What specifically is the error that she sees that you dont?
Best regards
Jane

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

Hi Jim
It might be that she is running a different version to the rest of you -especially if using a 365 subscription. Sometimes it seems a significant portion of my working day is spent trying to figure out why the same database runs well on 9 out of 10 PCs, but doesn't on the other one.  Invariably it's down to different versions of Windows or Access.
What specifically is the error that she sees that you dont?
Best regards
Jane

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116405) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

I was going to quip: sounds like her PC badly needs to be re-imaged (i.e. the OS and all applications re-installed from scratch).

 

On 07/11/2023 6:17 PM EDT David Nealey <dnealey@wordsmartbiz.com> wrote:

 

 

Why not just buy her a new PC?  Then prevent her from installing any software on it.

 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner via groups.io <josephwagner2=outlook.com@groups.io>
Sent: Tuesday, July 11, 2023 4:07 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Microsoft Access Questionable performance issues

 

Hello all,

I have been working here for 17 years and I have finally reached the point of frustration for a performance problem that baffles everyone here.
There is a user that I believe is cursed with computer fails. She will come to us and show us an error in access and so we go back to our computer and open the database from the same network folder and it works great. No issues. Then we open the database on someone else's computer and the database opens great and works without incident. But when you go back to her desk, it causes the error. We tell her, we cannot fix something that is not broken. But now it has become a real issue. the same issue happens both when she works in the office and at home. IT blames her network at home but fail to hear that the same performance is happening in the building.
Is there any documented or undocumented Access bugs that could be causing her problems or is a gremlin or her curse? Any suggestions would be of benefit to me and to this user.

Thank You

Jim Wagner

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

Brand new computer. Just deployed. 

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of David Nealey <dnealey@wordsmartbiz.com>
Sent: Tuesday, July 11, 2023 3:17 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

 

Why not just buy her a new PC?  Then prevent her from installing any software on it.

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner via groups.io <josephwagner2=outlook.com@groups.io>
Sent: Tuesday, July 11, 2023 4:07 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Microsoft Access Questionable performance issues

 

Hello all,

I have been working here for 17 years and I have finally reached the point of frustration for a performance problem that baffles everyone here.
There is a user that I believe is cursed with computer fails. She will come to us and show us an error in access and so we go back to our computer and open the database from the same network folder and it works great. No issues. Then we open the database on someone else's computer and the database opens great and works without incident. But when you go back to her desk, it causes the error. We tell her, we cannot fix something that is not broken. But now it has become a real issue. the same issue happens both when she works in the office and at home. IT blames her network at home but fail to hear that the same performance is happening in the building.
Is there any documented or undocumented Access bugs that could be causing her problems or is a gremlin or her curse? Any suggestions would be of benefit to me and to this user.

Thank You

Jim Wagner

Re: [MSAccessProfessionals] Microsoft Access Questionable performance issues

Why not just buy her a new PC?  Then prevent her from installing any software on it.

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner via groups.io <josephwagner2=outlook.com@groups.io>
Sent: Tuesday, July 11, 2023 4:07 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Microsoft Access Questionable performance issues

 

Hello all,

I have been working here for 17 years and I have finally reached the point of frustration for a performance problem that baffles everyone here.
There is a user that I believe is cursed with computer fails. She will come to us and show us an error in access and so we go back to our computer and open the database from the same network folder and it works great. No issues. Then we open the database on someone else's computer and the database opens great and works without incident. But when you go back to her desk, it causes the error. We tell her, we cannot fix something that is not broken. But now it has become a real issue. the same issue happens both when she works in the office and at home. IT blames her network at home but fail to hear that the same performance is happening in the building.
Is there any documented or undocumented Access bugs that could be causing her problems or is a gremlin or her curse? Any suggestions would be of benefit to me and to this user.

Thank You

Jim Wagner

[MSAccessProfessionals] Microsoft Access Questionable performance issues

Hello all,

I have been working here for 17 years and I have finally reached the point of frustration for a performance problem that baffles everyone here.
There is a user that I believe is cursed with computer fails. She will come to us and show us an error in access and so we go back to our computer and open the database from the same network folder and it works great. No issues. Then we open the database on someone else's computer and the database opens great and works without incident. But when you go back to her desk, it causes the error. We tell her, we cannot fix something that is not broken. But now it has become a real issue. the same issue happens both when she works in the office and at home. IT blames her network at home but fail to hear that the same performance is happening in the building.
Is there any documented or undocumented Access bugs that could be causing her problems or is a gremlin or her curse? Any suggestions would be of benefit to me and to this user.

Thank You

Jim Wagner

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116401) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_