initial set up probs with Access 97

initial set up probs with Access 97

Post by Jim Partridg » Sat, 12 Jun 1999 04:00:00



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

 
 
 

initial set up probs with Access 97

Post by John Cas » Wed, 16 Jun 1999 04:00:00


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"


>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


 
 
 

1. MS-Access 97 to SQL Server to MS-Access 97

Hi this is a thread from another news group that has not been
answered. Any ideas anyone?

Thank You, Thank You...you hit it right on the money. It seems SQL
import/export converted all my MS-Access memo fields to the SQL ntext
data type. Does SQL Server have a comparable memo field type? If not
how do people get around the memo field requirement? Create text field
large enough for the average requirement?

Thanks Again

On Thu, 17 Jun 1999 16:40:30 +0400, Alexey Dolganov

2. Oracle software

3. Refreshing @SAY objects in a screen

4. Initial Installation probs, HELP!

5. Bug: Installing SP1

6. How to set FIPS_FLAGGER option in Access 97/SQL Server 7.0 with ODBC

7. How to replicate with a large Access database.

8. How to set the decimal places in MS Access 97 using VB

9. How do i set up a multi Tier Database using Access 97 or VB 5.0

10. Setting Access DB file to finished prog during setup or initial run

11. Setting password on MS Access 97 from VB 6.0 DAO

12. How to set decimal places in Access 97 using VB6