Access aplication on website

[artur]

I have developed an Access application with users/password control, and I want to put it on a website, so that people could work on it even if they don't have MS Access installed.

I've checked the "export to ASP file" posibility, but I don't know how does it works. Anyone can help me?

Thanks!

 

[Bee]

What version of Access are you using?

 

[artur]

Microsoft Access 2003.

I just want to make this database easy accessible and work-able from the internet without downloading the whole file and working in "local" on it.

Is it possible? Thanks!!

 

[AccessJunkie]

Hi,

I'm interested in hearing about your scenario. Can you describe in a little more detail what you hope to accomplish? Can you describe your application a little bit? Size, complexity, business need, etc?

In what way would you like Access to help you here? How do you envision your users using this application? How many users?

Thanks,
--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[artur]

Thanks for your reply!

It is an access application where you have at first to log in, and after that you can include details of some activities, or consult them.

There will be just 8 users, and I need to put it on a website, because this users live very far from each other.

I have all of this done in a beautiful MS ACCESS application, but I don't know how to make it run on a website (I don't mean just copying the MDB file on the site, so people could download, log-in, include data, and upload).

My website is developed on ASP.

Can you help me??

 

[AccessJunkie]

Hi Artur,

Thank you for the information.

Can you describe in more detail the complexity of your application?
How many tables are in your database?
Approximately how many records are in your tables now?
How many records do you think you'll add to these tables in the future?
Will you be running reports off this data for the users to print?
Do you use macros, VBA code, or both to automate the application?

Thanks,
--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[artur]

Thanks a lot for your help,

How many tables are in your database?
9 tables, each one records from 16 to a maximum of 96 records.

Will you be running reports off this data for the users to print?
YES

Do you use macros, VBA code, or both to automate the application?
Just macros

I just thought there would be some kind of ASP code to make the MS Access application work on my website, without giving all of these information

 

[Simon_MT]

So far as ASP from don't use the MS version, great it produces if you are lucky one solitary record and spurious code. If I remember correctly there maybe a 3rd Party conversion utility that would transform Access to ASP on the web.

I personally choose to write the web site in ASP by hand. This is not for the faint-hearted. In the end deployed a hybrid approach. For remote users I used a Terminal Server and this I believe was a better alternative than having to code my entire internal solution.

Simon

 

[artur]

Thanks Simon,

Could you give me the name of that 3rd party conversion utility? Creating the ASP site by hand would be too much work, having now a great MS Access database with all the forms, user control and reports developed.

I have heard something about a dbGrid class which does this job, but I really don't know...

Best regards,

Arturo

 

[Simon_MT]

I think it was CodeChange but I did not try to implement it. It comes recommended by an IT manager heavily into databases.

Do get me wrong, but like you I didn't want to mess my database so I went the Terminal Server route in the end that way I have less chance to really muck things up! I'm still very happy with the solution the only thing really different is that the remote users get to the Terminal Server over the Web through VPN tunnels, there was not one ounce of code change required within the database.

Don't let me persuade one way or the other do whats right for your circumstances.

Simon

 

[AccessJunkie]

Thanks a lot for your help,

How many tables are in your database?
9 tables, each one records from 16 to a maximum of 96 records.

Will you be running reports off this data for the users to print?
YES

Do you use macros, VBA code, or both to automate the application?
Just macros

I just thought there would be some kind of ASP code to make the MS Access application work on my website, without giving all of these information

Hi Arturo,

There's nothing built into Access to enable this functionality so ASP is probably an option. (I don't have any experience with that.)

My questions were geared towards finding out how users are using currently Access, how they'd like to be using Access, and what we can do in the future to enhance Access for developers.

Thank you for the additional information.

--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------