Here is a piece of code that works when I run it against a table that is
linked from another MDB, but when I run it against a table on SQL Server
(linked with ODBC) it does not. And I'm wondering why, and is there away to
get it to work?

I developed a system in VB with Sql Server 2000
using ADO, everything this is really very satisfied with the acting of the
sql server, does mine doubt the following it is, because I see many comments
on the subject... do I possess a global variable in I modulate has the

I need to know if you can modify a table once you import using a ODBC?

Invitation HSF5
We invite everybody haker and programmer who actually are those and wish  to
enter the organization HSF5. You should do the following:in order that we
could become sure of your opportunities and purposes, you must purchase F1

I need to delete records from my database, I have 3 tables
Table 1 has:
Users
1> UserId

After sending an Alter Table commnd (e.g. MyProject.Connection.Exec "Alter Table ... Drop Column ..") the table doesn't change unless I shutdown and re-open the project.
How can I refresh it?

I have access 2000 9.0.6926 sp-3
I just installed the latest MSDE. I know its working because other
applications can use it.
I can create a new project with an EXISTING database on the server,

I have a client that would like to be able to see a history of all changes
made to a given record over time and who made them.  Is the transaction log
of any use for this? Do I need to craft something custom or is there a third
party app that does this?  My initial searches have ...

I have an Access/SQL Server application that uses the short date format for
displaying dates. In Windows XP the default is M/d/yyyy which I change to
M/d/yy, the definition I need to use. I've noticed that with users that have
had Access 2003 installed on their computers that the ...

I am planning on changing platform from mdb to SQL. The main table in the
applicastion has 61 fields, and I wonder if this is too much. Should I split
it in several tables and use a view or stored procedure on the form where
data are added and updated?

Hi group!
We are currently trying to port an access 97 application to access 2002 with
sql server (ADP-Project). I am now qustioning myself whether there is a
possibility to access an sql server with the dao statement:

Is it possible to access more than Database (same server) from a
single ADP?  We have an Access database using linked tables right now.
I would like to enhance its speed by converting it to an ADP.
Thank you!

I am using SQL SERVER 2000 and Access 2000. We have a set of tables in SQL
SERVER that are linked into our ACCESS Database(NOT AN ADP). We have ONE
table that will not allow updates in Access (SQL SERVER is fine) ? IT always
gives the error -

I am trying to append records from one table to another in a db running on
MSDE, knowing fullwell that some of the data in the source will be
duplicates of that in the destination table's pk.
What I would like to happen is to have the stored procedure plunk-in all

I have code which creates a recordset.  I want to pass this recordset to
another subroutine.
What is the code to pass a recordset as a function parameter?
Cannot find an example anywhere.