The default name for the upsized .adp file is the same as the
current Access database with a CS suffixed.
You could just as easily have decided to simply upsize the tables without making any
changes to the current Access database file. This might be a good option if the intent is to
create copies of the Access tables in SQL Server so that other users, working with other
SQL Server client-side applications can use the same data. However, because the data is
copied to SQL Server, there will be no connection between the data remaining in the
Access application and the data seen by other users.
The SQL Server database created by the Upsizing Wizard is accessible to any qualified
SQL Server user. Just because the data came from Access does not mean that the data can
only be used in an Access context. Other users will be able to access the upsized Access
data using applications written in Visual Studio .NET, Web pages built with ASP .NET,
and any other application able to consume SQL Server data (like SharePoint).
Pages:
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298
2299
2300
2301