473,323 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Embedded printer addresses

I'm running Access2000
Have a front end app with 20 users scattered around the state with a back end
server db centrally located.
Takes a long time for outlying users to load the app. Eventually a message
"Cannot find the file ('hull') (or one or its components).Make sure the path
and filename correct and that all required librarys are available" displays.
When you OK thru this, the app eventually comes up (sometime 5-10 minutes
total).
In looking inside the app .mdb file, I can see my local network printer
(used in development) address embedded 30-40 times. I'm wondering if my
outlying users app is trying to locate/attach to my development printer and
that is what is causing the error & delay? Any ideas on this? And how would
I prevent the front app from carrying my development printer address.
I'm lost - thanks for any help.

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

Aug 1 '06 #1
8 1431
Depends on if it's being called anywhere on form loads or startup. If
it's being called on a form that's not automatically opened, it's not
going to effect your start-up time.

Why are you embedding printer paths to begin with? At the very least
they should be called from a table, otherwise if your printer gets
hosed and you have to re-route it's going to take days to patch that
database up.

This fully supports the statements I usually make in similar posts
regarding the fact that proper database design isn't as easy as some
people think. A properly designed database would NEVER have printer
paths (or any other paths for that matter) embedded into code.
nrandell via AccessMonster.com wrote:
I'm running Access2000
Have a front end app with 20 users scattered around the state with a back end
server db centrally located.
Takes a long time for outlying users to load the app. Eventually a message
"Cannot find the file ('hull') (or one or its components).Make sure the path
and filename correct and that all required librarys are available" displays.
When you OK thru this, the app eventually comes up (sometime 5-10 minutes
total).
In looking inside the app .mdb file, I can see my local network printer
(used in development) address embedded 30-40 times. I'm wondering if my
outlying users app is trying to locate/attach to my development printer and
that is what is causing the error & delay? Any ideas on this? And how would
I prevent the front app from carrying my development printer address.
I'm lost - thanks for any help.

--
Message posted via http://www.accessmonster.com
Aug 1 '06 #2
Thanks for the response.
But, your question is my question. Why do the printer paths end up in the .
mdb? Thats not my intention. And they are not in any VB code. But I can
see the printer path strings in the .mdb file with a viewer.
Does that help clarify the problem?
Thanks
ManningFan wrote:
>Depends on if it's being called anywhere on form loads or startup. If
it's being called on a form that's not automatically opened, it's not
going to effect your start-up time.

Why are you embedding printer paths to begin with? At the very least
they should be called from a table, otherwise if your printer gets
hosed and you have to re-route it's going to take days to patch that
database up.

This fully supports the statements I usually make in similar posts
regarding the fact that proper database design isn't as easy as some
people think. A properly designed database would NEVER have printer
paths (or any other paths for that matter) embedded into code.
>I'm running Access2000
Have a front end app with 20 users scattered around the state with a back end
[quoted text clipped - 10 lines]
>I prevent the front app from carrying my development printer address.
I'm lost - thanks for any help.
--
Message posted via http://www.accessmonster.com

Aug 1 '06 #3
Thanks for the response.
But, your question is my question. Why do the printer paths end up in the .
mdb? Thats not my intention. And they are not in any VB code. But I can
see the printer path strings in the .mdb file with a viewer.
Does that help clarify the problem?
Thanks
ManningFan wrote:
>Depends on if it's being called anywhere on form loads or startup. If
it's being called on a form that's not automatically opened, it's not
going to effect your start-up time.

Why are you embedding printer paths to begin with? At the very least
they should be called from a table, otherwise if your printer gets
hosed and you have to re-route it's going to take days to patch that
database up.

This fully supports the statements I usually make in similar posts
regarding the fact that proper database design isn't as easy as some
people think. A properly designed database would NEVER have printer
paths (or any other paths for that matter) embedded into code.
>I'm running Access2000
Have a front end app with 20 users scattered around the state with a back end
[quoted text clipped - 10 lines]
>I prevent the front app from carrying my development printer address.
I'm lost - thanks for any help.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

Aug 1 '06 #4
That makes it about as clear as Loch Ness. I've never seen a printer
path embedded in datbase code. What viewer are you using, and what are
the steps you use to view it?

