Board index MS SQL Server

Access 2002/SQL Server 2000

Access 2002/SQL Server 2000

Post by Jurren Bouma » Sat, 17 Aug 2002 01:01:05



I'm not that all familiar with Access/SQ Server but I'm trying to
learn it. And that's why I do have a few questions:

1. When I have created a database in Access 2002 and it's
registered/moved to SQL Server are the reports that are created in
Access moved/registered in SQL Server too? Where are they stored..?!?

2. When you make some adjustments to the database in Access how does
one "update" the database in SQL Server? Does one have to remove the
database files, physically, in SQL Server or is there a feature to
update..?!?

Thanks... Jurren

---
Jurren Bouman

 
 
 
Top

Access 2002/SQL Server 2000

Post by Aaron Bertrand [MVP » Sat, 17 Aug 2002 01:05:10


Quote:> 1. When I have created a database in Access 2002 and it's
> registered/moved to SQL Server are the reports that are created in
> Access moved/registered in SQL Server too? Where are they stored..?!?

SQL Server doesn't know what a report is.  SQL Server is a database server,
not a report builder.  You will need other tools to generate reports from
SQL Server, even Access will do it.

Quote:> 2. When you make some adjustments to the database in Access how does
> one "update" the database in SQL Server? Does one have to remove the
> database files, physically, in SQL Server or is there a feature to
> update..?!?

Well, once you've moved your data and schema to SQL Server, one would assume
you would make adjustments in the SQL Server database from that point on.

--
www.aspfaq.com / www.perfhound.com

 
 
 
Top

Access 2002/SQL Server 2000

Post by Jurren Bouma » Sat, 17 Aug 2002 01:53:01


On Thu, 15 Aug 2002 12:05:10 -0400, "Aaron Bertrand [MVP]"

>SQL Server doesn't know what a report is.  SQL Server is a database server,
>not a report builder.  You will need other tools to generate reports from
>SQL Server, even Access will do it.

Aaron,

Thanks for the information. Besides Access which are there other
popular tools to create reports? Can you name a few?

Thanks... Jurren

---
Jurren Bouman

 
 
 
Top

Access 2002/SQL Server 2000

Post by Kevin » Sat, 17 Aug 2002 01:56:45


1.  No, they are not moved.
2.  Are you using an Access database (.mdb) linked to SQL Server, or an
Access Data Project (.adp).  In an .mdb, you cannot change the design of the
tables from within Access, but in an .adp, when you view the tables in the
db window, you are looking directly at the SQL Server, so changes are
automatically made there.

Hope that helps,

--
Kevin Hill
President
3NF, inc.
www.3nf-inc.com

Microsoft Great Plains partner
www.3nf-inc.com/CRM.htm


> I'm not that all familiar with Access/SQ Server but I'm trying to
> learn it. And that's why I do have a few questions:

> 1. When I have created a database in Access 2002 and it's
> registered/moved to SQL Server are the reports that are created in
> Access moved/registered in SQL Server too? Where are they stored..?!?

> 2. When you make some adjustments to the database in Access how does
> one "update" the database in SQL Server? Does one have to remove the
> database files, physically, in SQL Server or is there a feature to
> update..?!?

> Thanks... Jurren

> ---
> Jurren Bouman


 
 
 
Top

Access 2002/SQL Server 2000

Post by Kevin » Sat, 17 Aug 2002 02:00:24


Crystal reports seems to be a crowd-pleaser...

--
Kevin Hill
President
3NF, inc.
www.3nf-inc.com

Microsoft Great Plains partner
www.3nf-inc.com/CRM.htm


> On Thu, 15 Aug 2002 12:05:10 -0400, "Aaron Bertrand [MVP]"

> >SQL Server doesn't know what a report is.  SQL Server is a database
server,
> >not a report builder.  You will need other tools to generate reports from
> >SQL Server, even Access will do it.

> Aaron,

> Thanks for the information. Besides Access which are there other
> popular tools to create reports? Can you name a few?

> Thanks... Jurren

> ---
> Jurren Bouman


 
 
 
Top

Access 2002/SQL Server 2000

Post by Ivan Demkovitc » Sat, 17 Aug 2002 02:23:51




Quote:> Crystal reports seems to be a crowd-pleaser...

... and only because there is no solid competitor...

Crystal sux and full of bugs...

 
 
 
Top

1. ODBC Access 2002 / SQL Server 2000 Disconnect

We start with a solid DSN Connection to a linked SQL
table.  From the Access table we update 2 fields in
either the SQL table or a View of it.  We can continue
with more successful updates as long as the database is
open.
When we close the Access database, then open it again and
try to do the update, we get Permissions Error 229.  All
permissions are very good - the error happens at even the
highest level.
Workaround code with tabledefs and refreshlinks also
causes the error to happen if we run it.  
I notice that the table appears to still be linked, but
it has been made unupdateable (read-only), where it
definitely was read-write when things work correctly.
When we go back into the database (the error not having
occured) and immediately relink with Tools, Linked Table
Manager before attempting the update, the update will
work.
Once the error has happened, however, the only recovery
is to redo the DSN with the ODBC Administrator.
Can someone help with a suggestion on how to stay linked,
or about what might be happening?
Thanks much in advance.

Jerry OC

2. Starting Excel

3. Pessimistic locking with Access 2002/Sql-Server 2000

4. Protocol error in TDS stream, SQL 6.5.

5. Transforming Access 2002 SQL to SQL-Server 2000 SQL

6. SQL Agent Mail to send an SMS to a mobile....?

7. Access 2002 adp frontend Sql Server 2000 backend (Reports Problem)

8. codds rule 6

9. SQL Server 2000 and Access 2002 ADP Project in NT 4.0

10. Problem in migrating from Access 2002 to SQL server 2000

11. Jumping from Access 2002 to SQL Server 2000

12. Access 2002 Project with SQL Server 2000

13. Cannot open tables using Access 2002 adp to SQL Server 2000


All times are UTC
Board index