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 / Setup / Configuration / April 2006

Tip: Looking for answers? Try searching our database.

Access will not permit me to open reports on new computer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Simon Dowsett - 28 Apr 2006 07:52 GMT
An existing database has been in operation on desktops and network for some
time. When opening the database on a new laptop (via the network) it will not
permit me to open any of the reports or run any macro that references a
report. Tables, queries etc are all OK but only reports are a problem.

I assume it is a setting somewhere but cannot find what is wrong.

Please help!!!
Jerry Whittle - 28 Apr 2006 14:30 GMT
Is the laptop on a wireless connection to the network? If so, that could be
the problem as Access and wireless networks don't play well together.

It could also be something in the setup of Office on the laptop or even
security settings.
Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> An existing database has been in operation on desktops and network for some
> time. When opening the database on a new laptop (via the network) it will not
[quoted text clipped - 4 lines]
>
> Please help!!!
John Spencer - 28 Apr 2006 14:42 GMT
Do you have a default printer set on the laptop?  This problem is almost
always caused by not having a default printer set on the computer.  Access
uses the printer driver to format the report, if no printer is specified
Access can't/won't show any reports.

> An existing database has been in operation on desktops and network for
> some
[quoted text clipped - 6 lines]
>
> Please help!!!
Simon Dowsett - 29 Apr 2006 00:41 GMT
Thanks for that John. It appears that there was a glitch with the print
driver that was installed so I reinstalled it and all seems OK now.

Now that I have that working, I've encountered  another problem.

The database that I've written is a Quality Assurance DB for a major
construction project in Victoria, Australia. I have developed the database
over several projects and it typically has been situated on a LAN with the
Design Master on my personal drive with a Replica on the common network.

I now have to send one of my Site Engineers to the other end of the project
10 km away  where he wont have network access.

What I have done logged onto his laptop and copied the Design Master onto
the local C:\.

I then replicated the  database back onto the common LAN, the theory being
that he can work on the laptop locally then synchronise back to the LAN
regularly to ensure data is kept stored on the server.

The problem is that everything works when I log onto his laptop, but when he
logs onto his laptop, the Design Master only permits him to open as read only.

I figure that it's probably something to do with the security settings, but
apart from creating the replica I have't applied any specific security
settings to the database.

Any ideas on how I would troubleshoot.

Thanks in advance.

> Do you have a default printer set on the laptop?  This problem is almost
> always caused by not having a default printer set on the computer.  Access
[quoted text clipped - 11 lines]
> >
> > Please help!!!
John Spencer - 29 Apr 2006 14:01 GMT
Have you tried right-clicking on the file(s) and getting the security settings?
It may be at the file level that the OS has set security to Read-only for
persons other than the administrator or the file creator or owner.

Have you implemented Access security?  It doesn't sound like it.  So I am
guessing that the problem is at the OS level.

> Thanks for that John. It appears that there was a glitch with the print
> driver that was installed so I reinstalled it and all seems OK now.
[quoted text clipped - 42 lines]
> > >
> > > Please help!!!
 
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.