Is MS Access database based application will be portable in all Windows machine ?
-
Hi, I am planning to choose an embedded database for my windows application. If I choose MS Access, will my user need Microsoft Office installed in his/her machine in order to use my application ? Can I embed the required libraries so that my application will work without MS Office ?
-
Hi, I am planning to choose an embedded database for my windows application. If I choose MS Access, will my user need Microsoft Office installed in his/her machine in order to use my application ? Can I embed the required libraries so that my application will work without MS Office ?
You can develop your application in VB.NET or C#.NET and your clients will not need MS-Office installed for your application to run. You will be delivering an executable (*.exe) and a (*.MDB) file to your customer, all of your compiled code will contain the libraries necessary to read/write data to the MS-Access MDB database.
-
You can develop your application in VB.NET or C#.NET and your clients will not need MS-Office installed for your application to run. You will be delivering an executable (*.exe) and a (*.MDB) file to your customer, all of your compiled code will contain the libraries necessary to read/write data to the MS-Access MDB database.
Thank you so much. Just one more question. Do you think MS Access is a good choice over SQL Server Compact ? I mean, performance and portability wise.
-
Thank you so much. Just one more question. Do you think MS Access is a good choice over SQL Server Compact ? I mean, performance and portability wise.
MS-Access vs SQL-Server Depends on the nature of your application. For example, I built a very small membership application which stores Names, Addresses & Photos of people beloning to a swim club with MS-Access as the data storage. The program is not networked and is very small; less than 300 members. So it works fine. If your application is going to be used by multiple users over a network, then I would strongly suggest using MS-SQL. Good luck.
-
Thank you so much. Just one more question. Do you think MS Access is a good choice over SQL Server Compact ? I mean, performance and portability wise.
Nadia Monalisa wrote:
Do you think MS Access is a good choice over SQL Server Compact ?
Not really. If you don't plan on using Access itself, then I see no advantage. SQL Server, even the Express version (which is free), seems like the more capable and reliable component. And MDB stuff is bound to cause trouble in a 64-bit environment, so it will not be the long-term way to choose. :)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
-
Nadia Monalisa wrote:
Do you think MS Access is a good choice over SQL Server Compact ?
Not really. If you don't plan on using Access itself, then I see no advantage. SQL Server, even the Express version (which is free), seems like the more capable and reliable component. And MDB stuff is bound to cause trouble in a 64-bit environment, so it will not be the long-term way to choose. :)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
Hi, Thanks for the reply, Full blown SQL Server or SQL Server Express cannot be used for my application as my user wont install those. I have only 2 options, 1. SQL Server COMPACT OR 2. MS Access So, by performance, are you suggesting me to use SQL Server COMPACT ?
-
Hi, Thanks for the reply, Full blown SQL Server or SQL Server Express cannot be used for my application as my user wont install those. I have only 2 options, 1. SQL Server COMPACT OR 2. MS Access So, by performance, are you suggesting me to use SQL Server COMPACT ?
I can't answer that. I suggest you perform a little experiment, just create some code simulating your typical DB operations, fit the right DAL, and observe on a relevantly sized but otherwise fake database. :)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
-
Hi, I am planning to choose an embedded database for my windows application. If I choose MS Access, will my user need Microsoft Office installed in his/her machine in order to use my application ? Can I embed the required libraries so that my application will work without MS Office ?
I use Access for some very simple databases for my own purposes, but I recommend Sql Server Express. If you use Access 2007+ and create an .accdb file rather than .mdb and the user doesn't have Office, you may need to install http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en[^].
-
Hi, Thanks for the reply, Full blown SQL Server or SQL Server Express cannot be used for my application as my user wont install those. I have only 2 options, 1. SQL Server COMPACT OR 2. MS Access So, by performance, are you suggesting me to use SQL Server COMPACT ?
Nadia Monalisa wrote:
So, by performance, are you suggesting me to use SQL Server COMPACT ?
I suggest that you measure it's performance, as different machines will display different behaviors. In general, it seems to be suggested that Sql Ce is the faster of the two, with my own testresults[^] listed below;
Microsoft Access (Provider: OleDB)
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database1.mdb;User Id=admin;Password=;
16377 records 54 seconds, averaging 0.0033 seconds per inserted record.SQL CE (Provider: SqlCe)
Data Source=C:\MyDatabase1.sdf;
16377 records in 38 seconds, averaging 0.023 seconds per inserted record.Sql Compact does have other limitations, so it's a trade-off between the extra speed, or extra convenience. You can't use stored procedures for one, while Access has the benefit that you can even embed some reports in the datastore. Don't take a suggestion based on rumors on the internet - make a list of arguments that prove that it's going to be the better choice for your specific scenario.
I are Troll :suss:
-
Thank you so much. Just one more question. Do you think MS Access is a good choice over SQL Server Compact ? I mean, performance and portability wise.
Nadia Monalisa wrote:
I mean, performance and portability wise.
On average performance is unlikely to be a concern for a single user system. With specific information about the functional needs of your application it might be more relevant. Reliability on the other hand could be a factor. Portability is probably meaningless because anything that is going to run .Net is going to be able to run SQL Server. Presumably there is no intention at all, under no circumstances, where more than one user of the database is required. If so then SQL Server is probably a better choice. Installation can be made a non-issue by providing an installer that installs everything.