N
nutraf
Hi,
i'm planning the migration of my Access97 DAO 3.5 project with mdb
backend onto Access 2007 + SQL Server. (Express Edition)
Some Questions:
1) In my actual A97 project i'm using different menubar for each form.
Is there a way to use it again in Access2007 or i have to mess with
new ribbon system?
2) Which is the best way to link my Access2007 project to SQL? DAO
+ODBC, ADO+ADP (if already exists)
3) If i deploy my Access2007 project to my customers how can i deploy
even SQL Server DB in the same setup?
4) How can I manage my customers different SQL DB on my development
PC? Backend is almost the same for all the customers but may be
different in certain case. How can I attach and deattach the same file
(i.e. books.mdf) in order to edit feature for customers request?
Thank You in advance
Rob
i'm planning the migration of my Access97 DAO 3.5 project with mdb
backend onto Access 2007 + SQL Server. (Express Edition)
Some Questions:
1) In my actual A97 project i'm using different menubar for each form.
Is there a way to use it again in Access2007 or i have to mess with
new ribbon system?
2) Which is the best way to link my Access2007 project to SQL? DAO
+ODBC, ADO+ADP (if already exists)
3) If i deploy my Access2007 project to my customers how can i deploy
even SQL Server DB in the same setup?
4) How can I manage my customers different SQL DB on my development
PC? Backend is almost the same for all the customers but may be
different in certain case. How can I attach and deattach the same file
(i.e. books.mdf) in order to edit feature for customers request?
Thank You in advance
Rob