Recommended db app strategy

[John]

Hi

I have an access backend database to which I need to give a vb.net front
end. I created db connection and data source in vs 2008., I then dragged the
fields onto a form which created the app for me. The app works ok but my
question is; is this the correct/acceptable way to cerate an app or should I
be using another technique?

Thanks

Regards

[Spam Catcher]

Spam Catcher <sp**********@rogers.comwrote in
news:Xn**********************************@127.0.0. 1:

why would one use it?

I mean "why wouldn't one not use it" :-)

--
sp**********@rogers.com (Do not e-mail)

[Jeff Gaines]

On 27/01/2008 in message <Xn**********************************@127.0.0.1>
Spam Catcher wrote:

>I mean "why wouldn't one not use it" :-)

In my case because (a) it swallows resources to run and (b) it is a pig to
backup (in Access I can just copy the files).

However, apart from that I'm sure you're right :-)

--
Jeff Gaines

[Spam Catcher]

"Jeff Gaines" <wh*********@newsgroups.nospamwrote in
news:xn****************@msnews.microsoft.com:

In my case because (a) it swallows resources to run and (b) it is a
pig to backup (in Access I can just copy the files).

You can backup SQL Server CE by just copying the files.

As for resources, the runtime is ~1.5MB - quite small. Memory usage seems
to be minimal as well.

However, apart from that I'm sure you're right :-)

--
sp**********@rogers.com (Do not e-mail)

[Spam Catcher]

Olaf Rabbachin <Ol*********@IntuiDev.comwrote in news:emiglFaYIHA.5208
@TK2MSFTNGP04.phx.gbl:

Would it be possible to use the System.Data.Sql* namespaces to connect to
both a SQLS2000 and SQLSC3.5? Anybody done this before ..?

They use difference ADO.NET drivers to connect.

Nevertheless you could use a data abstraction layer to handle your
requirements - a framework such as LLBLGen Pro would do what you need.

As for synching SQL Server CE -SQL Server, yes I believe that is provided
out of the box.
--
sp**********@rogers.com (Do not e-mail)

[Jeff Gaines]

On 28/01/2008 in message <Xn**********************************@127.0.0.1>
Spam Catcher wrote:

>You can backup SQL Server CE by just copying the files.

While the server is running?

--
Jeff Gaines