As stated in my previous post I'm attempting to move from bound forms to
unbound forms.  As a result I need to determine when data on my form has
changed so that I can ask my user whether they want to save their changes.  
Now from what I understand, I'm supposed to add a hidden ...

We have a situation where remote PCs will download records, make changes,
and upload the records back to the SQL server.  Currently we are converting
the recordsets to xml streams and using a web page to accomplish this.
What are some other ways to do this?  The client side app ...

The Scenario
A University tracks many categories of people - student, lecturer, prospect, director, admin, and so on, as well as their address and contact information.
I would like to model the information as a Supertype and Subtype relationship. Everyone is a person (the supertype ...

Anyone know how to align cells using vb code. I use excel automation to dump
a query into excel and I'm now formating the spreadsheet to look more
professional but I can't seem to align left - any ideas?

I am creating a DTS in SQL server by importing from a tab sep file,
I realized that one field could contain multiple, comma separeted,
values: eg.
Field1    Field2    Field3 Date etc..

I've got an unbound form pulling data from a small table.  The table has the
following fields among others:
emp# <--primary key, indexed unique, not nullable, integer, does not
auto-increment

I have a database with approx 20 tables and each table has a unique
identifier (primary key). I was wondering if there is a function in SQL
Server that generates a unique ID for the entire database (e.g. a global
identity field) so that no one primary key is duplicated in the entire

I have made a qry but something is wrong
Decimal * decimal * money
0.5 * 1 *1 €
= .500000

I have a database that keeps track of employees.  It used to be in MS Access
but now I've recently upsized to SQL.  I'm in the process of moving from
bound forms to unbound forms.  In one of my forms I had a list box that
listed all of the employee names.  I had it set up to ...

How can I from a adp file using integrated security for the connection, get
the permissions for the current user?
Tom L.

I need to get one value from a table, join it with an other table and use it
in a qry.
example:
table one

My client would like to locate a SQL Server on an internet server, and have
clients connect with ADEs over the internet (with encryption).
Is this feasible in terms of performance?  Has anyone tried this?
Thanks!

Have Win XP and getting an error when I try to install the Jet 4 SP8 update.
Keeps telling me I have a later update version than that being installed so
it is not needed but my database (Access 2003) program keeps telling me I
need to upgrade. Get KB829558 message but can not ...

greetings from a database newbie...
my other office uses msaccess and i get daily updated msaccess 2k .mdb file.
i, however, have mssql backend and msaccess frontend.
i want to create a linkedserver within mssql to the msaccess .mdb file, but

Is there any way to display all Field names for a specific Access table?
Something like " SELECT Column_Names FROM MyTable"
Thanks in advance for any help.
Ron Dahl