Very Computer

These are just fairly general queries - I'm looking for some advice to get
me
off and running in the right direction.

1. I'm migrating Access 97 databases in to SQL Server - using the DTS Import
Wizard,
should the Destination be Microsoft ODBC Driver for SQL Server, or Microsoft
OLE DB Provider
for SQL Server ?

2. When importing comma delimited text files into the SQL Server tables,
date fields import
fine is they actually contain dates, when they  do not, then my import falls
over

ie    "text data", 2, 3, 11/06/99, "text data"      is ok,
but   "text data", 2, 3,  , "text data"             will not import

3. Finally, I think this may be the biggest problem. I have an Access 97
front end database.
I can attach the SQL Server tables into it - I've set up a SQL SERVER
connection string via
ODBC Data Sources in Control Panel - and I can see the data via the Access
97 front end.
My problem is that when someone else on a different PC tries to access it,
they can open the
Access database but cannot open the table - I'm not sure how to give them
access, although
I can access myself.  This is an area where I do not feel confident - should
I be using
NT security or SQL Server security, and how do other PC's reading the Access
database
 manage to read the tables too, which is the problem I'm having ?

If anyone could come up with some advice I would be extremely grateful.
Could you please email
at :

many thanks

Jim Partridge

As far as exporting goes your source is MS-Access your target is the
default SQL Server import/export provides. Make sure you create a
database first and then point to it when you are exporting.

To set up an ODBC connection just select add then select SQL from the
list usually the last. Then provide the name, server and somewhere in
there you can select the database...can't recall off the top of my
head where though, but this step is important or you will get the
master database.

There may be a better way to give all users access to the QDBC data
source, but this is my way for now. Create an ODBC entry with a unique
name. Test it to make sure it works. Run regedit. search for the name,
you should find it twice, export these keys and then either send them
to your intended recipients or find a way to run these during the
installation process.

Good Luck Fellow Newbie ;o)

John Casey
Applications Support Specialist
Working Ventures Canadian Fund Inc.

On Fri, 11 Jun 1999 11:29:45 +0100, "Jim Partridge"