Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Go Back  Xtreme Visual Basic Talk > > > Do you need access installed on a pc to be able to read/write to a database from vb?


Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2014, 11:47 AM
Meridian2000 Meridian2000 is offline
Contributor
 
Join Date: Jul 2003
Location: London/England
Posts: 573
Default Do you need access installed on a pc to be able to read/write to a database from vb?


Hi everyone,
Do you need access installed on a pc to be able to read/write to a database from vb ? I've been asked by a friend to write a program that needs to use a database to hold data. I've written a few simular programs in the past for myself but I've always had Office 2007 installed with Access. My friend however doesn't use Office products so no Access. Also he's told me the same program will possibly be installed on more than 1 pc of which one will have a 64 bit Windows 7 operating system and the other a 32 bit Windows. Would that make a difference as well.

I'm writing the program on a 32 bit Windows pc using VB.Net (2007)
__________________
Bumshanka - May the seed of your loins be fruitful in the belly of your woman - The Young Ones
Reply With Quote
  #2  
Old 11-18-2014, 01:54 PM
PlausiblyDamp's Avatar
PlausiblyDampDo you need access installed on a pc to be able to read/write to a database from vb? PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

you don't need Access installed to have a VB app read and write to a .mdb file. If you are deploying onto a 64bit PC however you need to make sure the application is set to compile as a x86 (i.e. 32bit) application as there is no 64 bit driver for Access.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #3  
Old 11-18-2014, 04:07 PM
Gruff's Avatar
GruffDo you need access installed on a pc to be able to read/write to a database from vb? Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

Not sure that is true PD.

You can download the 'Microsoft Access Database Engine 2010' Redistributable from here.

http://www.microsoft.com/en-us/downl....aspx?id=13255

You need to choose AccessDatabaseEngine_x64.exe for a 64 bit system.

FYI you cannot have versions of Office earlier than 2010 installed with this component nor use 32 bit Office of any version with this component

Office 2010 installs as 32 bit by default even on a 64 bit system. To install as 64 bit you have to view the DVD with explorer and launch the install from the 64 bit folder manually.
__________________
Burn the land and boil the sea
You can't take the sky from me


~T

Last edited by Gruff; 11-18-2014 at 04:42 PM.
Reply With Quote
  #4  
Old 11-19-2014, 02:37 AM
Meridian2000 Meridian2000 is offline
Contributor
 
Join Date: Jul 2003
Location: London/England
Posts: 573
Default

Thanks for the replies, Gruff you said what PD said is not strictly true, which part? both ?
__________________
Bumshanka - May the seed of your loins be fruitful in the belly of your woman - The Young Ones
Reply With Quote
  #5  
Old 11-19-2014, 04:27 AM
PlausiblyDamp's Avatar
PlausiblyDampDo you need access installed on a pc to be able to read/write to a database from vb? PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

I never realised there was a 64 bit version serves me right for not checking my facts
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #6  
Old 11-19-2014, 10:17 AM
Gruff's Avatar
GruffDo you need access installed on a pc to be able to read/write to a database from vb? Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

Meridian2000,

I just re-read your first post. You are going to have to either have a flexible install package or several different install packages to handle the different possible installs of Office.

1) No Office installed at all.
a) 32 bit. Install the 32 bit Redistributable package described above.
b) 64 bit. Install the 64 bit Redistributable package described above.

2) Office installed.
a) 32 bit. Standard Office 32 bit drivers are present.
b) 64 bit. Office 2010 or greater installed as 64 bit app.

As noted before you cannot mix any 32 bit and 64 bit components nor have both 32 bit and 64 bit Database drivers on the same system.

All of these are good reasons not to use Access database files for a distributed program any more.
I would recommend using a SQL db instead.
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
  #7  
Old 11-19-2014, 12:05 PM
Meridian2000 Meridian2000 is offline
Contributor
 
Join Date: Jul 2003
Location: London/England
Posts: 573
Default

Quote:
Originally Posted by Gruff View Post
Meridian2000,

I just re-read your first post. You are going to have to either have a flexible install package or several different install packages to handle the different possible installs of Office.

1) No Office installed at all.
a) 32 bit. Install the 32 bit Redistributable package described above.
b) 64 bit. Install the 64 bit Redistributable package described above.

2) Office installed.
a) 32 bit. Standard Office 32 bit drivers are present.
b) 64 bit. Office 2010 or greater installed as 64 bit app.

As noted before you cannot mix any 32 bit and 64 bit components nor have both 32 bit and 64 bit Database drivers on the same system.

All of these are good reasons not to use Access database files for a distributed program any more.
I would recommend using a SQL db instead.
Thanks Gruff, any suggestion on what SQL I should use and any links where I can learn how to use it please
__________________
Bumshanka - May the seed of your loins be fruitful in the belly of your woman - The Young Ones
Reply With Quote
  #8  
Old 11-19-2014, 01:10 PM
PlausiblyDamp's Avatar
PlausiblyDampDo you need access installed on a pc to be able to read/write to a database from vb? PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

SQL Express is free and should do the trick (http://www.microsoft.com/web/platform/database.aspx)
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #9  
Old 11-19-2014, 01:42 PM
Meridian2000 Meridian2000 is offline
Contributor
 
Join Date: Jul 2003
Location: London/England
Posts: 573
Default

Quote:
Originally Posted by PlausiblyDamp View Post
SQL Express is free and should do the trick (http://www.microsoft.com/web/platform/database.aspx)
Many thanks PD
__________________
Bumshanka - May the seed of your loins be fruitful in the belly of your woman - The Young Ones
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb? Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
 
Do you need access installed on a pc to be able to read/write to a database from vb?
Do you need access installed on a pc to be able to read/write to a database from vb?
 
-->