in mdb, i can simplify expressions in queries using the the following:
a:field1*field2/24
b:field3/field4
c:a+b

SELECT [App Info].[First Name], [App Info].MA, [App Info].[Last Name], [Class
Info].Date
FROM ([App Info] INNER JOIN [Class Info] ON [App Info].[Soc Sec #] = [Class
Info].[Soc Sec])

I try to create a query view in Entrerprise Manager and I get an error about
sp_addextendedproperty. What could be reason for the error ?
The full error
ODBC eror. Microsoft ODBC sql server driver sql server

I hava an access ADP, now I woul like to access the back end in SQL server
2000 in my computer from a remote computer by internet to make testings. How
can I do? I would like to access by IP, is it possible?
Thanks

Sorry for posting in three newsgroups, but all seem appropriate and the
topic seems to have sparse coverage in general.
Using Access 2003 linked tables to SQL Server 2000 via ODBC. What's the
simplest way to implement explicit control over record locking? Even

We have a product which has an Access 2000 front-end and a SQL Server backend
database. We are having a problem with locking in the Access front end
database as follows: if a user has the details of a record open and another
user is trying to create a new related record, if the ...

In a Project connected to (local) Anonymous Merge Subscription, cannot Add a
New Record programmatically. Works fine from Table View and Standalone Form
created with Wizard. CommandButton Event Procedure is a Cut-and-Paste Code
that works several other places in the ADP. In this ...

I have an ADP (acc2003 vs SQL server 2000).
When I open the ADP, nobody can see the tables, views, sp and functions. F11
is not enabling.
But from enterprise manager, we can see all tables, views, sp and functions.

I would like to run a stored proc from my ADP project in my SQL server.
I want to use the DoCmd.OpenStoredProcedure in order to get the result
displayed automatically in Access. The fact is I have to 2 arguments to
pass to the sp. Is there a way to create a on the fly a sp like ...

In MDBi use IIF function. How can I use this function in ADP ( view or sp)?
There is a similiar function?
Thnks
José

I'm using an adp project connecting to sql server. When I click on the
Office Links button of the report section in order to publish my access
report with microsoft word, getting below the error message.
"Microsoft Office Access could not find the database on the server. Verify

I'm trying to implement something I've done many times in Access - but
this time in a .ADP connected to SQL Server.
What I'm trying to do is requery a form and then put the form "on" the
record it was previously on.  This should be easy

I am trying to delete some SQL db data using the following VBA code:
<connection string....>
strSQL = "DELETE * tblEmployeeVProject WHERE fldEmployeeVProject_ID=" &
Me.fldEmployeeVProject_ID_old