Access Database Alternatives?
-
Are there any alternatives to MS Access around yet? From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage, and the others like SQLExpress, MariaDB all require servers (or at least software installed to host them). I can't find one that has Access's standalone ability, as our current situation is access databases on LAN/WAN shares. So if there is something that can replace that? The clients are likely to be C# WPF.
-
Are there any alternatives to MS Access around yet? From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage, and the others like SQLExpress, MariaDB all require servers (or at least software installed to host them). I can't find one that has Access's standalone ability, as our current situation is access databases on LAN/WAN shares. So if there is something that can replace that? The clients are likely to be C# WPF.
cjb110 wrote:
From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage,
That's the category that Access falls in.
cjb110 wrote:
I can't find one that has Access's standalone ability
If you want a database-file without a server, you'll be looking at either access, or a single-file database like SQLite. If your data is accessed by multiple people from several workstations, then you DO want a server. There's a button in your Access-IDE that upgrades the entire database to Sql Server. Install Sql Server Express (it's free) on a PC that the users have access to.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
cjb110 wrote:
From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage,
That's the category that Access falls in.
cjb110 wrote:
I can't find one that has Access's standalone ability
If you want a database-file without a server, you'll be looking at either access, or a single-file database like SQLite. If your data is accessed by multiple people from several workstations, then you DO want a server. There's a button in your Access-IDE that upgrades the entire database to Sql Server. Install Sql Server Express (it's free) on a PC that the users have access to.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
:) Your answer is exactly what I was expecting. We've an internal issue in that getting new virtual servers are a long and overly expensive process and brings up 'which dept pays for this' problem. So I wanted to make sure that there wasn't alternatives...
-
:) Your answer is exactly what I was expecting. We've an internal issue in that getting new virtual servers are a long and overly expensive process and brings up 'which dept pays for this' problem. So I wanted to make sure that there wasn't alternatives...
-
Are there any alternatives to MS Access around yet? From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage, and the others like SQLExpress, MariaDB all require servers (or at least software installed to host them). I can't find one that has Access's standalone ability, as our current situation is access databases on LAN/WAN shares. So if there is something that can replace that? The clients are likely to be C# WPF.
-
Are there any alternatives to MS Access around yet? From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage, and the others like SQLExpress, MariaDB all require servers (or at least software installed to host them). I can't find one that has Access's standalone ability, as our current situation is access databases on LAN/WAN shares. So if there is something that can replace that? The clients are likely to be C# WPF.
Per your other answer - where would you put Access if that was your solution? It would need to be somewhere all of the clients could reliably access it. Same thing applies to a standard server database. As for the internal management issue. Put it on a supervisors computer. No one works til that person starts up their computer. Everyone goes home or takes a vacation when that computer is off.
-
Per your other answer - where would you put Access if that was your solution? It would need to be somewhere all of the clients could reliably access it. Same thing applies to a standard server database. As for the internal management issue. Put it on a supervisors computer. No one works til that person starts up their computer. Everyone goes home or takes a vacation when that computer is off.
Access mdb's currently sits on various SAN locations, along side their other stuff like word and excel files. A standard server database doesn't does it...but yea I know what you mean. And unfortunately our various user bases are a bit big for the last idea to be feasible.
-
Are there any alternatives to MS Access around yet? From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage, and the others like SQLExpress, MariaDB all require servers (or at least software installed to host them). I can't find one that has Access's standalone ability, as our current situation is access databases on LAN/WAN shares. So if there is something that can replace that? The clients are likely to be C# WPF.
DBase IV. FoxPro.
-
Access mdb's currently sits on various SAN locations, along side their other stuff like word and excel files. A standard server database doesn't does it...but yea I know what you mean. And unfortunately our various user bases are a bit big for the last idea to be feasible.