Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - VB.net & Access

Reply
 
Old 10-01-2008   #1 (permalink)
Billy B


 
 

VB.net & Access

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

My System SpecsSystem Spec
Old 10-01-2008   #2 (permalink)
sloan


 
 

Re: VB.net & Access

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/Blo...842A!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.


...


"Billy B" <BillyB@xxxxxx> wrote in message
news:8B5EDD29-8788-453F-A328-B3DB731EADC9@xxxxxx
Quote:

>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

My System SpecsSystem Spec
Old 10-05-2008   #3 (permalink)
Michel Posseth [MCP]


 
 

Re: VB.net & Access

Hello Billy ,
Quote:

>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" <BillyB@xxxxxx> schreef in bericht
news:8B5EDD29-8788-453F-A328-B3DB731EADC9@xxxxxx
Quote:

>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

My System SpecsSystem Spec
Old 10-15-2008   #4 (permalink)
sloan


 
 

Re: VB.net & Access

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.

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




"Michel Posseth [MCP]" <MSDN@xxxxxx> wrote in message
news:uGcGZbuJJHA.740@xxxxxx
Quote:

> Hello Billy ,
>
Quote:

>>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" <BillyB@xxxxxx> schreef in bericht
> news:8B5EDD29-8788-453F-A328-B3DB731EADC9@xxxxxx
Quote:

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

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Give network access without giving access to the computer itself? Vista networking & sharing
Wireless router - Local access OK but NO internet access - HELP!! Vista networking & sharing
Access 2007 won't Operate Access 2002 File Vista installation & setup
When standard users access Vista registry remotely, Access Denied Vista account administration
Access is denied message when trying to access a remote printer Vista print fax & scan


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46