How would i set up a access database on a shared server?

Question

i am looking for ways or ideas to put an access database on a server so multiple people can access and enter data from different computers/different time/

Answer 1

You can install the free version of SQL Server 2005 on the server, then use ODBC to link an empty Access database on each PC to the SQL Server on the server.



You create an ODBC DSN to the SQL Server via the Administrative Tools -> Data Sources control panel. You use it within Access via File -> Get External Data -> Link Tables.

Answer 2

Since I don't have all the particulars, I may not be giving you the best advice, but here goes.



Use the database Splitter wizard which separates the back end (Data) from the front end (the application - queries, forms, reports, etc. )



Give everyone a copy of the front end and make sure there is a good link to the back end.



This is the quick and easy version. If you need more help, contact me.



I would like to disagree with tekdeth about Access being "OLD" and won't die. MS SQL is often too powerful and hard to understand for many computer users. Access fills a very nice niche and if you know how to use it - it can be very, very powerful and useful.

Answer 3

Hi!



The first thing try to avoid MS-Access becoz its not a robust database, in case u don't have other way then u can



1.Place the database on a system.

2.Develop an application Program which uses DSN to connect to the remote database.U can also use Login and Password to check unauthorized access.

3.Put this Exe on the end user's system.

VB wud be the easiest Language to develop it.

Answer 4

different computers/different times?? Well as long as you have Access installed on all the computers that will be using it, just put it in a shared folder on the server, and then put it on everyone's computer as a shared drive so they have an easier time getting to it to open. Let me know if you need some more help with this...

Answer 5

Convert to MS Sql Server. hehe. Access is a decade old technology that just won't die! :D