Ms-Access 2003

Hi everyone,

Wondering if anyone out there has encountered this kind of problem.

I am in the process of migrating my client (they were running Windwows NT
4.5 SBS and MS-Access 2000 database) to a brand new server running Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access 2000. After
successfully transferring the data and installing MS-Access 2003 on the
desktops (the database files are on the server), if I try to double-click the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently Unrecognized. Please
reset your short Date Format to the U.S. Short Date Format (ie 'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server as well as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

I don't think that's an Access error message. I think that's something the
developer has built in to these apps. To test this theory, could you try the
sample app, Northwind? Can you open it, under the same conditions, without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of problem.

I am in the process of migrating my client (they were running Windwows NT
4.5 SBS and MS-Access 2000 database) to a brand new server running Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access 2000.
After
successfully transferring the data and installing MS-Access 2003 on the
desktops (the database files are on the server), if I try to double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server as well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their application? The
desktops are all XP Pro Sp2 (just fyi). In case your theory is correct - how
can I get my client back on their feet with this application? Throw in the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's something the
developer has built in to these apps. To test this theory, could you try the
sample app, Northwind? Can you open it, under the same conditions, without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of problem.

I am in the process of migrating my client (they were running Windwows NT
4.5 SBS and MS-Access 2000 database) to a brand new server running Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access 2000.
After
successfully transferring the data and installing MS-Access 2003 on the
desktops (the database files are on the server), if I try to double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server as well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

There should not usually be any need for Access to be installed *on the
server* no.

If my theory is correct, then the solution will depend on how, where, and
why the developer did this. Let's establish whether the theory is correct
before we go too far down that road, though! :-)

--
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.


"RC" wrote in message
...
Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their application? The
desktops are all XP Pro Sp2 (just fyi). In case your theory is correct -
how
can I get my client back on their feet with this application? Throw in the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's something
the
developer has built in to these apps. To test this theory, could you try
the
sample app, Northwind? Can you open it, under the same conditions,
without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of problem.

I am in the process of migrating my client (they were running Windwows
NT
4.5 SBS and MS-Access 2000 database) to a brand new server running
Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access 2000.
After
successfully transferring the data and installing MS-Access 2003 on the
desktops (the database files are on the server), if I try to
double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server as
well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

Hi Brendan,
Just got off the phone with the client. They are able to open the sample
database on their desktops without gettting the error message.
What should I do next?
Regards

"Brendan Reynolds" wrote:

There should not usually be any need for Access to be installed *on the
server* no.

If my theory is correct, then the solution will depend on how, where, and
why the developer did this. Let's establish whether the theory is correct
before we go too far down that road, though! :-)

--
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.


"RC" wrote in message
...
Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their application? The
desktops are all XP Pro Sp2 (just fyi). In case your theory is correct -
how
can I get my client back on their feet with this application? Throw in the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's something
the
developer has built in to these apps. To test this theory, could you try
the
sample app, Northwind? Can you open it, under the same conditions,
without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of problem.

I am in the process of migrating my client (they were running Windwows
NT
4.5 SBS and MS-Access 2000 database) to a brand new server running
Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access 2000.
After
successfully transferring the data and installing MS-Access 2003 on the
desktops (the database files are on the server), if I try to
double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server as
well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

The safest option would be to do nothing until you talk to the person who
developed the applications. But I'm guessing that person is no longer
available?

Well then, when an Access application starts, it will look for a macro
called AutoExec, and if it finds one, it will run it. If a start-up form or
data access page has been defined (Tools, Startup, Display Form/Page) Access
will open that form or data access page and run any code in the various
event procedures that are fired when the object opens. For example, a form's
Open, Load, and Activate events will fire, and any code in the Open, Load
and Activate event procedures will run. So those are the places to start
looking.

If there are both an AutoExec macro and a startup form or data access page,
they'll both be executed.

Look for an AutoExec macro. Look for the text of the message there. Select
Startup from the Tools menu. Does the 'Display Form/Page' combo box say
'(none)' or does it display the name of a form or data access page? If the
latter, open that form or data access page in design view and look for the
message there.

