I have 4 2002 .adp that I recently upgraded to 2003 and then made .ade to
deploy.  (Before I deployed 2002 .adp).  Well, now that my users have the
new application on their computers things that I haven't changed no longer
work for them but they used to before I deployed the 2003  ...

Hi Group,
Working with Access 2002 and SQL 2000,
For an ADODB Recordset's Source I use this syntax :
rst.Source = "SELECT GteeID, CurExpiryDte FROM " & _

Hallo NG,
ich habe Tabellen umbenannt und mehrere Rauten als Prefix genommen. (Sollte
quasi eine Vorstufe zum tats?chlichen L?schen sein).
Access 2000 lie? dies im Datenbankfenster zu. Jetzt komme ich aber nicht

I created an SP where I get the result on the screen when runned as a select
statement but when I tried to run it as a insert into nothing happen in the
SQL2000 database. Permission are granted to DBO on the costunit table and on
the SP.

Are there any articles about connecting a MDB or ADP front-end to a MSDE
database that is located on our ISP's server? When I try to Google the
subject, I get a bazillion hits but non really apply to WAN connections.
Any help or pointers would be appreciated

I have encountered a problem in Microsoft Access XP, when using bound
forms in ADP-s. The exception appears consistently, in the following
scenario:
1. Create a table with the following script:

so i have a problem with the way that 'allow edits' works for a form.
I am using Access Data Projects; and I am not sure how well this relates to
MDB-- I haven't had to use a MDB for almost 5 years now
1) when a form is in 'allowedits = false' why is it that i can't change an

Hi Group
I want to divide one column by another column and stored that value into
third column.
Example :

hi group!
i have a very strange behaviour of my adp-file. As I am developing day by
day I have to udpate the versions very often - so the users get the adp-file
copied to c:\ when they log on to windows.

After updating my VB 6.0 software to sp6 I'm now receiving an ADO error when
I try to design a sp using Access 2k.  The error is as follows: "ADO Error
Could not find stored procedure 'dt_getproctdef'."  Can anyone help? I'm not
able to find any info regarding this on the net.  ...

How can I use access function in SQL view or SP (like in access query)?
SF

Has anybody done something like create a message from adp onto the
Windows eventlog/SQL Server Logs or send email to the admin if some
operation goes wrong in the adp application?

I have a SP with three parameters coming from textbox of a form I would like
to execute the SP and export the result in a text file as an import source
for another software what is the best way ? I'm in an ADP
Thanks

Using ADP (an Access project), how would you connect to databases on 2
separate servers?
The only way I know of to do this is to configure a "Linked Server" in SQL
Server Enterprise Manager.

What different between form and page?
I know that I can write VBA code for the form, but how about the pages?
If I want to write some code for the page, which language I have to use?
Do I need install any languages?