VB.net & Access

1 Oct 2008 3:23 PM

Billy B

I am new in the vb.net environment and am interested in developing a vb.net
application using an Access DB table as the data source. My question is, can
I create a runtime application with this structure and have it run if the
user does not have Access loaded on their computer?

Thanks

1 Oct 2008 5:14 PM

sloan

You can use OleDB to talk to a .mdb file.

You do not need (the program) Access.

You'd probably should alter your syntax slightly to call it a "Jet" engine
database (when you're speaking of a .mdb file as a datastore (without using
the program MS Access)).

Go here:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!176.entry
get the downloadable code. (zip file).

Its C#, but it'll show you how to use a .mdb, excel xls file, and some other
datastores.
It also uses the EnterpriseLibrary.Data .. which greatly simplifies how to
talk with a backend datastore.

NOTE:
An mdb file is not a true RDBMS, but at times can fulfill your needs.

...

Show quoteHide quote

"Billy B" <Bil***@discussions.microsoft.com> wrote in message
news:8B5EDD29-8788-453F-A328-B3DB731EADC9@microsoft.com...
>I am new in the vb.net environment and am interested in developing a vb.net
> application using an Access DB table as the data source. My question is,
> can
> I create a runtime application with this structure and have it run if the
> user does not have Access loaded on their computer?
>
> Thanks

5 Oct 2008 12:36 PM

Michel Posseth [MCP]

Hello Billy ,

>can I create a runtime application with this structure and have it run if
>the
> user does not have Access loaded on their computer?

As long as you do not wish to support 64 bit operating systems you can
however if you want to be on the safe side ( cause my belief is that 64 bit
operating systems is in the near future comon practice )
you would bether go for SQL Server Compact Edition this offers a one dll
runtime wich is XCOPY deployable with your app
and thus much more reliable for now and in the future

http://blogs.msdn.com/sqlservercompact/

regards
Michel Posseth [MCP]
http://www.vbdotnetcoder.com

Show quoteHide quote

"Billy B" <Bil***@discussions.microsoft.com> schreef in bericht
news:8B5EDD29-8788-453F-A328-B3DB731EADC9@microsoft.com...
>I am new in the vb.net environment and am interested in developing a vb.net
> application using an Access DB table as the data source. My question is,
> can
> I create a runtime application with this structure and have it run if the
> user does not have Access loaded on their computer?
>
> Thanks

15 Oct 2008 3:14 PM

sloan

I concur. And my URL shows SqlServerCE support (version 3.1 for desktop).

Read the README files (especially the CE version) for hints and tools to
assist.

...................

Show quoteHide quote

"Michel Posseth [MCP]" <M***@posseth.com> wrote in message
news:uGcGZbuJJHA.740@TK2MSFTNGP03.phx.gbl...
> Hello Billy ,
>
>>can I create a runtime application with this structure and have it run if
>>the
>> user does not have Access loaded on their computer?
>
>
> As long as you do not wish to support 64 bit operating systems you can
> however if you want to be on the safe side ( cause my belief is that 64
> bit operating systems is in the near future comon practice )
> you would bether go for SQL Server Compact Edition this offers a one dll
> runtime wich is XCOPY deployable with your app
> and thus much more reliable for now and in the future
>
> http://blogs.msdn.com/sqlservercompact/
>
>
> regards
> Michel Posseth [MCP]
> http://www.vbdotnetcoder.com
>
>
>
> "Billy B" <Bil***@discussions.microsoft.com> schreef in bericht
> news:8B5EDD29-8788-453F-A328-B3DB731EADC9@microsoft.com...
>>I am new in the vb.net environment and am interested in developing a
>>vb.net
>> application using an Access DB table as the data source. My question is,
>> can
>> I create a runtime application with this structure and have it run if the
>> user does not have Access loaded on their computer?
>>
>> Thanks
>
>