connecting to a sql server

[RJ]

I'm running access 2002 and need to link to microsoft sql
server - can it be done, any articles appreciated.

Thanks RJ

 

[Kevin @ 3NF]

Create a DSN on your system that points to the SQL Server and database you
want to link to.

File>>Get External Data>>Link Tables, change the files of type drop down to
ODBC databases and select the DSN you created.

 

[Ngan Bui]

I've asked this before, but haven't gotten a reason for
why this happens:

I upsize my AXP tables (no data transfer) to sql server
2000. I create the DSN to point to the sql server...do
the get external data, link tables...I link about 40
tables...

with just those link tables, my MDB file is almost 1MB.
Whereas if I did the same linking with the same Access
tables (before upsizing), it's less than 150KB.

Why is there such a disparity in the size? Other people
said they don't run into this, so why am I?

Does it matter if the sql tables were upsized from access
tables, vs being created from scratch?

Thanks!
Ngan

 

[Kevin @ 3NF]

What else is in the file that holds the links? Surely there must be
something else in there to make the file size that big (not that 1 MB is
big...)

 

[Ngan Bui]

That's the issue, I can't seem to think there is anything
in the file except the linked tables. I did the upsizing
without the data, using the wizard. So the SQL tables
don't have any data in them. I created a new MDB file from
scratch. Did the linking to the sql tables and that's
it. No forms/queries or anything more.

1MB is big for just linked tables, right?

Would having one-many relationships increase the size? Or
indexes (but the only indexes are the Primary keys)?

I've done this over and over and get the same results.
Didn't think it was that difficult to do.

What else to do?

Ngan

 

[Ngan Bui]

Which mdb file do you want? the one of the sql linked
tables, the original one (it's pretty big 80MB), or what?

Ngan

 

[msmcnewsxp]

compact and repair.
and who cares how big it is if it's doing what you want.
file size isn't really an issue any more is it?

 

[Ngan Bui]

I just want to keep the size of my FE to a minimum. Just
wanted to see why the size does increase so much with sql
linked tables and not with mdb linked tables. If that's
by design, then so be it.

I do care a bit because if my FE gets too big, it could
slow things down for users.

Ngan