SQL Server to Jet (Access) database

InertiaM

Well-known member
Joined
Nov 3, 2007
Messages
663
Location
Kent, UK
Programming Experience
10+
I need to create a standalone database using data from a SQL Server. I've tried :-

VB.NET:
        sSQL &= " INSERT INTO OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\blank.mdb; Jet OLEDB:Database Password=blank;')...tblTest"
        sSQL &= " SELECT ........" etc

but it's looking for the Jet database on the server, not on my local PC. Does anyone have any ideas :confused:
 
I need to create a standalone database using data from a SQL Server. I've tried :-

VB.NET:
        sSQL &= " INSERT INTO OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\blank.mdb; Jet OLEDB:Database Password=blank;')...tblTest"
        sSQL &= " SELECT ........" etc

but it's looking for the Jet database on the server, not on my local PC. Does anyone have any ideas :confused:

Well.. duh.. of course it's looking for it on the server! You just told the server that that path to the access db is c:\blank.mdb

:D

either copy the db to the server, or tell it to use a UNC path to your shared database
 
It's funny how you go back and read some of your own posts sometimes and think "did I REALLY post that?" :eek:

All sorted anyway - Jet ditched, SQLCE created, indexes added, deployed to PocketPC, working a treat :D
 

Latest posts

Back
Top