n Command Bars: Converted with no changes.
n Macros and Modules: Converted with no changes.
To take full advantage of SQL Server and an Access project, you need to make some fairly significant
changes to your newly converted application. Although the Upsizing Wizard tries to make its
best guess as to the most efficient conversion approach, you should review the table and query
designs and revise them as necessary. Record sources and control sources for forms and reports are
converted without any changes. In an implementation with a large number of users, you don??™t
want to bind forms and reports directly to a table or even a query.
If you??™re converting an application created in an earlier version of Access, you may also
need to manually convert code from Data Access Objects (DAO) to ActiveX Data
Objects (ADO) in your modules.
It is important understand that an Access .adp file does not contain linked tables. The tables in an
Access .adp file are equivalent to any Access table. The only difference is that the table??™s data are
provided by SQL Server and not by the Access Database Engine.
Pages:
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
2306
2307