By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,649 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,649 IT Pros & Developers. It's quick & easy.

ms access project 2003

P: n/a
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).

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?

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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
GAVO-UK wrote:
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).
....can ONLY be used with MSSQL (or MSDE).
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?
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".
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.