TY John,
Turned out the error was being called by a home grown sub routine that was being called from my main program. I am still not entirely certain why it occurred, but moving the call a couple of lines down my initialize code corrected the issue.
TY
Terence
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Terence-
>
> Open the .accde *without* starting the application. To do that, hold down the
> Shift key as you open the database. You should be able to see the Navigation
> Pane. Does it show tables with little arrows next to them? If so, try opening
> one of those objects in Datasheet view to see if the link is working OK.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terence
> Sent: Monday, August 01, 2011 11:43 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Split the DB frontend/backend then make accdb, but
> accdb does not operate proper
>
> OK, a little more info. When I open up the accdb.....(Non locked down front
> end)...In an attempt create an ACCDE....It creates fine, and runs
> fine....HOWEVER, when I close MS office and then attempt to open it up again via
> clicking on the ACCDE...that when I get the issue of not being able to access
> tables...NO message mind you, the applications simply acts like there is NO
> data.
> Terence
>
> --- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@>
> wrote:
> >
> > Wait a moment, I am using access 2007, and creating a object version of the
> frontend, Hence what I am really creating is not an accdb but an accde, is that
> correct ? In any regards , I am still having the issue of the accde NOT seeming
> to be able to access the tables /
> >
> > Terence
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@>
> wrote:
> > >
> > > Splitting a DBm I have done many times, no prob. Creating accdb...I have
> done, does not seem to be a prob. But now I have split the DB (Front end and
> Back end) , and now wish to turn the frontend into an ACCDB...Which I assume is
> an Object format of the Front end....I use the tools and it appears to work
> fine. here is the catch. when I open the ACCDB, it acts as though it cannot
> access the tables ?, forms are there, but code does not seem to respond, AM I
> missing something, like is there some magic about connecting the accdb frontend
> to the tables of the back end ?
> > >
> > > terence
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar