Openrowset Jet OLEDB

From: Ulf (u.bruegelmann_at_omnicom.de)
Date: 04/30/03 

Date: Wed, 30 Apr 2003 08:03:22 -0700

Hi there,

we're having trouble using OpenDataSource with Jet OLEDB
to access a mdb.

The layout is as follows:
We're running SQL Server 2000 SP3 on a Windows 2000 SP3
machine.
The SQL Server service runs on a domain admin account (not
a good idea, I know). Users are loging in via Windows
Authentication.

The task was to import a mdb into Sql Server. We tried
with OpenDataSource but failed with an errormessage
complaining about access rights to the mdb.

After some inquiring we found that sp_addlinkserver works
but in the setup described above it only does if the mdb
is on the same machine as the Sql Server and of course the
user must have system administration rights in the sql
server to be allowed sp_addlinkserver....

As both conditions give us major headaches:
Wich user context is actually used when issuing an
opendatasource from within the frontend app?

Is there any other way to speedily import an mdb into the
server via the frontend app?

Thanks in advance

Ulf

Relevant Pages

  • Re: From .mdb to .adp database
    ... I decided to go on with adp project, and i have created a store ... But queries are different stories. ... In SQL Server, there are Views, Stored Procedures, UDFs. ... Also, when you decide to use MDB front-end, you can choose use MDB ...
    (microsoft.public.access.adp.sqlserver)
  • Re: From .mdb to .adp database
    ... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: From .mdb to .adp database
    ... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Upsizing design considerations
    ... reports, with a ADP, or mdb (actually, it should be mde, or a ADE when you ... you would LINK the tables to sql server, and NOT USE a adp (the reasons is ... the first two remote users ...
    (microsoft.public.access.gettingstarted)
  • Re: Front End options
    ... SQL Server if you follow my recommendations in. ... you could easily support hundreds of concurrent users. ... Does a mdb FE work well regardless of how many tables ... >>subforms well. ...
    (microsoft.public.sqlserver.clients)