Re: Upsize to SQL Server

In message <1131968189.797295.285650@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>, lylefair <lylefairfield@xxxxxxx> writes 
IMO there is no good way to use MS-Access with MS-SQL Server.
A satisfactory way might be to use a disconnected ADP (a disconnected
MDB is unlikely to be a lot different) and unbound Forms and Reports,
or Forms and Reports bound to ADO recordsets (often disconnected). But
this method does not fit with the RAD notion of Access.
I've not worked with MDB-ODBC-MS-SQL Server. Perhaps, I should. I feel
that with such a model, it will not be easy for me to use the power of
T-SQL; I feel uneasy about interjecting an additional connection layer
between the app and the db; I feel uneasy about the many posts here
about problems associated with this model.

Access is a very popular program, lots of people use it therefore lots of people can be expected to have problems with it.

Personally, I have used MDB-ODBC-SQL for a lot of small projects and I haven't had any real problems with it. It's quite easy to develop an application using local Access tables then switch it to attached SQL tables. I use T-SQL when it gives me some positive advantage over Access, enough of an advantage to justify the extra work. I can either use T-SQL on the server to create a view or I can write a pass-through query in Access and send raw SQL up to the server.



--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

.

Relevant Pages

  • Re: db restore + transaktionsprotokoll
    ... >> angenommen der server geht kaputt. ... >> nun wie kann ich das via enterprise manager wiederherstellen? ... > verwende T-SQL. ... Dann kannst Du als Rücksicherung from ...
    (microsoft.public.de.sqlserver)
  • Re: Custom Row Functions: Access vs. SQL Server
    ... When compared with other "time" issues like the speed of data over the wire, what other tasks the server might be performing when you ask it to call the function etc, I think I am not going to worry about it, barring Steve coming up with something I have overlooked. ... Is T-SQL really that slow? ... performance is great, but Access works slightly better with the MS SQL Server back-end, and you have to make sure your ODBC settings are just right, for PostgreSQL to work correctly with Access on the front-end. ...
    (comp.databases.ms-access)
  • Re: CONTAINS "irgendwas"?
    ... Aus irgendeinem Grund kann ich nach Auswahl des fraglichen Feldes als Operator nur noch ausschließlich "contains" oder "does not contain" verwenden. ... hast Du einmal einen SQL Server Trace gestartet und beobachtet, was an den Server tatsächlich als T-SQL Statement geschickt wird, wenn Du Deine Eingaben machst. ...
    (microsoft.public.de.sqlserver)
  • Re: Problem with big data transfer
    ... DTS and T-SQL to "transfer" data from one location to ... server) and DTS for server-server transfer. ... > With more than 90000 records, the server hangs. ...
    (microsoft.public.sqlserver.clients)
  • Re: Binäre Datei per T-SQL in image-Datentyp umwandeln
    ... >> Kopie der Datei auf ein vom Server und Client erreichbares Verzeichnis ... dass es in T-SQL auch nicht vorgesehen ist. ...
    (microsoft.public.de.sqlserver)