Putting my database online.... my options??

[essjay_d12]

I would like to put my database that I have created online so I can update it from anywhere, and was wondering what are my options - does access have a feature to do this? Or will it involve using dynamic coding to update the tables? I would like to use the forms that I have already created etc ... but is this possible?

I have my own server if this helps?!

thanks

d

 

[KenHigg]

You have many options and each one has its strong point and weak points. Personally, I would drop the idea of trying to use any part of Access for an online solution. One of the more popular options is .ASP and SQL Sever which at this point, is what I would recommend...
Ken

 

[essjay_d12]

the problem is that the database is already been long in use - and is quite ehavily populated, ideally i would use .asp or .php with it if I have to, but there is no direct way of creating a site from the existing db?

 

[KenHigg]

I would migrate the tables over into sql server and continue to use your Access db as the front end. Then you can develop your web front end with .asp, etc...

The primary issue with trying to do web with Access is that access is a 'file server' system as opposed to SQL Server being a 'database server'. And the basic issue with using a file server database is that if your user wants to see 1 record in a table with 10k records, Access must move all 10k records over the web and then find the 1 record the user needs. In a 'database server' all the work is done on the web/database server and only the one record has to be returned over the web...

Hope all of this makes sense -

Edit: Here's a link that may help - Link