Although less likely, it is also possible that the code may be in a function
that is called from a query, for example a query that forms the record
source of a startup form.

I probably don't need to tell you this, but let's err on the side of caution
anyway - make sure you have a recent, reliable back up before you change
anything. Make one change at a time, and test thoroughly before making any
further changes.

--
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.


"RC" wrote in message
...
Hi Brendan,
Just got off the phone with the client. They are able to open the sample
database on their desktops without gettting the error message.
What should I do next?
Regards

"Brendan Reynolds" wrote:

There should not usually be any need for Access to be installed *on the
server* no.

If my theory is correct, then the solution will depend on how, where, and
why the developer did this. Let's establish whether the theory is correct
before we go too far down that road, though! :-)

--
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.


"RC" wrote in message
...
Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their application?
The
desktops are all XP Pro Sp2 (just fyi). In case your theory is
correct -
how
can I get my client back on their feet with this application? Throw in
the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's something
the
developer has built in to these apps. To test this theory, could you
try
the
sample app, Northwind? Can you open it, under the same conditions,
without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of problem.

I am in the process of migrating my client (they were running
Windwows
NT
4.5 SBS and MS-Access 2000 database) to a brand new server running
Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access
2000.
After
successfully transferring the data and installing MS-Access 2003 on
the
desktops (the database files are on the server), if I try to
double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server as
well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

Hi Brendan,
Thanks for the suggestions. Yes the developer is no longer available.
The process that you are talking about - to check the Tools--Startup etc.
is to be carried out on the old machine I presume. So in case I do find
anything in the Display Form/Page where should I copy this into.
The problem is Brendan I am a systems admin guy with little or no knowledge
of programming.
On the local desktops (I checked this on mine in my office) when there is no
file open the Startup option is dimmed. So when I go to my client site today,
I will open the app on the server and see what are the options - if any -
defined there.
Thanks for all your help.

Regards

"Brendan Reynolds" wrote:

The safest option would be to do nothing until you talk to the person who
developed the applications. But I'm guessing that person is no longer
available?

Well then, when an Access application starts, it will look for a macro
called AutoExec, and if it finds one, it will run it. If a start-up form or
data access page has been defined (Tools, Startup, Display Form/Page) Access
will open that form or data access page and run any code in the various
event procedures that are fired when the object opens. For example, a form's
Open, Load, and Activate events will fire, and any code in the Open, Load
and Activate event procedures will run. So those are the places to start
looking.

If there are both an AutoExec macro and a startup form or data access page,
they'll both be executed.

Look for an AutoExec macro. Look for the text of the message there. Select
Startup from the Tools menu. Does the 'Display Form/Page' combo box say
'(none)' or does it display the name of a form or data access page? If the
latter, open that form or data access page in design view and look for the
message there.

Although less likely, it is also possible that the code may be in a function
that is called from a query, for example a query that forms the record
source of a startup form.

I probably don't need to tell you this, but let's err on the side of caution
anyway - make sure you have a recent, reliable back up before you change
anything. Make one change at a time, and test thoroughly before making any
further changes.

--
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.


"RC" wrote in message
...
Hi Brendan,
Just got off the phone with the client. They are able to open the sample
database on their desktops without gettting the error message.
What should I do next?
Regards

"Brendan Reynolds" wrote:

There should not usually be any need for Access to be installed *on the
server* no.

If my theory is correct, then the solution will depend on how, where, and
why the developer did this. Let's establish whether the theory is correct
before we go too far down that road, though! :-)

--
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.


"RC" wrote in message
...
Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their application?
The
desktops are all XP Pro Sp2 (just fyi). In case your theory is
correct -
how
can I get my client back on their feet with this application? Throw in
the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's something
the
developer has built in to these apps. To test this theory, could you
try
the
sample app, Northwind? Can you open it, under the same conditions,
without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of problem.

I am in the process of migrating my client (they were running
Windwows
NT
4.5 SBS and MS-Access 2000 database) to a brand new server running
Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access
2000.
After
successfully transferring the data and installing MS-Access 2003 on
the
desktops (the database files are on the server), if I try to
double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server as
well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

Responses inline ...

--
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.

"RC" wrote in message
...
Hi Brendan,
Thanks for the suggestions. Yes the developer is no longer available.
The process that you are talking about - to check the Tools--Startup etc.
is to be carried out on the old machine I presume.

It doesn't matter. The problem is, as far as I can tell, in the application.

So in case I do find
anything in the Display Form/Page where should I copy this into.

It's not a question of copying it, it's a question of fixing it.

The problem is Brendan I am a systems admin guy with little or no
knowledge
of programming.

This doesn't appear to be a configuration issue. It appears to be a
programming issue. You would be well advised, therefore, to ask a programmer
to have a look at it. (OK, that's what you're doing here, but I mean at
first hand! :-)

On the local desktops (I checked this on mine in my office) when there is
no
file open the Startup option is dimmed.

That's correct, the option is disabled until you open a file.

So when I go to my client site today,
I will open the app on the server and see what are the options - if any -
defined there.

Let us know what you find, and we may be able to offer further suggestions
then.

Thanks for all your help.

Regards

"Brendan Reynolds" wrote:

The safest option would be to do nothing until you talk to the person who
developed the applications. But I'm guessing that person is no longer
available?

Well then, when an Access application starts, it will look for a macro
called AutoExec, and if it finds one, it will run it. If a start-up form
or
data access page has been defined (Tools, Startup, Display Form/Page)
Access
will open that form or data access page and run any code in the various
event procedures that are fired when the object opens. For example, a
form's
Open, Load, and Activate events will fire, and any code in the Open, Load
and Activate event procedures will run. So those are the places to start
looking.

If there are both an AutoExec macro and a startup form or data access
page,
they'll both be executed.

Look for an AutoExec macro. Look for the text of the message there.
Select
Startup from the Tools menu. Does the 'Display Form/Page' combo box say
'(none)' or does it display the name of a form or data access page? If
the
latter, open that form or data access page in design view and look for
the
message there.

Although less likely, it is also possible that the code may be in a
function
that is called from a query, for example a query that forms the record
source of a startup form.

I probably don't need to tell you this, but let's err on the side of
caution
anyway - make sure you have a recent, reliable back up before you change
anything. Make one change at a time, and test thoroughly before making
any
further changes.

--
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.


"RC" wrote in message
...
Hi Brendan,
Just got off the phone with the client. They are able to open the
sample
database on their desktops without gettting the error message.
What should I do next?
Regards

"Brendan Reynolds" wrote:

There should not usually be any need for Access to be installed *on
the
server* no.

If my theory is correct, then the solution will depend on how, where,
and
why the developer did this. Let's establish whether the theory is
correct
before we go too far down that road, though! :-)

--
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.


"RC" wrote in message
...
Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their
application?
The
desktops are all XP Pro Sp2 (just fyi). In case your theory is
correct -
how
can I get my client back on their feet with this application? Throw
in
the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's
something
the
developer has built in to these apps. To test this theory, could
you
try
the
sample app, Northwind? Can you open it, under the same conditions,
without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of
problem.

I am in the process of migrating my client (they were running
Windwows
NT
4.5 SBS and MS-Access 2000 database) to a brand new server
running
Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access
2000.
After
successfully transferring the data and installing MS-Access 2003
on
the
desktops (the database files are on the server), if I try to
double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently
Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server
as
well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

Hi Brendan,
I am at hte client site right now. I tried to go through what you had
suggested. However the option under Display Form/Page is set to none. I even
tried to map a drive on the user's new desktop to the old server and run the
application. I got the same error message. I copied the mdb file to my
machine in the office and still the problem persists. Is there any other file
that needs to be checked. The mdb file is 3 Mb but there is a name_be.mdb
file that is more than 230 MB.

Thanks and regards

"Brendan Reynolds" wrote:

Responses inline ...

--
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.

"RC" wrote in message
...
Hi Brendan,
Thanks for the suggestions. Yes the developer is no longer available.
The process that you are talking about - to check the Tools--Startup etc.
is to be carried out on the old machine I presume.

