473,326 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

ms access project 2003

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
1 1555
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: MyaTiX | last post by:
Hi Can someone tell me if it is at all possible to create a web application using Microsoft Project. I want to create a web application that provides users with the possibility to view the gant...
1
by: Mick Forde | last post by:
I am an access /project beginner. I have created a db using access project, and have it connected to msde. How do i input information into the db. any help would be appreciated posthole
7
by: damjanu | last post by:
Hi All; I need little help. I have a datasheet form. I allow user to do 'filter by selection'. My form contains a column with values. As user changes selections, I want to calculate totals....
1
by: MVM | last post by:
Hello everyone- I am having a little trouble calculating totals in an access report. The report is part of an Access Project which gets its data from SQL Server 2000. I have the calculations...
6
by: Kenneth Courville | last post by:
Hello, I'm looking for assistance with the Access object model. I know this is VB, but I'm building an Office Add-using C# directed at Access 2002. I'm literate in VB, so you can reply in VB... I...
1
by: Najatte | last post by:
Hi, How to create an object in VB inherits from Microsoft Project 2003. I did it for Excel and it worked Dim obj as Excel.Workbook. Thx, Najatte
1
by: Brunson | last post by:
I would appreciate any help or suggestions in utilizing an Access form to input data in MS Project 2003. Basically I would like to create a form and have dates and/or durations input then have it...
4
by: =?Utf-8?B?SGVyYg==?= | last post by:
Can someone point me in the direction of documentation for Office Interop? Specifically, Microsoft.Office.Interop.MSProject. Mainly what I need is a command set, programming documentation. I...
2
by: karimufeed | last post by:
Kindly help me how to secure an access project built in access 2003 for unauthorise editing in its design and code by others. Thanks
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.