I have the following stored procedure and i would like to know how I
would update a table with the results:
Create PROCEDURE Proc_UpdateBalance
AS

Hi there I'd wish to test my adp application (Access 2003, working allready
on LAN) to access the MS SQL Server 2000 throught the internet.
Questions:
1) If, for security reasons, I'd like to expose a different port on the

I am new in Access 2007 (and Office 2007 in general) and the environment
seems too strange for me.
I want to link to an SQL Server 2005 DB but I don't know how.
I opened the External Data tab -->Import -->more -->ODBC database, I followed

I have create a form with a chart that pulls data from an aggregated view.
The the values are grouped by day of week. For instance, 1,2,3,4,5,6,7 The
problem is that that I need it to only read as mon, tue,wed, thur, fri ,sat,
sun

I am hoping someone can help me with a query I have regarding a
database structure I am working on, and if there is any way to improve
what I have created. Basically, I need a solution that records pets,
treatments assigned to pets, and subsequent invoices for the

Access adp on SQL-server 2005. The adp run successfully 8 year but the
company (orders, database, specialy some tables) grows very fast and some
code runs to slow.
2 questions about this problem.

I am just testing this to see if it will work for my class

I have 2 linked list boxes on a form. One lists Departments, and the second
shows the corresponding Employees of the selected Department. In the Acccess
.mdb version, When a department is selected from the first list, the After
Update event runs VBA code that requeries the second ...

I have really a strange issue.
Same Query "select......"  runned via ADP goes in timeout, from profiler i
saw it took about 30000 ms, runned under Query Analyzer took 300 ms!
Any Idea, I have a serious performace issue.

I have these parameters:
R:\Backup\master.bak  - (Full backup master database)
C:\Program Files\Microsoft SQL Server\Dane\MSSQL\Data\master.mdf  -
destination file master database

I have an Acces 2007 project using SQL Server 2000 as a backend.
I I have 70 recuring inspections due throughout the year, with varying
frequencies. Frequencies are monthly, quarterly, semi-annualy, etc and each
one has a different day of the month they are due on. For quarterlys ...

    I need help in displaying two coloums in a combo box/list box in access
data page. However the list box insist can only show one coloum. How can I
get to display the two coloums in the list box or is there any other way?
Thanks so much.

I have a problem.
I exporta data from Sql Serv to Ms Access and the precision of the numbers
is not the same.
for example

I work on an MS Access project ( *.apd - file) that is linked with a
SQL-express server 2005 (local installed). On this server are 2 databases x
and y.
I linked some tables of database x to y and here's the problem: the linked