copy active controls when copying databases

[Miskacee]

I copied a database and send it to someone. I thought the active controls
would transfer with the database. The user is getting errors and it looks
like maybe she needs the active control for dates. Is this correct? Maybe
there is a possibility she doesn't have the same .ocx that I have on my PC?
We have the same service pack, SP-3. Mine works, her's does not.

Any help would be greatly appreciated.

 

[Tony Toews [MVP]]

I copied a database and send it to someone. I thought the active controls
would transfer with the database.

No, ActiveX controls never go along with just the MDB/MDE. You need
to give her the controls and register on her system. This is assuming
you have a license to do so and the legal right to do sow.

The user is getting errors and it looks
like maybe she needs the active control for dates. Is this correct?

Correct.

However what ActiveX controls are you using? Maybe you can replace
them with API calls.

How do you get rid of troublesome ActiveX Controls/references?
http://www.granite.ab.ca/access/referencetroubles.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Miskacee]

I really don't know anything about API calls. Will have to do some research.
I'm using Calendar control 9.0 - mscal.ocx

 

[Miskacee]

I am having a copy install in Europe and Asia. I had them install SP-3. So,
from what you are telling me, I need to create instructions for them
installing and registering mscal.ocx?

Maybe you know something about another question I am going to post - SHould
I link or use ODBC connections when using a different service for the front
end than the tables database? Meaning, someone in Utah will have the fron
end of the database and the tables will be located in Missouri. Will I need
to have them link once they receive the database? I couldn't find anywhere
when linking to enter the server path name.

 

[Tony Toews [MVP]]

I really don't know anything about API calls. Will have to do some research.
I'm using Calendar control 9.0 - mscal.ocx

That web page I mentioned has a paragraph on Calendar controls.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

I am having a copy install in Europe and Asia. I had them install SP-3.

SP-3 of what?

So,
from what you are telling me, I need to create instructions for them
installing and registering mscal.ocx?

I would strongly urge you to look at that paragraph on my website and
use a totally different method that doesn't use controls.

Maybe you know something about another question I am going to post - SHould
I link or use ODBC connections when using a different service for the front
end than the tables database?

No idea what you mean by service in this context. Or did you mean
server? Such as SQL Server?

Meaning, someone in Utah will have the fron
end of the database and the tables will be located in Missouri. Will I need
to have them link once they receive the database? I couldn't find anywhere
when linking to enter the server path name.

Does the data reside on a SQL Server system? Or is the backend an
Access MDB?

If SQL Server then using servers not on your local LAN is fine
although you do need to work on performance issues.

If Access then that is strongly not recommended as it will be
painfully slow and prone to corruptions on a very frequent basis.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Miskacee]

Thank you for the information and yes I meant server instead of service. In
the past, I had to 'rig' up the process. By that I mean, I had the remote
locations click a button on their front end (Access) and then retrieve only
data pertaining to their location from a server in another state. Then they
could manipulate their own data locally on their local server. My company
refuses to grant me access to SQL tables so I only have Access tables. The
don't seem to understand the instability and slowness of transferring data
accross a WAN using Access so I have to be creative and find the best way for
other locations to access their data.

Do you agree with me about the above in order for the other loations to
access only their data?

Your opinion is greatly appreciated!

 

[Tony Toews [MVP]]

Thank you for the information and yes I meant server instead of service. In
the past, I had to 'rig' up the process. By that I mean, I had the remote
locations click a button on their front end (Access) and then retrieve only
data pertaining to their location from a server in another state. Then they
could manipulate their own data locally on their local server. My company
refuses to grant me access to SQL tables so I only have Access tables. The
don't seem to understand the instability and slowness of transferring data
accross a WAN using Access so I have to be creative and find the best way for
other locations to access their data.

Do you agree with me about the above in order for the other loations to
access only their data?

Yes, in your situation I guess that's about the only decent solution.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Miskacee]

Maybe you can answer my other question. I spent all day long trying to
explain to someone on this board and it just kept getting further and further
from what my question originally was, etc.

My question: Currently I have a sub-report on various charts/graphs showing
the number of employees and the reason why they are leaving. On the actual
report, I show chart/graphs showing averages. I am using the same
sub-report. based upon what the user selects (drop down list boxes)
determines how the report will be represented. My question is, since I'm
using the same sub-report on all graphs/charts how can I only create one
sub-report and then use a different query for each sub-report, depending upon
what is selected to view? In other words, I know I should not have a record
source on that particular subreport, but I don't know how to reference a
different query for each sub-report on the graphs. Do you know how I can
accomplish this task?

Thanks!

 

[Tony Toews [MVP]]

Maybe you can answer my other question. I spent all day long trying to
explain to someone on this board and it just kept getting further and further
from what my question originally was, etc.

My question: Currently I have a sub-report on various charts/graphs showing
the number of employees and the reason why they are leaving. On the actual
report, I show chart/graphs showing averages. I am using the same
sub-report. based upon what the user selects (drop down list boxes)
determines how the report will be represented. My question is, since I'm
using the same sub-report on all graphs/charts how can I only create one
sub-report and then use a different query for each sub-report, depending upon
what is selected to view? In other words, I know I should not have a record
source on that particular subreport, but I don't know how to reference a
different query for each sub-report on the graphs. Do you know how I can
accomplish this task?

No idea. I'd suggest starting a new thread in the reports newsgroup
with an appropriate subject.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Miskacee]

Thanks. I have no idea wht a newsgroup is and have no idea how your answer
matches what I am asking but thanks for your help anyway.

 

[Tony Toews [MVP]]

Thanks. I have no idea wht a newsgroup is and have no idea how your answer
matches what I am asking but thanks for your help anyway.

Ah, ok. A newsgroup is the fundamental underpinning of the online
forum you are using. I'm coming to this via a totally different means
than you are.

On the screen you are viewing there should be a list of forums on the
left hand side. One of those should be reports.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/