Re: Frontend backend problem
From: G. V. (gv_at_nospam.com)
Date: 01/14/05
- Next message: Dave Columbus: "Backing up a back-end database"
- Previous message: Alex Dybenko: "Re: Can i still get hold of MS Office 2000 Developer Edition?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 14 Jan 2005 10:19:22 -0700
Don
One thing you can do define a standard location for the backend. If it
resides in a folder on the clients server, then mimick that same folder on
your system mapped to the same network drive letter they will be using.
For instance I have a client and although his backend resides on C:\ on his
server, his local machines with the frontend are mapped using the E drive.
All users must use this same mapping drive letter. Luckily on my computer I
have some partioned drives and I can just place the backend on my E drive
directly, which enables me to automatically be linked because my setup
mimicks my clients setup.
If you do this, then your linking problems will be solved. However, you
should still use the code to do an automatic linking. I have not seen the
code you looked at, but implementing the code isn't that difficult and their
may be easier code out there. You might go to Google and do a search for
linking Access tables through code. You just might find step by step
instructions on how to implement.
"don at gypsy" <donatgypsy@discussions.microsoft.com> wrote in message
news:900CE6C2-94EF-4508-886E-F2F00266A393@microsoft.com...
> I went to that URL when you first suggested it and the code overwhelmed
me.
> I have developed some applications such as a billing program that tracks
> advertisers, their ads, the magazines they appear in, costs and
automatically
> bills them also an application that tracks staff development and some
others,
> but I used macros and converted them to code. I avoided writing (or
learning
> to write code). I guess it is time to learn. Can you suggest any
learning
> material for this endeavor? I not only need to learn how to but also I
need
> to learn how to and where to place it into the application. Thanks for
all
> your help. There are still a few people who are patient with us beginners
> and you are one of them. Thanks again.
> Don Miles P.S. I read your Blog and it help clear up some other issues I
> had.
>
> "Brendan Reynolds" wrote:
>
> > In my very first post in this thread, Don, back on the 21st November, I
> > wrote ...
> >
> > <quote>
> > There is code to programmatically relink tables at the following URL ...
> > http://www.mvps.org/access/tables/tbl0009.htm
> > </quote>
> >
> > --
> > Brendan Reynolds (MVP)
> > http://brenreyn.blogspot.com
> >
> > The spammers and script-kiddies have succeeded in making it impossible
for
> > me to use a real e-mail address in public newsgroups. E-mail replies to
> > this post will be deleted without being read. Any e-mail claiming to be
> > from brenreyn at indigo dot ie that is not digitally signed by me with a
> > GlobalSign digital certificate is a forgery and should be deleted
without
> > being read. Follow-up questions should in general be posted to the
> > newsgroup, but if you have a good reason to send me e-mail, you'll find
> > a useable e-mail address at the URL above.
> >
> >
> > "don at gypsy" <donatgypsy@discussions.microsoft.com> wrote in message
> > news:15E35172-D990-4420-AE44-6F5555049026@microsoft.com...
> > > You have hit exactly my problem -- re-linking of the tables. I do not
> > > know
> > > how to do this in the packaged product or when I package the product.
It
> > > is
> > > a very simple application (even for me) that I constructed. It tracks
the
> > > daily money that the small magazine company I work for takes in. It
> > > consists
> > > of only two tables -- Deposits, and How The Money is Categorized. It
> > > consists of 5 queries, a report. and an unbound form for entering
> > > pertinent
> > > info for the day's report. I purchased the Developer's Kit and have
used
> > > only the packager. If I do not split the db -- linclude the tables in
> > > db --
> > > it runs fine on pc with access install. If I split the db -- tables
in
> > > Backend -- package Frontend and run it on a pc with access installed,
it
> > > performs fine, but if I put it on pc without access installed it
allows me
> > > to
> > > enter info in unbound form but when I press the command button to call
up
> > > the
> > > report it gives me the following message: DEPOSITS can't find the
> > > wizard, or the wizard has not been installed, or there is a syntax
error
> > > in
> > > the Declarations section of a Visual Basic module
> > > I believe there is something in the packaging process that I am not
doing
> > > or
> > > doing incorrectly.
> > > Thanks for staying with me on this.
> > > Don Miles
> > >
> > > "Brendan Reynolds" wrote:
> > >
> > >> Have you sorted out the re-linking of the tables? If you haven't,
then
> > >> obviously reporting isn't going to work, as the data will not be
> > >> available
> > >> to the report.
> > >>
> > >> The only thing that the code you posted does is to display a report
named
> > >> 'Report1' in preview mode. That means there's very little that can go
> > >> wrong
> > >> with the code itself, about the only thing that could go wrong is
that
> > >> the
> > >> report may have been renamed. If the data is available, and the
report
> > >> has
> > >> not been renamed, then the problem is probably in the report rather
than
> > >> in
> > >> the code that attempts to display it.
> > >>
> > >> If you're still stuck, try giving a little more detail about what
happens
> > >> when you click that button. Is there an error message?
> > >>
> > >> In an earlier post, you mentioned that you felt you might be 'in over
> > >> your
> > >> head'. With respect, it does rather look as though you are 'jumping
in at
> > >> the deep end'. Developing Access applications for the use of others,
even
> > >> others who have retail Access installed, is quite a significant
increase
> > >> in
> > >> complexity beyond developing applications for your own use, on your
own
> > >> system. Add the runtime into the mix, and you add yet more
complexity. If
> > >> at
> > >> all possible, I would recommend gaining more experience and/or
training
> > >> before attempting to deploy runtime applications for the use of
others.
> > >>
> > >> --
> > >> Brendan Reynolds (MVP)
> > >> http://brenreyn.blogspot.com
> > >>
> > >> The spammers and script-kiddies have succeeded in making it
impossible
> > >> for
> > >> me to use a real e-mail address in public newsgroups. E-mail replies
to
> > >> this post will be deleted without being read. Any e-mail claiming to
be
> > >> from brenreyn at indigo dot ie that is not digitally signed by me
with a
> > >> GlobalSign digital certificate is a forgery and should be deleted
without
> > >> being read. Follow-up questions should in general be posted to the
> > >> newsgroup, but if you have a good reason to send me e-mail, you'll
find
> > >> a useable e-mail address at the URL above.
> > >>
> > >>
> > >> "don at gypsy" <donatgypsy@discussions.microsoft.com> wrote in
message
> > >> news:13803CDD-4758-4175-8AC8-F337272DE399@microsoft.com...
> > >> > The ok button from the input unbound form is
> > >> > Private Sub Command52_Click()
> > >> > On Error GoTo Err_Command52_Click
> > >> >
> > >> > Dim stDocName As String
> > >> >
> > >> > stDocName="Report1"
> > >> > DoCmd.OpenReport stDocName, acPreview
> > >> >
> > >> > Exit_Command52_Click:
> > >> > MsgBox Err.Description
> > >> > Resume Exit_Command52_Click
> > >> >
> > >> > When I have the split db (frontend run throungh packager, backend
> > >> > tables
> > >> > is
> > >> > not packaged) installed on a computer without Access, the only
command
> > >> > buttons that work are the stop button and the go to unbound form
> > >> > button.
> > >> > A
> > >> > button to go to table link manger does not work (you have ans. that
> > >> > question). A button to go to a table I have does not work. The
> > >> > command
> > >> > button on the unbound form (code above) does not work. If I do not
> > >> > split
> > >> > the
> > >> > db and package it every thing works except, of course, the table
link
> > >> > manager. Is there something different to be done in packaging a
split
> > >> > db?
> > >> > Could it be I am not including something in the dependency files?
> > >> > Thanks
> > >> > for
> > >> > your help and patience. Don
> > >> > Exit Sub
> > >> >
> > >> > Err_Command52_Click:
> > >> >
> > >> >
> > >> > "Brendan Reynolds" wrote:
> > >> >
> > >> >> I would need to see the code before I could offer any suggestion.
> > >> >>
> > >> >> --
> > >> >> Brendan Reynolds (MVP)
> > >> >> http://brenreyn.blogspot.com
> > >> >>
> > >> >> The spammers and script-kiddies have succeeded in making it
impossible
> > >> >> for
> > >> >> me to use a real e-mail address in public newsgroups. E-mail
replies
> > >> >> to
> > >> >> this post will be deleted without being read. Any e-mail claiming
to
> > >> >> be
> > >> >> from brenreyn at indigo dot ie that is not digitally signed by me
with
> > >> >> a
> > >> >> GlobalSign digital certificate is a forgery and should be deleted
> > >> >> without
> > >> >> being read. Follow-up questions should in general be posted to the
> > >> >> newsgroup, but if you have a good reason to send me e-mail, you'll
> > >> >> find
> > >> >> a useable e-mail address at the URL above.
> > >> >>
> > >> >>
> > >> >> "don at gypsy" <donatgypsy@discussions.microsoft.com> wrote in
message
> > >> >> news:9ABD7CD4-6F5D-45BA-9D82-846AA3448D7B@microsoft.com...
> > >> >> > Yes, I was trying to go to the table linker. Thank you, that
> > >> >> > answered
> > >> >> > one
> > >> >> > of
> > >> >> > my problems. The other problem is that when the db opens an
unbound
> > >> >> > form
> > >> >> > comes up. I can input data but when I press the OK button I
created
> > >> >> > to
> > >> >> > use
> > >> >> > this data along with in table info to produce the report it will
not
> > >> >> > work.
> > >> >> > Any more suggestions. I am in over my head and can not help but
> > >> >> > think
> > >> >> > that I
> > >> >> > am missing something very basic. Thanks again
> > >> >> >
> > >> >> > "don at gypsy" wrote:
> > >> >> >
> > >> >> >> I have 2002 access and the developer packager. When I run the
> > >> >> >> frontend
> > >> >> >> db
> > >> >> >> application I have created through the packager and then run
the
> > >> >> >> packaged
> > >> >> >> application on a pc that has access installed, everything works
ok,
> > >> >> >> but
> > >> >> >> when
> > >> >> >> I install the frontend and backend on a pc that does not have
> > >> >> >> access,
> > >> >> >> the
> > >> >> >> frontend can not find the backend -- the forms etc. in the
frontend
> > >> >> >> all
> > >> >> >> display properly. The backend consists of only tables, which I
> > >> >> >> have
> > >> >> >> installed in the properly named folders and files. If I do
not
> > >> >> >> split
> > >> >> >> the
> > >> >> >> database, the packaged version works find on a pc without
Access
> > >> >> >> install.
> > >> >> >> I get the following errors (split db) when I try to open the
macro
> > >> >> >> that
> > >> >> >> opens the table linker or the macro that runs the queries. The
> > >> >> >> expression
> > >> >> >> may not result in the name of a macro, the name of a
user-defined
> > >> >> >> function,
> > >> >> >> or [Event Procedure],
> > >> >> >> *There may have been an error evaluating the function, event,
or
> > >> >> >> macro
> > >> >> >> Another error message I get when I press a button is DEPOSITS
can't
> > >> >> >> find
> > >> >> >> the
> > >> >> >> wizard, or the wizard has not been installed, or there is a
syntax
> > >> >> >> error
> > >> >> >> in
> > >> >> >> the Declarations section of a Visual Basic module. Sometimes
I
> > >> >> >> get
> > >> >> >> Runtime
> > >> >> >> error 75 message
> > >> >> >> Thanks for any help
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >
- Next message: Dave Columbus: "Backing up a back-end database"
- Previous message: Alex Dybenko: "Re: Can i still get hold of MS Office 2000 Developer Edition?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
