I am using SQL Server 2000, with an MS Access 2000 front
end.  I want an event to be called when a button is
clicked from a form.  I want this event to call a stored
procedure, pass it a parameter (from another field on the

I am currently using Access 97, I have several custom programs. The largest table I have has 50,000 records.  The company is not very large less then 30 people.  I am ready to upgrade to the lastest Access program.  Should I consider a SQL server?  Does anyone have a comparison ...

I work for an organisation that uses a bespoke document imaging system, the
database of which is an MS sql server.
We have MS Access and already use it for some querying of the database.
The database comprises a large number of distinct cases, which are

Anyone got a hint where i can find info about what is needed on the client
in order to use olap on my SQL srv?.
Here i am only looking for client side.
Ive been searching google and technet - but there isnt much about the client

Hi....
Hopefully I will be explain this well enough to interpret....
I have an .adp that interacts with an SQL backend.
When a new order is created, I need to allow the user to save the order....

I have a SQL 2000 backend, with an Access 2000 Project
frontend, and the frontend file is saved on each person's
private drive.  (3) users are assigned dbo rights.  (1)
user has successfully created views using the Access 2000

I see the format function is not supported with SQL . Is
there a equivilant I can use.
e.g.
[integer datatype]

I'm trying to put together the SQL to recieve subtotals
per employee AND that subtotal divided into subtotals per
product. The problem could be applied to Northwind
(Employees, Orders, Order Details).

does anyone knows how to use the date add function ?
I have a reg_date field in a table containing a date
I have another field name Reg_renw_Date that equals to reg_Date + 12 months.
how do I calculate it ?

  Sorry about the miss post, but I am still confused.  
How do I use the date value from the calendar control and
get it into a criteria for a query? any examples of this?
Mike

Hi, I'm testing locking in MS Access XP with ADO 2.7. My testing code is
below :
  Set cnn = CurrentProject.Connection
  rst.Open "select * from MTR1 where MTR1_CD = 'A' ", cnn, adOpenKeyset,

The problem I'm having is actually documented as a bug in all versions of
ADO through and including 2.7, but it seems to be true in 2.8, too, so I
assume the article simply hasn't been updated.
I need to execute a long-running stored procedure that uses RAISEERROR to

If I use ADO with OLE DB Provider for Microsoft Jet 4.0. My code use only
basic function (ADO library only, no ADOX,ADO MD, JRO) . In the future if I
change from Jet to SQL Server 2000, Will I have to modify my code a lot ?
(Suppose my code not use stored-procedure.)

how can I define auto number datatype ?
thanks
Ran

I"m using a SQL SELECT statement as the recordsource for a report.  As long
as I do not include an ORDER BY clause the SQL string works fine but as soon
as I add ORDER BY I receive the following error:
"There was a problem accessing a property or method of the OLE object."