VB.net & Access

[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

 

[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.


...

 

[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

 

[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.

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

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

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