Selasa, 04 Oktober 2011

Re: [MS_AccessPros] Re: ACCDB multiple users

 

Troy,

Years ago I used Crystal to run certain reports and the database always had to be closed for the report to run. I think Bill is correct in the fact that data needs to be locked before crystal will work.

 
Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, October 4, 2011 10:50 AM
Subject: [MS_AccessPros] Re: ACCDB multiple users

 
Troy -

It sounds like Crystal is set to open the database exclusively. Normally, Access opens all DB files in Shared mode although you can explicitly open them exclusively. But outside software can open databases exclusively (perhaps to keep data from changing as a report is loading).

There must be a setting that you can change to Shared from within Crystal, but I'm not familiar with Crystal so I can't tell you where to look. Either that, or Crystal is not releasing the connection once the report is generated.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "Troy Sherven" <tsherven@...> wrote:
>
> I created a new DB in Access 2010. It's a ACCDB format. What do I need
> to do to the file to allow multiple users to have access to it at the
> same time? I have a few automated Crystal reports that need to access
> the DB. If it's open, the reports do not run.
>
>
>
> Thanks,
>
>
>
> Troy Sherven
>
> MCD, Inc.
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar