Reply to thread

Message: [QUOTE="Cowboy \(Gregory A. Beamer\), post: 1936947"] It is almost as easy as Access, but not quite. Ask your ISP if they support SQL Server 2005 file based databases. If so, they should be able to help you link the file up to their server. They can then tell you how to use it. If they do not, you will have to migrate the data. Since you will only have limited tools on the local SQL Express install, this might be a pain. The easiest way is to recreate the seed data as scripts. The SQL Express tools are minimal help here. You can download a trial of redgate's product and create the data insert scripts. You then connect to the ISP SQL box and run the sql script. The other option is move to Access, but depending on where they have the files, you may have to set the connection string based on file location, using MapPath. This is fairly simple. Reason: For security, some ISPs move the root location, which will force you to figure out the path to the .mdb file using Server.MapPath. Don't worry, it does get easier once you do it once. -- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA ************************************************* Think outside of the box! ************************************************* [/QUOTE]