Re: Filtering problem - reposted, still need help

If you wrote your original search functions in DAO, you are out of luck.
You'll need to rewrite them in ADO. Sorry no shortcuts.

Just for your edification, Microsoft now recommends using MDBs (and
presumably DAO) when accessing SQL-Server data. ADPs will still work, and
should for some time, but they will not be making and upgrades for them. ADO
has been replaced by ADO.NET and I expect it will go the way of RDO.

The advice to upscale may have been premature. There are certainly some real
advantages to using a SQL-Server back-end, but sometimes a VW is better
suited to a task than an 18 wheeler.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"alecwood via AccessMonster.com" <u32921@uwe> wrote in message
news:701a6dbd7ff25@xxxxxx
"Disconnected databases" LOL, sorry I meant recordsets.......



alecwood wrote:
Sorry, I guess I wasn't clear enough

It was Access front end and back end, split database, two .mdb files. In
all
cases the forms were bound to tables or queries as very basic access
databases written by noobs tend to be LOL.

Following advice I upscaled, so now I have an ADP front end and the
upscaled
tables on an instance of SQL server.

I used the upsizing wizard to do the job, corrected the problems it found
and
now I can see and add records, but my previously working search functions
just don't.

I'm just trying to find an alternative to shore it up in the interim. I
appreciate what I want is unbound forms, disconnected databases and good
VBA
code running behind them, but I don't want to sit up until midnight every
night with a laptop to get it done, which is what it would take at my
level
of knowledge.

If I can shore it up with a temp solution then I can recode properly at
leisure, and hopefully do a better job.

Alec

First, you say that you are running an Access front-end to an Access
back-end. Then you add that this is an ADP. ADP back-ends are SQL-Server,
[quoted text clipped - 6 lines]

Can anyone help point me in the right direction?

--
Message posted via http://www.accessmonster.com



.

Relevant Pages

  • Re: ADO VS. DAO
    ... DAO is superior to ADO when using Jet data. ... It's not a matter of whether it's an ADP or an MDB, ...
    (comp.databases.ms-access)
  • Re: What is the best way to work with SQL SERVER data / tables?
    ... So by this do you mean manipulating the views from within Access ADP ... ADO and DAO. ... I read somewhere where ADO may not be as flexible as DAO. ... the potential it will have with SQL Server while ...
    (comp.databases.ms-access)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... code and connect to a single SQL Server database, ... If you run into issues with the ADP solution, ... First they recommended DAO, then ADO, and now DAO again. ...
    (microsoft.public.sqlserver.connect)
  • Re: Recordset ? defaults mdb->DAO, adp->ADO
    ... >> Why does the form recordset seem to default to DAO in an MDB and ADO ... > Because in an MDB, Access uses DAO to manage the data, while in an ADP ...
    (microsoft.public.access.forms)
  • Re: Converting Application from ADP to ACCDB
    ... to a stored procedure that I know of is with ADP. ... I hadn't considered using a disconnected ADO recordset and trying to bind ... with using an ACCDB database file instead of an ADP project. ...
    (microsoft.public.access.adp.sqlserver)
Loading