Linking MS Access front-end to the back-end

[magnet-man]

I have an Access database that has a front-end for forms and reports and a back-end for the tables. I have loaded the backend at \_database\route.mdb with a DSN of goldenbeequ_route. How do I link my front end to the backend on discountasp.net? The front-end will reside on my office computer. I have run into a brick wall.

Post Edited (magnet-man) : 4/22/2005 9:47:30 PM GMT

[bruce]

this is not possible.

MS Access is designed to be a desktop database and you cannot connect to it over the Internet.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[magnet-man]

Buce what if I change the back-end to sql?

[bruce]

there are many ways to do that,

you can consider using MS SQL upsizing wizard which comes with MS Access.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[magnet-man]

Bruce, so if i change the back-end to sql, I should be able to keep my current front-end in access with a few minor changes. Is this correct?

[bruce]

no. not really.

you probably need a real significant change to your access database to link to SQL server.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)