Re: Linking an sqlce Database to an Access Project

Thanks for the info.

--
With best wishes


Nigel Vandyk


"JamesFielding" <JamesFielding@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3878C1B0-AD36-42ED-9998-975301A4697B@xxxxxxxxxxxxxxxx

Hi Nigel,

It's not really *linking*, but if you just want to Export your SQLCE
(2.0 or 3.0) data into an Access database, or view your SQLCE data
on your Desktop, then you can use SQLCE Database Viewer from here:
http://www.pocketpctoolkit.com

It's extremely straightforward, and you can do it all using the 30-day
evaluation edition. ;-)

Best regards,


James


"Nigel Vandyk" wrote:

I have tried to do this using the Link Table Wizard - Selecting :

New Source

Other/advanced

Microsoft SQL Server 2005 Mobile Edition OLE DB Provider

Setting the connection to a copy of the sqlce database (jobbookings.sdf)
on
my PC

I test the connection and it succeeds

I then am presented with a list of tables to link to

I then select a table I want to link to and it fails with:

'unspecified error'

Can anyone enlighten me what the error is likely to be and can I do
anything
about it?

I am able to link to the database via sqlserver 2005, but it would be
very
nice to use some of the features in Access to view and export data to the
database.



--
With best wishes


Nigel Vandyk





.

Relevant Pages

  • Re: SQLCE performance from .NET CF v2.0
    ... Please remember when bulk inserting is being executed against SQL CE, ... > local database functionality. ... > database technology and I am considering switching to SQLCE at the same ... > execute the prepared statement again. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: custom insert for databound datagridview
    ... gets put into the database until you hit the save button on the navigation ... CTP you can download that handles syncing with a mobile device, ... the desktop piece is SQL Server so you'd still need to write a custom sync ... I am syncing between a PDA SQLCE ...
    (microsoft.public.sqlserver.ce)
  • Re: custom insert for databound datagridview
    ... soon as syncing supports SQLCE without having to have SQL Server and IIS I ... install SQL Server and IIS just to sync. ... The method I have taken is that I will use RAPI to copy the mobile database ...
    (microsoft.public.sqlserver.ce)
  • Re: custom insert for databound datagridview
    ... Syncing is exactly what I am doing. ... I am syncing between a PDA SQLCE database ... The first field is a Guid. ...
    (microsoft.public.sqlserver.ce)
  • Re: custom insert for databound datagridview
    ... gets put into the database until you hit the save button on the navigation ... Is there a way to get at the actual point where SQL statements are being ... Since you're talking about DataGridView, I assume you want to track the ... and a desktop SQLCE database. ...
    (microsoft.public.sqlserver.ce)
Loading