Access to Stored Procedures, views and tables

  • Thread starter Thread starter SFAxess
  • Start date Start date
S

SFAxess

Have you checked that you have the proper permissions on
the SQL Server to edit the sprocs, views and tables?
Talk to your DBA or check to ensure you and other users
are in a role that allows editing.
Also, Access Projects can only be opened by one person at
a time, therefore make sure that you are opening an
exclusive copy of the application.
 
Right - deploy a ADP or ADE file to each user and I would recommend copying
it to their local drive for better performance. Devise some way to copy new
versions of the project to their drive for when you are ready to release a
new version. For simplicity, I usually utilize the logon script to copy the
file on reboot.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access
 
Back
Top