By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

upsize to SQL plus split database plus change Access Forms to DAP what order?

P: n/a
I have a standard Access database with standard Forms and it is not
split. I am going to run the upsizing wizard to change the data tables
to SQL. I also need to split the database and I am going to change the
Forms to be Data Access Pages so that records can be added and edited
through Internet Explorer. What order should I take these steps? Can
I just save the forms as Data Access Pages and they will work? I think
maybe I should get all the DAP pages working correctly first. Then
split, then upsize to SQL? Does this sound right?
1) DAP
2) Split
3) SQL

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Skip the part about Data Access Pages. I forgot that the VB code does
not convert and that the Data Access Pages must have new VBScript code
written for every form. Should I split and then upsize? Or upsize and
then split? Or doesn't it matter.

rc*********@yahoo.com wrote:
I have a standard Access database with standard Forms and it is not
split. I am going to run the upsizing wizard to change the data tables to SQL. I also need to split the database and I am going to change the Forms to be Data Access Pages so that records can be added and edited
through Internet Explorer. What order should I take these steps? Can I just save the forms as Data Access Pages and they will work? I think maybe I should get all the DAP pages working correctly first. Then
split, then upsize to SQL? Does this sound right?
1) DAP
2) Split
3) SQL


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.