مساعدة في الاكسسXP

الأخ عمر 15

بالنسبة للسؤال الأول :

فالخيارات نفسها موجودة في الاكسس اكس بي مع زيادة بعض الخيارات الأخرى .

شكراً لك اخوي الغريب على ردك ولكن احب ان اشير الى ان الخيارات تظهر بهذه الصوره :

Test

memo

number

date/time

currency

Autonumber

yes/no

OLE object

Hyperlink

lookup wizard

اذا كانت قاعدة البيانات هي اكسس باى اصدار كان 97/2000/2002

لكن اذا كانت قاعدة البيانات SQL واستخدم الاكسس كواجهة تطبيقية

فأن الخيارات تختلف تماماً اذكر منها هذان الخياران Char , Varchar مع اني اعرف وظيفة هذان الخياران فهما خياران نصيان ولكن باقي الخيارات لا اعرفها كما انه لايوجد اي خيار باسم number ليدل على الارقام لذلك لا استطيع ان احدد الخيارات فارجوا من الاخوه الافاده فيما طرح وشكراً...... ارجوا ان اكون قد اوصلت الفكره:o :o :o

السلام ليكم و رحمة الله و بركاته

بالنسبة للسؤال الاول هذا و صفها من التعليمات

Character Data
---------------
Character data consists of any combination of letters, symbols, 
and numeric characters. For example, valid character data includes "928",
 "Johnson", and "(0*&(%B99nh jkJ". In Microsoft® SQL Server™ 2000, character 
data is stored using the char, varchar, and text data types. Use varchar when 
the entries in a column vary in the number of characters they contain, but the 
length of any entry does not exceeds 8 kilobytes (KB). Use char when every entry 
for a column has the same fixed length (up to 8 KB). Columns of text data can be
 used to store ASCII characters longer than 8 KB. For example, because 
HTML documents are all ASCII characters and usually longer than 8 KB, 
they can be stored in text columns in SQL Server prior to being viewed 
in a browser

char and varchar
------------------
Fixed-length (char) or variable-length (varchar) character data types.

char[(n)]
----------
Fixed-length non-Unicode character data with length of n bytes. n must be a value
 from 1 through 8,000. Storage size is n bytes. The SQL-92 synonym for char is character.
varchar[(n)]
-------------
Variable-length non-Unicode character data with length of n bytes. n must be a value from
 1 through 8,000. Storage size is the actual length in bytes of the data entered, not n bytes. The data entered can be 0 
characters in length. The SQL-92 synonyms for varchar are char varying or character varying.

ntext, text, and image
----------------------
Fixed and variable-length data types for storing large non-Unicode and Unicode character
 and binary data. Unicode data uses the UNICODE UCS-2 character set.

ntext
------------
Variable-length Unicode data with a maximum length of 230 - 1 (1,073,741,823) characters.
 Storage size, in bytes, is two times the number of characters entered. The SQL-92 synonym
 for ntext is national text.

text
---------
Variable-length non-Unicode data in the code page of the server and with a maximum length 
of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters,
 the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size 
may be less than 2,147,483,647 bytes.
image

Variable-length binary data from 0 through 231-1 (2,147,483,647) bytes. 
=================

Exact Numerics
============
===================
Integers
============
bigint
---------
Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).
int
---------
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).
smallint
---------
Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767).
tinyint
----------
Integer data from 0 through 255.
bit
---------
bit
-----
Integer data with either a 1 or 0 value.
decimal and numeric

decimal
------
Fixed precision and scale numeric data from -10^38 +1 through 10^38 –1. 

numeric
--------
Functionally equivalent to decimal.

money and smallmoney
======================
money
--------
Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.

smallmoney
-----------
Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a 
ten-thousandth of a monetary unit.

Approximate Numerics
------------------------
float
----------
Floating precision number data from -1.79E + 308 through 1.79E + 308.

real
-------
Floating precision number data from -3.40E + 38 through 3.40E + 38.
datetime and smalldatetime

datetime
===========
Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.
smalldatetime
-------------
Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute.

بخصوص باقي الاسئلة

لمعرفة مكان تخزين ملفات قاعدة البيانات فى

SQL Server

افتح ال

Enterprise Manager

و اختار القاعدة التي تريدها

ثم اختار خصائص

ثم اختار

Data Files

فيظهر لك مكان تخزين الملفات

اما عن عدم السؤال عن كلمة السر

فأعتقد أنه لا توجد صلاحيات علي القاعدة التي تريد الاتصال بها فى ال SQL أي أنها متاحة لكل الناس