Displaying data from data base on web site

[pam0566]

I am using access 2007. and Expression Web2. I was trying to get an inventory list to display live on my website, and created an .aspx page to do that. works fine in preview mode, but couldnt get it work once published. after 2 weeks of pulling my hair out, i didnt figure out how to do it only to finally find out my server doesnt supposrt access 2007. Since changing hosting companies is not an option at this time-- anyone know of another way i can display data easily to a web site? data access pages arent supported in acces 2007 i know.. so any other feasible recommendations would be greatly appreciated.

 

[pbaldy]

This is a shot in the dark, but have you tried saving the database in MDB format rather than ACCDB? You can use 2002/3 format or 2000, either of which might be supported by the hosting company.

 

[pam0566]

i can try that. i wanted to use some of the access 2007 functions.. that is one of the prob. another question, is there any way to do this that you know of without uploading and working of my data base on the web hosting company? the data base takes a LONG time to upload and its kind of a pain to work with them. would like to find another alternative.,,thanks

 

[pbaldy]

My assumption was that the database would only be data tables, and the functionality would be done in ASP or whatever.

I'm not sure how to work without uploading it. I've written some ASP that uses databases (Access and SQL Server), but only for our company, and we host our own sites, so I don't have experience working with a hosting company. Sorry.