Re: Filtering problem - reposted, still need help

my 18 wheeler is better, more nimble, better mileage and easier to
drive than your MDB _CRAP_

stick a mother fucking cork in it RETARD





On Apr 2, 6:17 pm, "Arvin Meyer [MVP]" <a...@xxxxx> wrote:
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, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

"alecwood via AccessMonster.com" <u32921@uwe> wrote in messagenews: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 viahttp://www.accessmonster.com


.