Opening an old database to edit reports
Sat, 23 Aug 2008 09:22:01 -0700
I want to open an old database i created last year, but i changed the
settings to stop the user changing anything. How do i open it again so i can
edit some of the reports? I seem to remember its Ctrl and something..
--
Claire ...
|
Problem using Access in Active Directory
Fri, 22 Aug 2008 14:47:02 -0700
Has anyone else had issues with Access when you logoff local user and login
to Active Directory?
System info:
Front end: Windows XP, Service Pack 2
Back end: SQL Server 2003
Access 2007
Event: I have been running quite successfully an application built with VBA
and macros. I have had no problem runn ...
|
Permanently hide table
Fri, 22 Aug 2008 16:19:46 -0500
Hello,
I am creating a standalone Access application. I save the application as
.mde. How can I hide the table so that people will not see them. I want to
permanently hide them. Is there a way to lock, or encrypt the table? To be
clearer, I want users just click on the form and have no access to tables.
...
|
>> SQL admin member
Thu, 21 Aug 2008 16:04:00 -0700
Hi, using Access 2003 how can I check whether a user is a member of the
back-end sql database admin group?
Many thanks,
Jonathan ...
|
BackEnd Database Locking when FrontEnd runs a query - why?
Thu, 21 Aug 2008 15:29:02 -0700
The simple question is,
Why does a select query using the IN command lock the target database?
I am trying to write a reporting app where the users have a fairly skinny
frontend on their local machine. The frontend has tables that are linked to
a backend database that drive the application.
In the bac ...
|
1 user gets when "admin" in use - but no login/password prompt
Wed, 20 Aug 2008 16:10:08 -0700
I have a user that when we click on the shortcut to the secured database they
get don't get the login / password prompt box... Instead a message saying
Cannot login when "Admin" in use... when you click "OK" reverts to ACCESS...
However, all the other users of this database do not have this issue... The
Logi ...
|
Unreadable Lock File
Wed, 20 Aug 2008 21:53:19 GMT
I have a back end and copied -to -desktop frontends for 6 departments at work.
There are 6 backends (one for each department). There are 6 master frontends
in a file. Employees copy the frontend to their desktop for their group. The
frontend is linked to the correct backend. There are over 190 employees and
beca ...
|
|
|
I cannot open an Access 2003 database in Access 2007
Tue, 19 Aug 2008 19:10:00 -0700
I have an Access 2003 database that was originally created in Access 97 using
a custom Workgroup with permissions.
When I try to open this database in Access 2007 I get a message saying: "You
do not have the necessary permissions to use this file. Have your
admistrator create the permissions for you.
I ...
|
Q: "Permissions to install" error when not running Access as
Administrator
Tue, 19 Aug 2008 11:35:34 -0700 (PDT)
Greetings.
I have the Microsoft Office Access 2007 runtime installed on a Windows
2003 Server platform to run a vendor's application.
When I run the application as Administrator, everything runs as it
should.
When I run the application as a regular user (non-administrator, Power
User), I get the followin ...
|
Delete Table with "Engine" owner
Tue, 19 Aug 2008 10:02:01 -0700
In Access 2003 I am having a problem deleting a table who's current owner is
"Engine". The table was created in code using the sort routine listed below.
When I try to use Security to change the user from "Engine" to "Admin", when
I am logged on as the Admin I get a message: "You don't have permission to
ch ...
|
