upsizing to sql 2005

[Guest]

Hopefully only one more question. When I click on the upsizing wizzard,
choose my tables, then choose validate, etc., then choose link SQL server
tables to existing application. When this is complete which table do I add
new records to? One one that says link or the original one?

Thank you
Dee

 

[Guest]

Another questions: Can more then one person work on the database from Access
and how does it update the SQL database with the new records in Access?

Thanks
Dee

 

[Michel Walsh]

Yes, from that moment, you add data through the link of the linked table,
so, in this case, into MS SQL Server.

A NOT linked table would store the data locally, though.


Vanderghast, Access MVP

 

[Michel Walsh]

If the database is on a standard Windows PC, a maximum of 10 connections is
allowed (a limitation from Windows). On a server, an Operating System with
the word SERVER in it, the maximum is configurable.


You can access to the database by multiple means (Access, Dot-Net
application, administration tools, ... ) and each mean can be launched by
multiple users,. in principle, unless someone decides to LOCK the data.


Access won't store anything, it will just act as a window to your data (from
a linked table). Access stores data locally only if the table is NATIVE to
your application (not linked).


Vanderghast, Access MVP

 

[Guest]

Michel,

Thank you. You have been of great help. I will forward this information to
my manager so we can decide which way to go.

If I have any more questions I will post here under a new post.

Again thank you
Dee

 

[Guest]

Sorry, One more question:

The input for the records are done from the queries. If I do a link to the
sql server, could it work that way. Can the input still be done in the query
part of access and not in the adp?

 

[Michel Walsh]

A query in Access-Jet will be started and under the supervision of Jet, with
Jet syntax parsing and evaluation. If the Jet-query involves a linked table,
Jet communicates (through ODBC or otherwise) to the not-Jet-native data
storage, transparently.

Vanderghast, Access MVP