Access Project over the net

[crosmill]

Can it be done?

 

[directormac]

Providing a few more details would be helpful, but I don't see why not, if you're willing to invest the time to work out the logistics.

--Optimistic Mac

 

[crosmill]

OK

I want and access front end with a SQL server back end using SQL Server to pull the replication accross the intenet.

I'm having trouble setting up either ODBC/OLE DB or ftp with access to connect accross a WAN, it's fine over a LAN but it doesn't like going accross networks. All the documantaion I've read says that SQL Server will do it but that Access won't, but the SQL Server documantaion says it will replicate with heterogeneous database over the internet.

 

[directormac]

Well, you've already gone right past the limits of my concrete knowledge--I thought you were asking a very different question (about DEVELOPING an Access project as a team via the web).

However, based on what you've said above, it sounds like Access + WAN = bottleneck, so I ask:

Is it possible to either...
(1) use a web-form front-end instead, or
(2) install the FE locally to send and receive JUST the SQL to the BE, so that the data isn't replicated locally at all?

Bear in mind, these are just blue-sky suggestions. You need to get Pat, Jack, or one of the other list gods to help you with this one.

--Useless Mac

 

[crosmill]

The client can't afford a web front end, SQL Server Replication will just send the amended data 'on syncronisation' but you need to create the 'elusive' connection in order to be able to do it.

Unfortunatly the data will be updated from both ends so it needs to be replecated, I can't just backup or copy tables.

 

[Autoeng]

You could use Data Access Pages developed in Access as the front end and an Access back end. There isn't a lot of documentation for DAP's but it is possible as I am doing it. A good source of info is Access 2000 Volume 2 Enterprise Edition.

Autoeng

 

[crosmill]

Doesn't that require a web hosting ?

I've not really used dap much, will it save locally and update on command?

 

[Autoeng]

If the company has a WAN you can use that. Cannot save locally but why would you want to if it is across the WAN. Updates can performed via a command button.

Autoeng

 

[crosmill]

OK that sort of works on the test.

Cheers I'll look into this a bit more.

 

[crosmill]

Autoeng

Am I right in saying that you cannot update data from a data access page?

 

[Autoeng]

No. You can update info on a DAP but the primary key has to be on the page (even if it's hidden).

Autoeng