Thanks Duane, answers below.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 9:01 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Contacts DB with multiple users
Hi Liz,
So the key issue is "when someone is in, they get errors saying that there is already someone in and they don't have access to do anything". Correct. They cannot make changes to the data.
Does this only happen when attempting to do "add from outlook" functionality or are there issues updating other tables? - It's a simple db with the one table.
Does your code compile? Yes.
Are there any missing references? No.
Does the code work with an ACCDB format? Yes.
Have you attempted to step through your code to see which line creates the error? It's in the managed code, so I don't have access to that.
Regards,
Duane
________________________________
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, August 20, 2018 10:49 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: Contacts DB with multiple users
Thanks Duane,
I have a portal here that essentially copies the accde file out to the user's H: drive and runs the database from there. My standard is to have the split db's.
It's a non-essential piece of information, really.
The real deal is that Access with this Outlook doesn't work when I split the database. Whether I have it on a portal or not.
Sorry I confused the issue.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808[cid:8e1942ff-c863-4cbf-8649-97f91798b011]
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 20, 2018 8:47 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Contacts DB with multiple users
Hi Liz,
Can you explain "on our portal"? Access behaves well on networks and some other environments but is worthless in others. I would not expect Access to perform well (if at all) with the back-end on OneDrive or as a file in SharePoint.
There are some possible solutions that involve SQL server in the cloud etc but my knowledge of those is Null.
Regards,
Duane
________________________________
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, August 20, 2018 10:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Contacts DB with multiple users
Pros, I've inherited a contacts database which someone built from a template, so of course there is a lot of managed code.
I was instructed to put it out on our portal, so I split the front end from the back, and put the front end at the portal. The "add from outlook" functionality quit, so I rejoined it. The user base wants this to be multi-user, but when someone is in, they get errors saying that there is already someone in and they don't have access to do anything.
Does anyone have any experience and/or knowledge with this type of database?
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808[cid:5b053bb4-1cdb-4cef-b899-ed409477b765]
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
[http://upload.wikimedia.org/wikipedia/en/4/46/Rockwell_Collins_logo.png]<http://www.rockwellcollins.com/>
Rockwell Collins - Building trust every day<http://www.rockwellcollins.com/>
www.rockwellcollins.com<http://www.rockwellcollins.com>
At Rockwell Collins, our innovative solutions for aviation, defense, rail and critical infrastructure help us keep people safe, connected and informed. Through long-time industry leadership and an unwavering commitment to work with our customers to understand and achieve their goals, we strive to be the most trusted source of aviation and high ...
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Duane Hookom <duanehookom@hotmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Duane Hookom <duanehookom@hotmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar