MDB file to ADP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thank you for responding. I made a mistake. I am using MSSQLDB. The
webhost is webhost4life.com. Do you have any suggestions?
 
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.
 
Back
Top