himanshurulez

Hi Thanks for the reply...I tried ur solution...But I now facing another problem..actually i have used database splitter in MS Access to split the database...now access does some internal coding to link the forms in the spitted database to the tables database...now how do i link the splitted database in the remote location to the tables database in the main server..??

HiI am a manager at a trading/wholesaling company (and have no programming background). I customized the Northwind sample access database to make invoices and keep accounts for my company. We now opening another office at a distant location. So, the order entry will be done at two points(we plan to use the same Access database).I am not able to figure out how to access the same MS Access database from two different location(as LAN can't be used). Moreover, we can't afford to pay huge sums to the software developers. Can intranet or uploading the database to a web server be a solution to this?? How?? If not, plz suggest something else?PS: I just need a central location where the database can be stored, and all employees can run and modify the database via internet (or some other source)