hsal...@gmail.com wrote:
We need update function and stores procedures in a remote server. Also
we have access to the remote database.
I think that you cannot update function and stored procedures in a
remote server in the Access 97 UI. Of course, you can alter procedures
etc from any com compliant application by referencing ADO, or late
binding to ADO and using SQL. TTBOMK one should be able to establish an
ODBC connection from Access 97 and then run pass-through queries to
accomplish the same end.
A free alternative for your client to update function and stored
procedures in a remote MS-SQL Server is to download SQL Server
Management Studio Express.
http://go.microsoft.com/fwlink/?LinkId=65110
TTBOMK this utility is backwards compatible with previous versions of
MS-SQL. The interface is friendlier than Access's interface (for this
work of altering procedures etc.) and so I use it rather than any
version of Access for this purpose. In addtion it will generate Change
Scripts eg.
ALTER TABLE dbo.Tasks
ADD Whatever nchar(10) NULL
which can be used in the manner described in my first paragraph.