I'm in the middle of migrating an mdb file to adp and have migrated the
tables over to SQL Server 2000
A curious thing is happening for which I have no explanation.
On my main form, I have a button that the user clicks to start a new

windows 2003 server'a sql server kuruluyor fakat sql server sp3
kurulam?yordu. bununla ilgili bir geli?me oldumu daha sonra? t?k.

Hi to all,
Here's the scenario:
I have a Access 2003 .adp with MS SQL Server 2000 backend. There are stored
procedures on the backend that is runned from buttons on a form. But there's

I have an MS Access Data Project connected to my SQL Server database.
While in Access (Table View) I deleted a column that I no longer
needed.  No problems/no errors.
Now if I double-click that table to view the data I get the following

All,
I have an .adp project in A2003 on sql 2000.
When creating a new tabel/view with the user interface of access it's
possible to "connect" a row with a lookup table (via properties pane of the

I've developed a SQL Server database (2000) and an user
interface in Access (2003) that was saved in Access 2000
format because some users still have Access 2000 on their
computer.

I am using MSACCESS to read/write on SQL SVR.
Is there a way to log the actions performed on MSACCESS . ( DELETE, insert,
...) to trace what has been done on the SQL SVR using MSACCESs.
Thanks

I support an application which uses DLookup extensively in ADP code modules.
In the code, a DLookup statement executes, and then a stored procedure
executes a few lines later.
In the profile trace, I found to my surprise that frequently the stored

I am receiving the following error:
Syntax error in query expression
reports_in_progress_current_xl[GLOBALDCCDATA].[GLOBAL_DCC_CODE]
when I am executing the following code:

how does one get to msdos from desktop in windows xp?

I have a .adp connected to SQL. The visibility of some of the fields should
be dependant on the data from other fields.
So, I want to run a function like the following every time the user changes
anything:

I have an .adp connected to a SQL database. I've made a form with a TextBox
connected to a varchar(1024) in the SQL database. I am trying to use VB to
update this text box with the concatenation of text from other fields.
The SQL field, the Text box, and the strings from VB can ...

I was under the impression that the Client Connectivity install was required
for every machine on a LAN network that wanted to connect via OLEDB to an
sql server database.  However, I recently created an adp project in MS
Access that seemed to connect without any problems, even ...

I am working on a Access to ADP SQL server conversion project.On one of
the forms I need to add a record which gets stored in a temporary
table. But even after i delete the record from the temporary table the
Me.refresh function does refresh the form. And it still has the deleted

Hello group.
Within my ADP, the CurrentDb function returns null allthough I'm connected
to a SqlServer 2k. How do I get the tabledefs and get/set the connection
string?