These are just fairly general queries - I'm looking for some advice to get
off and running in the right direction.
1. I'm migrating Access 97 databases in to SQL Server - using the DTS Import
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
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
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
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