Managing database with access

  • Thread starter Thread starter Stephane Vial
  • Start date Start date
S

Stephane Vial

Hello all,

I would like to use Access for managing data into a SQL database......and I
would like to have the same look&field as Excel !!!

Is this possible ?
If yes, can you tell me where I can find information ?

Thanks

Stephane
 
Hi,
you can link SQL server tables to Access database, the open it as
datasheet - will look similar to excel.

You can also link sql server table directly to excel (perhaps read-only,
check excel newsgroup) - then you will get 100% "look&field as Excel"

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
What exactly are you wanting to do in terms of 'managing data'? Working with
data directly in at the table level is not a good idea *UNLESS* is very
simple data entry/editing where the DB only contains a table or two *AND* the
person entering the data is quite familar with the database schema. Case in
point, in a good database design for an orders application, you'll never find
"16 OZ CARPET" in the table that contains the order details, just a part
number such as 92016.
 
dch3 said:
What exactly are you wanting to do in terms of 'managing data'? Working with
data directly in at the table level is not a good idea *UNLESS* is very
simple data entry/editing where the DB only contains a table or two *AND* the
person entering the data is quite familar with the database schema.
Click to expand...

Working with data directly in MS SQL Server tables is most often prohibited
by the Data Base Administrator of the MS SQL Server database. The reason is
that users are given such a great opportunity to not only foul up what they
are doing themselves, but what others are doing with the same database.

Just as Access is not "Excel with larger spreadsheets", neither is "MS SQL
Server just Excel with larger spreadsheets". The red flag here is that you
ask to have the UI look like Excel, and the concern is that you are just
running out of rows and columns and looking for a "larger spreadsheet".

Larry Linson
Microsoft Office Access MVP
 
Back
Top