moving from msde to access

[beco73]

Hi,

I am using MSDE with Access interface at my home server for my website. Now I want to host my site on some hosting compaany. Id I get access database on a hosting company can I make up back up of my msde database and easily some how move it to access?

Thanks

 

[cmmrfrds]

Can't you just import the tables into Access.

 

[beco73]

how do you do that? what do I need to do on msde side?

 

[cmmrfrds]

The import is on the Access side. Create an access mdb and then import the tables into it. Under the file menu there is an option to import. You should be able to import directly or set up an ODBC to the msde an import using the odbc.

 

[beco73]

right, but msde is on my home machine, and access wil be on the hosting. To import tables do i need to so something on msde side like backup of tables seperately etc.