Bob-
Access 2007 can still create and run adp files. You should try your Project
under 2007 before making any decisions.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robert
Sent: Thursday, July 28, 2011 12:34 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Access 2003 Data Project to Access 2007
The company I work for is moving from Access 2003 to Access 2007 next month. We
have an Access 2003 data project front end / SQL Server 2005 back end that is
mission critical and heavily used. The data project is mostly for display of
read only data and reporting. There are some updates made to the SQL tables,
mostly appended records. All data displayed in the data project is from SQL
views and stored procedures are employed for all data updates.
I understand that 2007 doesn't support data projects. I would appreciate any
recommendations on how to best make this migration. My main concern is what is
the most reliable and secure way to connect to the SQL views and call stored
procedures that require parameters to be passed. I know I can use pass though
queries for the views but I'm not sure if this is recommended.
I have searched the archived messages in this group but haven't been able to
find exactly what I'm looking for. All input will be appreciated.
Thanks,
Bob
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar