Connect an Access project with a remote MDB or SQL server database

[patrickd123]

Hi,

I am finishing an Access database for a customer that may want, in a later stage, to have a website(probably ASP) that would connect on the same database. Is that possible? I mean can an Access project on a pc connect to remote database(mdb or SQL server) used by the website?

If so can you give me some quick steps to do so or a good article on it?

Thanks.

 

[Pat Hartman]

The .adp format is very limited in that it can ONLY connect to SQL Server databases. It can't even connect to Jet tables! Future development should be done with .mdb's since the .adp is no longer being developed by MSFT.

 

[patrickd123]

The .adp format is very limited in that it can ONLY connect to SQL Server databases. It can't even connect to Jet tables! Future development should be done with .mdb's since the .adp is no longer being developed by MSFT.

Did I mentionned anything about ADP(that I don't even know about!)? I use only a .mdb file. Is it possible to migrate the data part to a remote server(my website server) so I can use my project that is on my PC but connecting to the data remotely?

 

[Moniker]

"I mean can an Access project on a pc...".

An ADP file is an Access Project.

ASP will work with SQL Server or MS Access just fine. Do a google search for "SQL Server and ASP" or "MS Access and ASP" respectively. (Keep the quotes in the search string.)

 

[patrickd123]

Ok. But all of those replies don't exactly answer my very question which is: "Can a database(Access or SQL sever) be reachable at the same time and in real time by both a website on a internet server and an MS project on a local server(or PC)."

Here is my situation: We have a MS Access project that the administrators have been using for a while and would like to continue using. But we would like the data in the database to be accessible by a website that we would build in a near future.

My feeling is that there is no way that a website on the internet could get its data from a local PC or server BUT, the contrary could be possible that is, move our database from PC to internet server(so that the website can access it) and configure Access on our local server(or PC) to point to the internet server to get its data.

Is that doable?

 

[Moniker]

Absolutely. That's a front-end/back-end (FE/BE) setup. The front-end on your local PC is the forms and reports and other associated data, with all the tables being linked. The front-end on the website is slightly different, but it accesses the same back-end DB as the local PC's front-end.

There are multiple examples of that throughout the forum here. You may not have known the terminology to search on.

 

[Pat Hartman]

Just an FYI for Patrick, if you insist on calling your access application a project, you will continue to get answers that relate to an .adp

Access/Jet isn't a great choice as a database to be accessed via the web but it is certainly possible so as Moniker pointed out just split you application into a back end which contains only tables and a front end which contains all the other objects. You can use the db splitter tool or do it yourself.