GAVO-UK wrote:
[color=blue]
> Hi - Using Access 2003
>
> I've been creating applications in access for the past few years and
> gotten pretty good at it, now I would like to move a bit forward and
> start using ms access project.
>
> I understand the basis concept of it, and know that it is a client /
> server application that can be used with MSSQL (which I already
> installed).[/color]
....can ONLY be used with MSSQL (or MSDE).
[color=blue]
> My question is; Is it possible to create a ms access project and
> distribute its front end to the users and automate the connection to a
> remote server (my computer)purely through the internet, or do i need to
> set up some sort of network with the user's computers first? maybe VPN.
> Ideally I would like the user to open the application and automatically
> make the app to connect to my server?[/color]
Yes. On this page are examples of ADO connection strings for SQL Server:
http://www.carlprothman.net/Default.aspx?tabid=81
Hopefully your target computers are on your internal network. Several
internet worms have been propagated via SQL Server/MSDE, and so at least
a few people have configured their firewalls to block the SQL Server
ports 1433 and 1434...
If the target computers are on your internal Windows network, the
regular connection string should work. Look in the section "OLE DB
Provider for SQL Server".
[color=blue]
> If this sort of thing is possible can some one please direct me to the
> right path or maybe give a URL of online tutorials that explain what im
> looking for, or even a book!!!
>
> some other thing, i was experimenting a litter bit with ms access
> project and was trying to spit the application, you know to get the
> front and back end, but did not find the option, how do i do this?
>
> Thanks in anticipation
>[/color]
