I have a local Access DB which I need to import data from a remote SQL
server once a day, is there any way of doing this automatically?
regards
Simon

In the application there is a Parent form that contains a sub-form showing a
summary of Child records.
When the user double-click the child record list it brings up an edit form
allowing the user to makes changes to the child record.

From a adp project connnected to a MSDE database, i have local setting in a
local mdb file.
The connection with ADO to the mdb is only read access.
The connexion  with DAO works fine but always give me a log windows and a

I have a stored procedure like a record source:
ALTER PROCEDURE [dbo].[SPVistaClientes]
AS
SELECT [Código de Cliente],

Using SQL2000 and Access 2000.
I'm still a bit confused about Error trapping. Below is the script for
creating a test table and stored procedure.
The parmReturn value is zero, whether the stored procedure has errors or

From the Access ADE menu system you have an option under the TOOLS, DATABASE
UTILITIES menu to Backup, Copy and Restore SQL Server Databases. I've run the
Backup and Restore options and find these will serve my needs. With research
I found the Docmd.TransferSQLDatabase and Docmd ...

in my Access application I have a form with a subform both linked by the
master/child properties.
In the subforms header I have a combobox that allows the user to display a
subset of records that matches with the value in the combobox plus the values

The customer has sql server 2000 with access 2000 client (adp).
From the client the operator start a delete followed by an insert into a sql
server table, about 150000 old records need to be deleted and then new
records are inserted. The delete and insert is done in a stored ...

I recently moved to ADP and SQL server.  In regular Access I frequently used
the command in VBA to creat a QueryDef.
Set qdf = CurrentDB.CreateQueryDef("Query Name", "Select * from table")
Is there any comparible command to create a view in VBA?

im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi go
to create new database option and click on trusted connection and when
i hit next it gives me a microsoft sql server login error:

When trying to import an excel file into my sql db via a adp file, I get a
Invalid table name error.  I have db owner perms on the db and I am selecting
an existing table from the drop down list in the import spreadsheet wizard.

Hi, I just had to deal with the issue described in KB275090.  None of the
listed workarounds were satisfactory so I created my own.  I feel this method
is preferable when you have the ability to add another trigger to the table.
Here is the code (add it to the bottom of "steps to ...

I'm using an ADP on two different sites, each with its own SQL 2000 backend.
The design of both SQL databases is the same. When I use Redgates SQL
Compare, I can see that some of the tables now have extended properties.
These properties are present in one database, and not the ...

1. I have a master stored procedure that runs a series of other SP's in
succeession.
2. At the end of each individual SP, I have a command that writes a record
to a table with the completed SP's name and elapsed time.

At the moment, each client has an Agreement. Off this agreement table are
around 20 other tables, each detailing a different section of the Agreement.
Now, I want to change the database so there is an Agreement per year. So
when the Agreement deadline is reached, the user can ...