Upsize and performance

[chemicals]

I have "upsized" to SQL server. My question is this...
When I go into Access I now see all the queries and tables in the SQL
database. Oviuosly there are many that I don't even use for this particular
application. Are they sucking up memory in my Access application? If so can
I somehow remove them from the Access program?

I am assuming that they are not the same as Linked Tables but I noticed that
when I change the SQL database tables the change is not reflected in Access
until I restart!?

Opinions are welcome

 

[Tom van Stiphout]

On Thu, 4 Dec 2008 10:41:01 -0800, chemicals

Unused objects only take up a negligable amount of memory. Don't worry
about that.

On your second point: use precise language. I can't tell whether
you're talking about changing data in the SQL Server tables, or
changing the table structure, or something else?

-Tom.
Microsoft Access MVP

 

[David H]

As to the last question, I noticed the same behavior (regarding the adding or
deleting of fields from a table) back when I was evaluating SQL Server. I
can't give you an explanation as to why, but it never impacted my ability to
work with the database or Access. I should point out that a well designed
database will only require a minimum of changes to the fields once the schema
is developed.

Here's an article to keep in mind if you have queries embedded in code...
http://www.mssqltips.com/tip.asp?tip=1632

 

[chemicals]

I am referring to adding a field(column) to a table via SQL Server Manager.
If Access is open it seemingly can't be refreshed so that it sees the new
changes...