>I am finding that Access is not supporting my needs. So is the vendor of the underlying product I use. The vendor is going to convert to MSDE later this year, so I figure I need to look at converting my databases.
>
>Does anyone here have any experience in converting Access to MSDE?
>
>Any help, lessons learned, tip/tricks would be appreciated.
>
>Thanks,
I haven't personally converted Access to MSDE but I have converted other types. MSDE, like SQL Server, includes Data Transformation Service (DTS) which has built-in connection capability to Access databases. A potential problem you might encounter is in the conversion of date and time datatypes. I've had this problems with some database types but I've never tried Access, it may convert without difficulty.
You will find information on DTS in the SQL Server documentation.
Bob Tracy
Never engage in a battle of wits if you're only half armed.