Db over internet
-
Hi friends. I have a small software that uses an access database. I use it at home but i wonder if i can use it from anywhere by reaching the db over internet. Should i change any code to do so. By the way if Access doesnt support this function, i can replace my db with sql server.
-
Hi friends. I have a small software that uses an access database. I use it at home but i wonder if i can use it from anywhere by reaching the db over internet. Should i change any code to do so. By the way if Access doesnt support this function, i can replace my db with sql server.
Bad idea; Microsoft Access is not meant to be used as a server, and it ain't as secure as Sql Server. I'd even recommend against using Sql Server over the internet, would be safer to have IIS on the same server and provide access to the DB using webservices. I can imagine you don't want to "waste time" with writing a useless layer. If my memory serves me correct, you'd open port 1433 on the firewall. Updating from Access to Sql Server should be easy; if you open the DB in Access, you'll have a button in that lint that says "upgrade to Sql Server" - that launches a wizard that recreates all your tables in Sql Server. Hope this helps :)
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Hi friends. I have a small software that uses an access database. I use it at home but i wonder if i can use it from anywhere by reaching the db over internet. Should i change any code to do so. By the way if Access doesnt support this function, i can replace my db with sql server.
leone wrote:
I use it at home but i wonder if i can use it from anywhere by reaching the db over internet.
As stated no. MS Access is a file based server. Thus if you have software that uses MS Access then the file must be visible in file system of the client machine. Thus if you want to run the software on machine A then on A you MUST be able to open explorer and see the database file. That means that you would need to enable file sharing over the internet. You might be able to do that depending on the machines at either end and how they are connected.
leone wrote:
i can replace my db with sql server.
MS SQL Server is accessible via the internet as long as the server machine is accessible. That is not guaranteed (machine is visible) but that is a different discussion. It is possible to secure MS SQL Server so it can be exposed on the internet however either you must presume that your data is not secure and not important or you are going to need to learn a lot more about internet security and SQL Server before using it. It probably isn't worth learning that since it isn't a skill that businesses want.
-
leone wrote:
I use it at home but i wonder if i can use it from anywhere by reaching the db over internet.
As stated no. MS Access is a file based server. Thus if you have software that uses MS Access then the file must be visible in file system of the client machine. Thus if you want to run the software on machine A then on A you MUST be able to open explorer and see the database file. That means that you would need to enable file sharing over the internet. You might be able to do that depending on the machines at either end and how they are connected.
leone wrote:
i can replace my db with sql server.
MS SQL Server is accessible via the internet as long as the server machine is accessible. That is not guaranteed (machine is visible) but that is a different discussion. It is possible to secure MS SQL Server so it can be exposed on the internet however either you must presume that your data is not secure and not important or you are going to need to learn a lot more about internet security and SQL Server before using it. It probably isn't worth learning that since it isn't a skill that businesses want.
-
leone wrote:
I use it at home but i wonder if i can use it from anywhere by reaching the db over internet.
As stated no. MS Access is a file based server. Thus if you have software that uses MS Access then the file must be visible in file system of the client machine. Thus if you want to run the software on machine A then on A you MUST be able to open explorer and see the database file. That means that you would need to enable file sharing over the internet. You might be able to do that depending on the machines at either end and how they are connected.
leone wrote:
i can replace my db with sql server.
MS SQL Server is accessible via the internet as long as the server machine is accessible. That is not guaranteed (machine is visible) but that is a different discussion. It is possible to secure MS SQL Server so it can be exposed on the internet however either you must presume that your data is not secure and not important or you are going to need to learn a lot more about internet security and SQL Server before using it. It probably isn't worth learning that since it isn't a skill that businesses want.
Don't understand why this was downvoted, (over)compensating.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
Hi friends. I have a small software that uses an access database. I use it at home but i wonder if i can use it from anywhere by reaching the db over internet. Should i change any code to do so. By the way if Access doesnt support this function, i can replace my db with sql server.
Access can only be used remotely on MS Sharepoint websites, but you could uses Access as a data store behind a hosted web application (though I would suggest the use of SQL server). Alternatively, you can use Access as the front end to a hosted SQL server database, so your user interface is local, but links to the remote database. Many web service providers offer MSSQL and/or MySQL databases
==================================== Transvestites - Roberts in Disguise! ====================================