Truncated name when creating new database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When attempting to create a new database in access 97, the database name is
truncated to one character, this is a new occurrance it used to works fine.
The system is WinXP Pro SP2, Office 2003 is installed, and Access 97 is also
installed.
The problem does exist in Access 2003. I have uninstalled and reinstalled
Access 97 with no help. Existing Access97 applications with longer names
work fine and if I rename the 1 char name it also works fine. If I select an
existing name from the target dir for the NEW database only the first
character of the name will copy to the NEW name dialog box. I can type
additional characters and all but the first will be lost.
 
Hi, Don.
When attempting to create a new database in access 97, the database name is
truncated to one character, this is a new occurrance it used to works fine.
Click to expand...

Count the number of characters for the directory path preceding that one
character for the file name. Is it 254? If so, there's your problem.

Databases take serious performance hits when human readability takes
precedence over well-established software application development best
practices. Want a faster database running on the network _and_ fewer
software bugs? Place the database file as close to the root directory as
possible, i.e., C:\Data.MDB. Never use spaces or any special characters in
the directory path or file name. Use the old DOS 8.3 naming convention, not
the Windows 255-character naming convention.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
The directory path I am using is 8 charactors.
the appearance is as though the "CREATE NEW" "FILE NAME" dialog box will
only use the first character of what ever typed or copied there.
A new database will be created I just can't create a name greater than 1
byte.
 
Hi, Don.

If the directory is located on the network and not your computer's hard
drive, then it may very well have more than the eight characters you see.
For example:

C:\Data\

.. . . is eight characters. However,

T:\Data\

.. . . is 174 characters. Why? Because the T:\ drive is mapped to a
subdirectory on a networked server:

\\LongestServerNameICanThinkOfIn2Seconds\Longest directory name I can think
of in the next 2 seconds\Longest subdirectory name I can think of in the
following 2 seconds\Data\

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
The application is on a laptop the has no network connections, the directory
path specified for the new .mdb file has other .mdb files in it, and each
can be accessed successfully. If the problem is excessive path length I
would expect failure attempting access of other existing files. Are there
any parameters jet engine that could limit name size?
 
Back
Top