Re: Filtering problem - reposted, still need help

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

Arvin Meyer [MVP] wrote:
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,
not Access/Jet. Once we've settle that, we can go on, because that may
change the way we do a search. Also, you need to supply a bit more code and
information from the error so we can see why the error is occuring..
Hi All

[quoted text clipped - 27 lines]

Can anyone help point me in the right direction?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200704/1

.

Relevant Pages

  • Re: Tables from different databases
    ... I just realised you were talking about an ADP. ... If you use Enterprise Manager, or other such tool, to attach the other ... databases as linked servers, then create distributed views to represent ... > How can I make an ADP qith tables from different sql server databases? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADP Issues
    ... AppRoles are not essential for all situations. ... Databases have been ... AppRoles and ADP: http://support.microsoft.com/kb/308312 ... authority and permissions to Select, Edit, Delete or Insert Data. ...
    (comp.databases.ms-access)
  • VBA
    ... I'm new to Microsoft Access Data Project, but have done .mdb ... databases before. ... Is it true that VBA does not work with .adp? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Create ADP using 2007 fails under Vista
    ... I created an adp using Access 2007 SP1 set for creating new databases in Access 2002-2003 format, ... I found was to click New and then it suggests it will create an .mdb. ...
    (microsoft.public.access.adp.sqlserver)
Loading