View table data across the internet

[aman]

Hi guys

I have a table in access that I want everyone who has the authorisation can view on the internet and also whenever the data changes then it should appear on the internet too.

I tried export file method but it doesn't work as when I make changes in the table it doesn't appear on the internet.

Is there any method to do this? any vba code?

Thanks
aman

 

[ezfriend]

If you only need your user to see the data, it is probably best to just run an ASP page or something and display your data using simple select statement. User will need to refresh the screen to see changes.

If you need your user to actually modify data directly to the table then that's something else.

 

[aman]

Hi ezfriend

Thanks for you reply . Actually I just want others to view table data only which is exported to internet. But As I am working on a project so new records are added up on daily basis so the table on the internet should update automatically.

Could you please let me know step by step how can I acheive this.

Regards
Aman

 

[jal]

I tried export file method but it doesn't work as when I make changes in the table it doesn't appear on the internet.

I'm not familiar with 'export file'. I think you simply need to have a file link on the web page. When the user clicks the file link, the file opens, assuming he has the necessary software for opening that type of file. What type of file are you uploading?

If the file doesn't open when the user clicks the file link, you may have uploaded the file incorrectly. Open your webfolder as to verify that the file is in fact there. Or perhaps you coded the file link incorrectly.

 

[aman]

Hi Jal

Thanks for your reply. Actually the file is Access table .could you please let me know in detail how can I have a link on the webpage that will open that file. Also I want the table to show the updated table always as evryday the changes are made into the table so the updated table should display on the web page.

Regards
Aman

 

[Khalid_Afridi]

if you are familair with ASP.net or VB.net and how to connect the ms-access database through the connection string then you can connect your database with the asp or HTML page accordingly.

Khalid

 

[aman]

Hi Khalid

Thanks for your reply..I have no idea od asp.net or vb.net so how can I send the access table over the internet so that others can view that and if I make changes in the access table then that shud appear in the internet too without uploading it again and again.

Could you please let me know in detail?
Thanks
Aman