July 24, 2008 12:05am pdt

1. strung 5,000
2. slyong 2,000
3. kdearing 1,200
4. ParadiseITS 1,000
5. Darr247 800

1. weed 39,880
2. eoinosul... 10,000
3. strung 8,800
4. TheHub 6,800
5. in-effect 4,000
6. slyong 3,500
7. caeisenb 2,450
8. rickyr 2,420
9. paulvane... 2,070
10. leew 2,000
10. walsellers 2,000
10. Lieven_E... 2,000
10. sgstuart 2,000
10. NicPapag... 2,000
10. pheidius 2,000
10. kcostas 2,000
10. jonbergh 2,000
10. rakeshmi... 2,000
10. techboycorp 2,000
10. lesouef 2,000

04.05.2007 at 08:14AM PDT, ID: 22494450

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.6

Microsoft Access sharing issue

Zones: AppleShare IP, Microsoft Access Database, Computer Servers

Tags: access, sharing, microsoft

I am running a Microsoft Access 2002 database, on a PC, across a Mac OS X network. Everything was working well until we upgraded the server software this weekend. I can access data on the network drive until another user opens the database. When she is in the database, I get a "can't find the database" message. When she closes I can once again access. Any ideas?

Start your free trial to view this solution

Question Stats

Zone: Apple

Question Asked By: jlnero

Solution Provided By: strung

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
Automotive
New Net Users
New Users

Software
Digital Music
Gaming World
Home Security

Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Displays / Monitors
Handhelds / PDAs
Components
Peripherals
Laptops/Notebooks

Servers
Misc
Apple
Embedded Hardware
Networking Hardware

Storage
Desktops
New Users

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMware
Misc
Web Development

OS
CYGWIN
Voice Recognition
Virtualization
Message Queue
Quality Assurance
Security
Firewalls

MultiMedia Applications
Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals
Devices

Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
Web Computing
WebApplications
IDS
Vulnerabilities
Email Clients
File Sharing

Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Consulting
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMware

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel
Automation

Algorithms
Game
Signal Processing
Project Management
Open Source
Database

Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Web Services

Images
Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration

WebApplications
Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Web Computing

Broadband
Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Lounge
Business Travel
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles
Automotive

Community Support

Suggestions
New to EE
New Topics
CleanUp

Announcements
General
Feedback

Input
EE Bugs

04.05.2007 at 08:48AM PDT, ID: 18858718

Rank: Genius

DatabaseMX:

Sure points to a folder permissions issue ... which the exact same scenario came up with a colleague yesterday ... same message. And it was a permissions issue. That error message is a manifestation of the issue.

mx

Assisted Solution

04.05.2007 at 10:39AM PDT, ID: 18859616

jlnero:

Thanks for the reply. We had changed the permissions to full read - write at the server level. Before doing that, I wasn't able to open the database at all, whether the other user was in it or not. Changing that enabled me to access it, but we still could not share. Are there any other settings I am missing?

04.05.2007 at 06:35PM PDT, ID: 18862046

LimeSMJ:

What are the details of the "server software" upgrade? Are you using FE/BE database or monolithic?

Assisted Solution

04.06.2007 at 07:18AM PDT, ID: 18863988

jlnero:

I'll have to find out -- it may take a while -- thanks

04.09.2007 at 06:12AM PDT, ID: 18875507

jlnero:

We upgraded MAC OSX server from 10.2.8 to version 10.4.7. The database is monolithic, which probably is what contributed to the problem. The user that seems to be locking it created a new query just before the server was upgraded. Is it possible that somehow the locking related to that caused the problem? Once this gets resolved, I will figure how to separtate FE and BE, or is that something I should do first?

04.09.2007 at 08:33AM PDT, ID: 18876301

Rank: Genius

DatabaseMX:

"Once this gets resolved, I will figure how to separtate FE and BE, or is that something I should do first?"

fwiw ... The first place I start with a new database design is creating a relational model - aka BE. After that is nailed down, then I start on the user interface (FE). So inherently, I have it split from the git go. I've been doing that since the inception of Access circa 14 years ago.

"Is it possible that somehow the locking related to that caused the problem?:"

Possible yes ... if ... for some reason the mdb was being opened 'exclusively' either because of a property setting and/or manually opening it in exclusive mode. However, you have the added complexity of the MAC stuff, which I am not familiar with.

mx

04.09.2007 at 10:03AM PDT, ID: 18876965

jlnero:

Using phrases from both experts above, I searched further on EE to find a post about a bug in Access 200o, which suggested bypassing desktop shortcuts as a solution to the problem that I was having. Eventhough we are running Acess 2002, I tried opening the files from "File - Open" menu and sure enough it works for both me and netwoworked users, where shortcuts still don't work. Does this shed any light on why the problem occurred all of a sudden?

04.09.2007 at 10:18AM PDT, ID: 18877080

Rank: Genius

DatabaseMX:

I'm contracting at a large company right now ... with a large WAN. All users have desktop shortcuts - pointing to the full network path on the server ... with no problems. So, don't really know why you would have that problem all of a sudden?

mx

04.09.2007 at 05:17PM PDT, ID: 18879562

LimeSMJ:

What is the full command inside the shortcut?

04.10.2007 at 05:27AM PDT, ID: 18881723

jlnero:

The command for the shortcut that wouldn't share after the upgrade is as follows:
"W:\IPS\Results M.mdb"

The following shortcut works fine:
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "W:\IPS\Results M.mdb"

Is it possible that settings on the upgraded server software no longer allows the more direct path for databases?

04.10.2007 at 06:41AM PDT, ID: 18882217

strung:

Several thoughts:

1. Check the shortcut to see what is in the "start in" box.

2. Double check to make sure you don't have more than one copy of MSACCESS.EXE on your hard drive. The shortcup may be opening the wrong copy.

3. Try deleting the shortcut and create a new one.

The best answer, though is to split the database. This is easilby done.

Make a new blank database called Results_M_Data.mdb on the W: drive. Go to Files:Get External Data and import all the tables (and ONLY tables) from your existing database. If you have relationships set up on the old database, you will want to recreate these on the new database. This is now your new back end.

To create your new front end, copy your Results M.mdb from your W: drive to your C: drive. Rename it to NewResults_M.mdb. Delete all the tables in NewResults_M.mdb.

Open C:\NewResult_M.mdb. Go to Files:Get External Data:Link Tables and link to all the tables in the Results_M_Data.mdb database on the W: drive. Go into Tools:Options:Advanced on the NewResults_M.mdb on your C: drive and set "Default Open Mode" to "Shared" and "Default Record Locking" to "Edited Record". Check the box for "Open Database Using Record Level Locking".

Delete your old shortcut and point your new shortcut to C:\NewResults_M.mdb.

Rename your old W:\IPS\Results M.mdb file to W:\IPS\Results M.md_ so that no one will accidentally use it anymore. Keep it as a backup until you are satisfied the new version is working properly.

Copy the C:\NewResults_M.mdb database to the C: drive of all computer that will need to use it. In each case, open it on that computer and check the settings in Tools:Option:Advanced, as these settings do not necessarily travel with the database when it is moved and will have to be reset. Make new shortcuts on each client machine to C:\NewResults_M.mdb.

Copy

Accepted Solution

04.10.2007 at 06:42AM PDT, ID: 18882223

strung:

Ignore that last "copy" in a separate paragraph in my last post. It was simply a slip of the trackpad.

04.10.2007 at 06:51AM PDT, ID: 18882294

jlnero:

Thanks everyone.. I am back on track and wiser now.

20080716-EE-VQP-33