Linking SQL Server tables to Access.

  • Thread starter Thread starter DaveO
  • Start date Start date
D

DaveO

Hi there and thanks for looking.

Here's what I'm trying to do ...

I have a SQL Server database where tables are kept. I have begun building an
Access front end to do some local querying as I don't have access to
Enterprise Manager all the time. The SQL Database regularly has new
transactional tables created which I would like to link to my Access
database, but as they're time stamped I'm not going to know the exact name.
Other exist as well which I'm not interested in hence wanting to do a name
check before linking. I do know that the first 12 characters will always be
the same so intend to use this to do my linking, but not sure how to
enumerate through the tables in the SQL database and then create the link.

Also, I intend to refresh the access database from time to time, so a way to
drop the links would also be very useful.

Thanks in advance.

Dave.
 
hi Dave,
The SQL Database regularly has new
transactional tables created which I would like to link to my Access
database, but as they're time stamped I'm not going to know the exact name.
Click to expand...
You can list all tables using

SELECT *
FROM INFORMATION_SCHEMA.TABLES

on the SQL Server.


mfG
--> stefan <--
 
Back
Top