473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Recommended db app strategy

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
Jan 27 '08 #1
5 1116
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)
Jan 27 '08 #2
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
Jan 27 '08 #3
"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)
Jan 28 '08 #4
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)
Jan 28 '08 #5
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
Jan 28 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: ajsiegel | last post by:
Viile writes - >Type declarations are a feature that might benefit IronPython and >Jython more than they would CPython. How much is this part of Guido's decisionmaking process? Guido is ,...
0
by: Robert Oschler | last post by:
I want to have a master table and a detail table. I want the master table record to be created only if one does not exist already for a given account ID. Here is my concern: Let's say I have...
4
by: Claudio Jolowicz | last post by:
I am trying to find a solution to the following design problem (code at the bottom): We are implementing a trader agent that can trade with other traders on an electronical trading platform. To...
4
by: omeropee | last post by:
Hi, Our company is an independent Voice applications solution provider with number clients using our suite. We have a CT application suite which is running with Application Server and SQL Server...
1
by: omeropee | last post by:
Hi, Our company is an independent Voice applications solution provider with number clients using our suite. We have a CT application suite which is running with Application Server and SQL Server...
9
by: Tony Lee | last post by:
Some time a ago, on this newsgroup the following comments were made in recommending good references for Access (2003) >I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
18
by: John Salerno | last post by:
Hi all. I was hoping some of you could recommend a book or two that would help me get started with the basics of C#. I have a slight knowledge of programming, but basically I want to start out like...
6
by: Daniel Santa Cruz | last post by:
Hello all, I've been trying to go over my OO Patterns book, and I decided to try to implement them in Python this time around. I figured this would help me learn the language better. Well,...
5
by: pythoncurious | last post by:
Hi python experts In C++ I can do something like this: class Base { public: void f() { this->f_(); } private: virtual void f_() = 0; };
0
by: gulabhusen | last post by:
In ASP.NET AJAX we can use the update panel control to update the partial page. but if there are number of controls present on web form and many of them are dependent on another controls event i.e....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.