SQL Server, expressions can call code in modules??

Hello,

We have Access databases (backends) that will eventually be
consolidated into a SQL Server database, to facilitate data reporting,
analysis, etc.

Some queries in one Access database front end contain expressions that
reference code in Access modules in the Access front end, primarily the
ones from mvps.org/access that will concatenate data from various
fields in *other* additional tables than the main query table.

Other queries use the Mid function to concatenate field values from
within the same table.

Can such queries be carried over to SQL Server 2005, or will I have to
rewrite those queries somehow??

I have the Chapman/Baron reference book and will be reading that a lot
eventually.

Thank you, Tom

.

Relevant Pages

  • Re: SQL Server, expressions can call code in modules??
    ... We have Access databases that will eventually be ... Other queries use the Mid function to concatenate field values from ... Can such queries be carried over to SQL Server 2005, ... on the SQL Server or you can use a SQL query or SP to return ...
    (comp.databases.ms-access)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server 2000 and Latching problem
    ... While the way we indexed our tables and the way we wrote the queries etc ... "chances are you are getting latches because you are ... query on the results the query .. ... SQL Server 2000 and Latching problem ...
    (microsoft.public.sqlserver.connect)
  • Re: Sql server as back end
    ... There is an option in the Tools menu, Database Utilities, for Upsize to SQL Server. ... But after that, the queries should generally work, shouldn't they? ...
    (microsoft.public.access.tablesdbdesign)