Access 2003 missing the intranet or the website

[Bugs]

Hi

I have distributed an mdb file that works fine on my PC using Access 2003,
but when a copy I sent to someone running Access2003 he gets the error
message "missing the intranet or the website".

This is driving me nuts.

Could anyone please shed some light on what is causing this and any possible
fixes. Very much appreciated.

Thank you.

Joe.

[Br]

Bugs <bu*****@optusnet.com.au> wrote:

Hi

I have distributed an mdb file that works fine on my PC using Access
2003, but when a copy I sent to someone running Access2003 he gets
the error message "missing the intranet or the website".

This is driving me nuts.

Could anyone please shed some light on what is causing this and any
possible fixes. Very much appreciated.

Thank you.

Joe.

Need more information....

eg.

What does the database do?

When does the error occur?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Bugs]

Hi

The database is a record of coins with several datafields with dropdowns and
3 image fields on tabs. It has no need to connect to the internet.

The error happens when the user tries to open it. I have sent him access2000
and access2003 versions and he has tried it on 2 PCs, one running 2000 and
the other 2003. He says he gets the same message on both PCs.

These programs run fine on my PC.

I also have installed the Jet4.0 SP8. Could this possibly be what he needs
to install?

Thanks again.

Cheers.

Joe.
"Br@dley" <n0****@4u.com> wrote in message
news:nJ******************@news-server.bigpond.net.au...

Bugs <bu*****@optusnet.com.au> wrote:

Hi

I have distributed an mdb file that works fine on my PC using Access
2003, but when a copy I sent to someone running Access2003 he gets
the error message "missing the intranet or the website".

This is driving me nuts.

Could anyone please shed some light on what is causing this and any
possible fixes. Very much appreciated.

Thank you.

Joe.

Need more information....

eg.

What does the database do?

When does the error occur?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Br]

Bugs <bu*****@optusnet.com.au> wrote:

Hi

The database is a record of coins with several datafields with
dropdowns and 3 image fields on tabs. It has no need to connect to
the internet.

The error happens when the user tries to open it. I have sent him
access2000 and access2003 versions and he has tried it on 2 PCs, one
running 2000 and the other 2003. He says he gets the same message on
both PCs.

These programs run fine on my PC.

I also have installed the Jet4.0 SP8. Could this possibly be what he
needs to install?
Worth a try! :)

So, there is nothing "special" in the code such as non-standard
references?
"Br@dley" <n0****@4u.com> wrote in message
news:nJ******************@news-server.bigpond.net.au...

Bugs <bu*****@optusnet.com.au> wrote:

Hi

I have distributed an mdb file that works fine on my PC using Access
2003, but when a copy I sent to someone running Access2003 he gets
the error message "missing the intranet or the website".

This is driving me nuts.

Could anyone please shed some light on what is causing this and any
possible fixes. Very much appreciated.

Thank you.

Joe.

Need more information....

eg.

What does the database do?

When does the error occur?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Bugs]

No nothing non standard.


"Br@dley" <n0****@4u.com> wrote in message
news:8R******************@news-server.bigpond.net.au...

Bugs <bu*****@optusnet.com.au> wrote:

Hi

The database is a record of coins with several datafields with
dropdowns and 3 image fields on tabs. It has no need to connect to
the internet.

The error happens when the user tries to open it. I have sent him
access2000 and access2003 versions and he has tried it on 2 PCs, one
running 2000 and the other 2003. He says he gets the same message on
both PCs.

These programs run fine on my PC.

I also have installed the Jet4.0 SP8. Could this possibly be what he
needs to install?

Worth a try! :)

So, there is nothing "special" in the code such as non-standard
references?

"Br@dley" <n0****@4u.com> wrote in message
news:nJ******************@news-server.bigpond.net.au...

Bugs <bu*****@optusnet.com.au> wrote:
Hi

I have distributed an mdb file that works fine on my PC using Access
2003, but when a copy I sent to someone running Access2003 he gets
the error message "missing the intranet or the website".

This is driving me nuts.

Could anyone please shed some light on what is causing this and any
possible fixes. Very much appreciated.

Thank you.

Joe.

Need more information....

eg.

What does the database do?

When does the error occur?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Larry Linson]

On your development copy, in the database window, Tools | References and see
if there are any unexpected references checked that might cause the message
when loaded on a computer without that library.