It doesn't matter. The problem is, as far as I can tell, in the application.

So in case I do find
anything in the Display Form/Page where should I copy this into.

It's not a question of copying it, it's a question of fixing it.

The problem is Brendan I am a systems admin guy with little or no
knowledge
of programming.

This doesn't appear to be a configuration issue. It appears to be a
programming issue. You would be well advised, therefore, to ask a programmer
to have a look at it. (OK, that's what you're doing here, but I mean at
first hand! :-)

On the local desktops (I checked this on mine in my office) when there is
no
file open the Startup option is dimmed.

That's correct, the option is disabled until you open a file.

So when I go to my client site today,
I will open the app on the server and see what are the options - if any -
defined there.

Let us know what you find, and we may be able to offer further suggestions
then.

Thanks for all your help.

Regards

"Brendan Reynolds" wrote:

The safest option would be to do nothing until you talk to the person who
developed the applications. But I'm guessing that person is no longer
available?

Well then, when an Access application starts, it will look for a macro
called AutoExec, and if it finds one, it will run it. If a start-up form
or
data access page has been defined (Tools, Startup, Display Form/Page)
Access
will open that form or data access page and run any code in the various
event procedures that are fired when the object opens. For example, a
form's
Open, Load, and Activate events will fire, and any code in the Open, Load
and Activate event procedures will run. So those are the places to start
looking.

If there are both an AutoExec macro and a startup form or data access
page,
they'll both be executed.

Look for an AutoExec macro. Look for the text of the message there.
Select
Startup from the Tools menu. Does the 'Display Form/Page' combo box say
'(none)' or does it display the name of a form or data access page? If
the
latter, open that form or data access page in design view and look for
the
message there.

Although less likely, it is also possible that the code may be in a
function
that is called from a query, for example a query that forms the record
source of a startup form.

I probably don't need to tell you this, but let's err on the side of
caution
anyway - make sure you have a recent, reliable back up before you change
anything. Make one change at a time, and test thoroughly before making
any
further changes.

--
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.


"RC" wrote in message
...
Hi Brendan,
Just got off the phone with the client. They are able to open the
sample
database on their desktops without gettting the error message.
What should I do next?
Regards

"Brendan Reynolds" wrote:

There should not usually be any need for Access to be installed *on
the
server* no.

If my theory is correct, then the solution will depend on how, where,
and
why the developer did this. Let's establish whether the theory is
correct
before we go too far down that road, though! :-)

--
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.


"RC" wrote in message
...
Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their
application?
The
desktops are all XP Pro Sp2 (just fyi). In case your theory is
correct -
how
can I get my client back on their feet with this application? Throw
in
the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's
something
the
developer has built in to these apps. To test this theory, could
you
try
the
sample app, Northwind? Can you open it, under the same conditions,
without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of
problem.

