Unsafe data provider/using ID to access a data source

[Creator of things beyond my pay grade]

I am a bit of an Access newbie here so please bare with me. I've been tasked
with building a DB, I've got the basics figured out but when I go to run the
Data Access Page I get two errors.

First is warning me that data provider may be unsafe, then that my ID is
being used to access a data source. Both prompt me to click OK if I trust the
site. My problem is I need to make this a company wide DB that will be
accessed by the less than tech savy and the bosses want the errors to go away.

Now from what I've read on various forums, the nice easy fix is to just add
the site to the Trusted Sites in IE, that would be all well and good except
our current parent company has us locked down all sorts of tight and even our
IT guys don't have the power to do that, let alone give us the access to do
it. The only other option I've seen is a suggestion to edit the registry, and
that a) seems kinda shady to me and b) if management caught wind of us doing
that my supervisors and I would likely be headed to the unempolyment line.

Is there any other way to work around this? The idea of creating our own
certificate hs been discussed but if that would even work/the real know how
to do it is lacking.

Thanks in advance,

Sam
/+1 giant block of text reading skill

 

[Beetle]

I don't now much about DAP's because I've never used them. I also
don't recall seeing any of the experts in the newsgroups ever actually
recommend using them. From the feedback I've seen, they never really
worked that well. That feature showed in up Access 2002/2003 (I believe)
and was eliminated in the following version.

What I'm getting at is there may be a better way to do what you
need, but for someone to make a good recommendation it would help
to know a bit more.

What do you mean by "company wide", in other words, how widespread
is your company?

What is the nature of your network as far as it relates to the personnel
that will be using the application? Is it LAN, WAN, Internet, VPN?

Does your company have SQL Server, or some other enterprise level
db software that could be used as the backend?

Is Terminal Services an option for you (your IT guys should know)?

There are many responders in this group who are more qualified than I am
to point you in the right direction, I'm only suggesting that you provide
some more information regarding your specific circumstances, and someone
will probably be able to offer you some good advice.

 

[Creator of things beyond my pay grade]

Thanks for the quick reply, as for more info, here goes.

Company wide - The DB, if all goes well, will contain gift information for
our product line.
-Gift Name and Number and then provide a hyperlink to our pre-existing
Intranet page.

It's for our Customer Assistance department and would need to be accessed at
least by anyone here at our corperate HQ and idealy at several satalite
sites, probably a max of five total sites.

What is wanted is a DB to integrate into our Intranet to search the site so
the CA agents can have access to the specific info they need as opposed to
going through catagory lists with thousands of items in them.

Idealy we would just build a search feature into the site, we have tried
it but the search function was created with FP and didn't translate nice into
Expressions, and again I'm fairly inexperieced with Expressions, so it is
possible there is a way in Expressions to make this nice and simple but I
have no idea how and can't find any documentation on it either.
Along those lines purchasing a pre built search box is pretty much out of
the question at the moment unless it was extremely cheap, we are currently
going through the process of being sold and managment wants to keep our
numbers high.

Access to a SQL server is doubful, same with Terminal Services, but anyone
who could give me that info for sure is out to lunch right now. Though I will
look into it when they are back.

Thanks for getting back to me and providing me with some new avenues to
wander down and check out.

Sam