It is sometimes surprising what kind of "stray" references we sometimes find
in that list (and don't have any idea why they are checked!).

Or, do the same on the computer where you are seeing the error message and
see if any references are marked as "Missing".

Larry Linson
Microsoft Access MVP

"Bugs" <bu*****@optusnet.com.au> wrote in message
news:42**********************@news.optusnet.com.au ...

Hi

I have distributed an mdb file that works fine on my PC using Access 2003,
but when a copy I sent to someone running Access2003 he gets the error
message "missing the intranet or the website".

This is driving me nuts.

Could anyone please shed some light on what is causing this and any
possible
fixes. Very much appreciated.

Thank you.

Joe.

[Br]

Larry Linson <bo*****@localhost.not> wrote:

On your development copy, in the database window, Tools | References
and see if there are any unexpected references checked that might
cause the message when loaded on a computer without that library.

It is sometimes surprising what kind of "stray" references we
sometimes find in that list (and don't have any idea why they are
checked!).
Or, do the same on the computer where you are seeing the error
message and see if any references are marked as "Missing".

Larry Linson
Microsoft Access MVP

Yes, I actually now remember an instance of converting a 97 db to 2000
and it somehow got a reference to some internet thing..... I never
converted after that. Always started with a clean db and imported.

"Bugs" <bu*****@optusnet.com.au> wrote in message
news:42**********************@news.optusnet.com.au ...

Hi

I have distributed an mdb file that works fine on my PC using Access
2003, but when a copy I sent to someone running Access2003 he gets
the error message "missing the intranet or the website".

This is driving me nuts.

Could anyone please shed some light on what is causing this and any
possible
fixes. Very much appreciated.

Thank you.

Joe.

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[David W. Fenton]

"Br@dley" <n0****@4u.com> wrote in
news:qt******************@news-server.bigpond.net.au:

I actually now remember an instance of converting a 97 db to 2000
and it somehow got a reference to some internet thing..... I never
converted after that. Always started with a clean db and imported.

That seems a ludicrous response to an extremely unusual condition.

I have *never* done an import of A97 into A2K -- I've always
converted, and I've never encountered a single problem as a result.

Most of my projects that are in production use with A2K are actually
programmed in A97, so I do this literally 100s of times a year (if
not 1,000s).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Br]

David W. Fenton <dX********@bway.net.invalid> wrote:

"Br@dley" <n0****@4u.com> wrote in
news:qt******************@news-server.bigpond.net.au:

I actually now remember an instance of converting a 97 db to 2000
and it somehow got a reference to some internet thing..... I never
converted after that. Always started with a clean db and imported.

That seems a ludicrous response to an extremely unusual condition.
Well that's your opinion but I've come across enough problems converting
to think otherwise.
I have *never* done an import of A97 into A2K -- I've always
converted, and I've never encountered a single problem as a result.
Good for you.
Most of my projects that are in production use with A2K are actually
programmed in A97, so I do this literally 100s of times a year (if
not 1,000s).

Then you're fortunate. As I said I encountered problems and IMO it's
always better to stat with a fresh DB. Access just does not convert
everything correctly 100% of the time. If you've had no problems then
qudos to you.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Br]

David W. Fenton <dX********@bway.net.invalid> wrote:

"Br@dley" <n0****@4u.com> wrote in
news:qt******************@news-server.bigpond.net.au:

I actually now remember an instance of converting a 97 db to 2000
and it somehow got a reference to some internet thing..... I never
converted after that. Always started with a clean db and imported.

That seems a ludicrous response to an extremely unusual condition.

I have *never* done an import of A97 into A2K -- I've always
converted, and I've never encountered a single problem as a result.

Most of my projects that are in production use with A2K are actually
programmed in A97, so I do this literally 100s of times a year (if
not 1,000s).

And yet MS offers this advice to ppl who can't convert their DB:
If you can't successfully convert your Microsoft Access file by pointing
to Database Utilities on the Tools menu and then clicking the Convert
Database/Project command, use the following procedure.

1.. In Access 2002 or later, click New on the File menu and create a
new Access database (Microsoft Access database: A collection of data and
objects (such as tables, queries, or forms) that is related to a
particular topic or purpose. The Microsoft Jet database engine manages
the data.) or Access project (Microsoft Access project: An Access file
that connects to a Microsoft SQL Server database and is used to create
client/server applications. A project file doesn't contain any data or
data-definition-based objects such as tables and views.).

2.. On the File menu, point to Get External Data and click Import.

3.. In the Import dialog box, select the Access file you want to
convert.

4.. In the Import Objects dialog box, select the database objects
(database objects: An Access database contains objects such as tables,
queries, forms, reports, pages, macros, and modules. An Access project
contains objects such as forms, reports, pages, macros, and modules.)
you want to import. If the new Access file is an Access project that you
have connected to a Microsoft SQL Server database, import only the
forms, reports, pages, macros, and modules.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Larry Linson]

"Br@dley" <n0****@4u.com> wrote

That seems a ludicrous response
to an extremely unusual condition.

Well that's your opinion but I've come
across enough problems converting
to think otherwise.

Like David, I haven't experienced problems, but unlike David, I've converted
very few Access 97 databases to Access 2003. I note that there are enough
issues that Microsoft created and released a/some conversion aids, (mostly |
all) for system administrators in companies doing a mass conversion from 97
to 2003.

And, the fact that David didn't, I didn't, and you did have problems is
perfectly understandable to me, given how touchy software can be to various
system settings that are completely unobvious.

If you regularly run into glitches converting, importing into a new database
seems quite reasonable.

Larry Linson
Microsoft Access MVP