I am in the process of migrating my client (they were running
Windwows
NT
4.5 SBS and MS-Access 2000 database) to a brand new server
running
Windows
2003 SBS with MS-Access 2003. The had an application in MS-Access
2000.
After
successfully transferring the data and installing MS-Access 2003
on
the
desktops (the database files are on the server), if I try to
double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently
Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format (ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the server
as
well
as
the desktops. However I am still uanble to open the application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi

Is there a macro named AutoExec?

The _be file will be the 'back-end' data file, the problem is unlikely to be
there.

--
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.


"RC" wrote in message
...
Hi Brendan,
I am at hte client site right now. I tried to go through what you had
suggested. However the option under Display Form/Page is set to none. I
even
tried to map a drive on the user's new desktop to the old server and run
the
application. I got the same error message. I copied the mdb file to my
machine in the office and still the problem persists. Is there any other
file
that needs to be checked. The mdb file is 3 Mb but there is a name_be.mdb
file that is more than 230 MB.

Thanks and regards

"Brendan Reynolds" wrote:

Responses inline ...

--
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.

"RC" wrote in message
...
Hi Brendan,
Thanks for the suggestions. Yes the developer is no longer available.
The process that you are talking about - to check the Tools--Startup
etc.
is to be carried out on the old machine I presume.

It doesn't matter. The problem is, as far as I can tell, in the
application.

So in case I do find
anything in the Display Form/Page where should I copy this into.

It's not a question of copying it, it's a question of fixing it.

The problem is Brendan I am a systems admin guy with little or no
knowledge
of programming.

This doesn't appear to be a configuration issue. It appears to be a
programming issue. You would be well advised, therefore, to ask a
programmer
to have a look at it. (OK, that's what you're doing here, but I mean at
first hand! :-)

On the local desktops (I checked this on mine in my office) when there
is
no
file open the Startup option is dimmed.

That's correct, the option is disabled until you open a file.

So when I go to my client site today,
I will open the app on the server and see what are the options - if
any -
defined there.

Let us know what you find, and we may be able to offer further
suggestions
then.

Thanks for all your help.

Regards

"Brendan Reynolds" wrote:

The safest option would be to do nothing until you talk to the person
who
developed the applications. But I'm guessing that person is no longer
available?

Well then, when an Access application starts, it will look for a macro
called AutoExec, and if it finds one, it will run it. If a start-up
form
or
data access page has been defined (Tools, Startup, Display Form/Page)
Access
will open that form or data access page and run any code in the
various
event procedures that are fired when the object opens. For example, a
form's
Open, Load, and Activate events will fire, and any code in the Open,
Load
and Activate event procedures will run. So those are the places to
start
looking.

If there are both an AutoExec macro and a startup form or data access
page,
they'll both be executed.

Look for an AutoExec macro. Look for the text of the message there.
Select
Startup from the Tools menu. Does the 'Display Form/Page' combo box
say
'(none)' or does it display the name of a form or data access page? If
the
latter, open that form or data access page in design view and look for
the
message there.

Although less likely, it is also possible that the code may be in a
function
that is called from a query, for example a query that forms the record
source of a startup form.

I probably don't need to tell you this, but let's err on the side of
caution
anyway - make sure you have a recent, reliable back up before you
change
anything. Make one change at a time, and test thoroughly before making
any
further changes.

--
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.


"RC" wrote in message
...
Hi Brendan,
Just got off the phone with the client. They are able to open the
sample
database on their desktops without gettting the error message.
What should I do next?
Regards

"Brendan Reynolds" wrote:

There should not usually be any need for Access to be installed *on
the
server* no.

If my theory is correct, then the solution will depend on how,
where,
and
why the developer did this. Let's establish whether the theory is
correct
before we go too far down that road, though! :-)

--
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.


"RC" wrote in message
...
Thanks for your reply Brendan. I wil ltry that.
Is it necessary to load Acess on the server to use their
application?
The
desktops are all XP Pro Sp2 (just fyi). In case your theory is
correct -
how
can I get my client back on their feet with this application?
Throw
in
the
the older server and have the users work of it?
Regards

"Brendan Reynolds" wrote:

I don't think that's an Access error message. I think that's
something
the
developer has built in to these apps. To test this theory, could
you
try
the
sample app, Northwind? Can you open it, under the same
conditions,
without
getting this message?

--
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.


"RC" wrote in message
...
Hi everyone,

Wondering if anyone out there has encountered this kind of
problem.

I am in the process of migrating my client (they were running
Windwows
NT
4.5 SBS and MS-Access 2000 database) to a brand new server
running
Windows
2003 SBS with MS-Access 2003. The had an application in
MS-Access
2000.
After
successfully transferring the data and installing MS-Access
2003
on
the
desktops (the database files are on the server), if I try to
double-click
the
databse to open it, it gives me the following error message:

Your Windows Control Panel Date Settings are Currently
Unrecognized.
Please
reset your short Date Format to the U.S. Short Date Format
(ie
'mm/dd/yy').

I have set the short date formats to mm/dd/yy both on the
server
as
well
as
the desktops. However I am still uanble to open the
application.

Any helps/suggestions will be greatly appreciated.

Regards
Ravi