Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / February 2005

Tip: Looking for answers? Try searching our database.

ADP Error supression

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Drew - 15 Feb 2005 14:18 GMT
I have an ADP app that is used only for reporting.  The users don't change
or create new reports, they just run the ones that are there.  The problem
is that if 2 users have the ADP app open, I get the error,

"The MS Access project 'Name' will be opened read-only because on of the
following occurred."

Is there anyway that I can supress this error, so as not to confuse the
users?

Thanks,
Drew Laing
Norman Yuan - 15 Feb 2005 14:48 GMT
You placed the ADP file in a shared location, didn't you? Try to place ADP
on each user's computer.

> I have an ADP app that is used only for reporting.  The users don't change
> or create new reports, they just run the ones that are there.  The problem
[quoted text clipped - 8 lines]
> Thanks,
> Drew Laing
Drew - 15 Feb 2005 15:14 GMT
I have seen that in my searches, but then if I make a change to a report, I
will have to redistribute this app to all users, this sounds like more work
than it is worth, that is why we have it on a share on the server.  I mean
it isn't that big of a deal, I just don't want the users getting confused
when it says "Warning!"...

Thanks,
Drew Laing

> You placed the ADP file in a shared location, didn't you? Try to place ADP
> on each user's computer.
[quoted text clipped - 13 lines]
>> Thanks,
>> Drew Laing
J. Clay - 15 Feb 2005 15:47 GMT
It actually is not a big deal at all.  Just set up a logon script in your
domain, and include a command that copies the master copy from a server
share into a directory on the client computer.  This way, any change you
make and publish out the the server will automatically be updated the next
time any user logs on.

Jim

> I have seen that in my searches, but then if I make a change to a report, I
> will have to redistribute this app to all users, this sounds like more work
[quoted text clipped - 22 lines]
> >> Thanks,
> >> Drew Laing
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.