Troubles with Converting dbs to Access Database Project?

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

Guest

I am in the process of brushing up my web site. Are there any specific
things I should do or perform prior to attempting to convert the design to
ADP?

If I have a combo box for 6000+ customers, will that slow the process and
freeze up the program?

Thanks,
Ivan.
 
An ADP has nothing to do with web sites, Ivan. An ADP is a front-end,
application file that runs on the desktop and doesn't contain any data. Did
you mean that you wanted to convert your web pages to DAPs (Data Access
Pages)? Or perhaps you mean you're moving your data from a Jet database
(MDB) to SQL Server?
 
I truly apologize for making such a stupd typo. It was a long day when I
posted my question.
I put together a mdb access database on my laptop which I would like to
convert to access database project (that access 2003 offers as a tool). It's
tables will be stored on a SQL 2000 server. The existing order entry web
site will be linked to the tables. I will NOT be putting together any DAP's.

I have never done a conversion. Once I have the mdb fully functional and
tested, I would like to make it into an ADP.

THANK YOU VERY Much!
Ivan.
 
Hi Ivan,

I'm still a little confused, because as I said earlier, ADPs don't have
anything to do with web apps. Perhaps you mean that you have both a web app
and a desktop Access app using the same data?

Anyway, I would certainly *not* recommend making an MDB app "fully
functional and tested" and *then* converting to ADP, because you will need
to make a lot of changes to the app when you convert it. Lot's of things
that work in an MDB app don't work in an ADP. Why spend time perfecting and
testing something that's going to change anyway?
 
There is a tool in Access 2003 that converts an MDB
project to an ADP? Where?


(david)
 
It's one of the options in the Upsizing Wizard, David. On about the fifth
page of the wizard, you get the option 'Create a new Access client/server
application', which creates an ADP.

In my (admittedly limited) experience, I have not found it to work very well
with a non-trivial MDB application.
 
Thank you very much Brendan. You are correct. Our website will use and
store data in the tables of the project. Now that I know that the conversion
will require changes, I will convert and then brush up.
 
Back
Top