nrandell via AccessMonster.com wrote:
Thanks for the response.
But, your question is my question. Why do the printer paths end up in the .
mdb? Thats not my intention. And they are not in any VB code. But I can
see the printer path strings in the .mdb file with a viewer.
Does that help clarify the problem?
Thanks
Aug 3 '06 #5
I happen to be using PCMags FileSnoop to view the front end .mdb. But you
can even use notepad to search/find the text strings.
The printers I see were used in the development of the associated reports.
In reviewing everything for the umpteenth time, I did find one of the 15
reports was checked to use a specific printer instead of the default printer.
Could this cause the app to try to locate this particular printer (which some
remote users wouldn't have access to) on load and cause the delay and weird
error?
After reviewing everything still again... It appears that doing a Compact and
Repair operation will cleanup all the printer codes in the .mdb.
So, I have some more testing to do.
Thanks for any further thoughts on the subject.

ManningFan wrote:
>That makes it about as clear as Loch Ness. I've never seen a printer
path embedded in datbase code. What viewer are you using, and what are
the steps you use to view it?
>Thanks for the response.
But, your question is my question. Why do the printer paths end up in the .
mdb? Thats not my intention. And they are not in any VB code. But I can
see the printer path strings in the .mdb file with a viewer.
Does that help clarify the problem?
Thanks
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

Aug 3 '06 #6
It is possible that your reports are NOT set to default printer.

As for performance....I don't think a wan will cut your performance
anyway...

I explain about using a wan with ms-access here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 3 '06 #7
A simple way is to design the Reports for the default printer, not for
specific printers (which you have stated are not available to the users,
anyway). Then, do not _print_ the reports directly, but display them in
Preview. Let the user decide to print or not, and to select a specific
printer if they do not want the report printed on their own default printer.

Larry Linson
Microsoft Access MVP

"nrandell via AccessMonster.com" <u24748@uwewrote in message
news:6438c3e65ce53@uwe...
>I happen to be using PCMags FileSnoop to view the front end .mdb. But you
can even use notepad to search/find the text strings.
The printers I see were used in the development of the associated reports.
In reviewing everything for the umpteenth time, I did find one of the 15
reports was checked to use a specific printer instead of the default
printer.
Could this cause the app to try to locate this particular printer (which
some
remote users wouldn't have access to) on load and cause the delay and
weird
error?
After reviewing everything still again... It appears that doing a Compact
and
Repair operation will cleanup all the printer codes in the .mdb.
So, I have some more testing to do.
Thanks for any further thoughts on the subject.

ManningFan wrote:
>>That makes it about as clear as Loch Ness. I've never seen a printer
path embedded in datbase code. What viewer are you using, and what are
the steps you use to view it?
>>Thanks for the response.
But, your question is my question. Why do the printer paths end up in
the .
mdb? Thats not my intention. And they are not in any VB code. But I
can
see the printer path strings in the .mdb file with a viewer.
Does that help clarify the problem?
Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

Aug 3 '06 #8
"Albert D. Kallal" wrote
It is possible that your reports are NOT set to default printer.

As for performance....I don't think a wan will cut your performance
anyway...

I explain about using a wan with ms-access here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
It could work with an Access client to a "server DB" (which is the
terminology that nrandell used earlier in the thread) -- I've worked on an
application that ran in a WAN enviroment using an Access client and a server
Database. It is unlikely to provide satisfactory performance if the
application is simply a split Access-Jet multiuser DB.

Larry Linson
Microsoft Access MVP

Aug 4 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Stephen | last post by:
I have code which checks whether a datagrid is empty and if it is it shows a panel on my page. If its not empty then Im using the server.transfer to go to another page so as im able to use the...
0
by: martinjeffreys | last post by:
Hi I've a number of Access2002 reports with embedded bitmaps. If the printer print quality is set to 'Normal' all prints OK - if 'Fast' only the text appears. I've tried setting the default...
1
by: Zeroeffect | last post by:
Hello! I have a database with alot of embedded images. The reason for having the images embedded is security. My problem is that it works fine on my computer, but not on my clients computer....
1
by: Tom Tempelaere | last post by:
Hi people, Somewhere in the near future I will have to develop a kernel for an industrial printer. Some parts of the kernel have real-time constraints, other parts do not. The kernel should be...
3
by: Joe Thompson | last post by:
Hi, I tried posting this in a different thread a week ago but only received one response so I will try again here. I am writing the code for a program that will run on an embedded PXA255...
5
by: A Lonely Programmer | last post by:
Hi group, Consider the following code: Dim dirinfo As New DirectoryInfo("c:\test") Dim fileinfo() As FileInfo = dirinfo.GetFiles Dim fi As FileInfo
3
by: UltimateNickFury | last post by:
Hello, I am trying to display the "Printer Settings" dialogue in vb.net. I have found the code for performing this in VB6 but am wondering how this is done in vb.net. Thanks.
3
by: Alex | last post by:
Hi everyone, We're trying to write a script that will monitor 6 email addresses and if an email arrives it will print to a specific network printer based on the email address. So if the address...
6
by: Ian | last post by:
I am trying to get MS Access 2000 to print names and addresses onto a Dymo 400 label printer, I have set the Access Report to automatically select the correct printer, then select the label size of...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.