Yes, many things won't work correctly directly after the port of a MDB file
to ADP/SQL-Server.
You will have to make a post to the ADP forum (m.p.a.adp.sqlserver) and
describe in detail each error message with its associated VBA code and/or
SQL code.
You should also describe what kind of login you use for connecting to the
sql server; particularly if it's a dbo account or not. ADP will give a lot
of problems (and I mean a lot) if you don't use a dbo account. However,
many public hosting services will refuse to give you access to such an
account. As I'm not the proud owner of webhost4life.com, don't ask me to
solve this for you if you are in this situation.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Sunny" <Sunny[ at ]discussions.microsoft.com> wrote in message
news:9992DB32-23D9-4FF9-8DD1-5D9F6562B7AF[ at ]microsoft.com...
[Quoted Text] > Thank you for responding. I made a mistake. I am using MSSQLDB. The > webhost is webhost4life.com. Do you have any suggestions? > > "Sylvain Lafontaine" wrote: > >> For ADP, you must use a true Microsoft SQL server like MSDE or SQL-Server >> 2000. MySQL and MySQLDB won't work correctly with ADP. >> >> -- >> Sylvain Lafontaine, ing. >> MVP - Technologies Virtual-PC >> E-mail: http://cerbermail.com/?QugbLEWINF>> >> >> "Sunny" <Sunny[ at ]discussions.microsoft.com> wrote in message >> news:35E40F39-DFF2-4D42-8E37-CC4030E6F39F[ at ]microsoft.com... >> >I want to use the microsoft Genealogy Template as a Microsoft Project on >> >a >> > webhost's server. Is there something special I need to do in order to >> > have >> > it work correctly? On my webhost I am using MYSQLDB. I imported the >> > genealogy database onto my webhost's server and now some of the forms >> > don't >> > work and I'm getting Authorization errors and runtime errors. >> >> >>
|