August 19, 2004 at 2:49 pm
When I create a linked server to an access database from SQL server, and then someone changes the information in the Access database directly, will the linked server table in SQL server also be updated with the change?
For some reason, my linked server tables don't seem to be staying current with the info from the other database.
August 20, 2004 at 1:07 am
If you want users to make changes / updates in Access, and for the changes to appear in a table that is stored in SQL Server, then create a Linked Table in the Access database that references the SQL Server Table. That way the data is never stored in the Access database, it's really stored in the SQL Server.
Creating a Linked Server doesn't actually link tables up. It just lets you do distributed queries like
select * from [linkedserver].database.dbo.table
Julian Kuiters
juliankuiters.id.au
August 20, 2004 at 9:02 am
It depends partly on the settings in access. I have access 2002 so it may be different on your version. But in Access go to Tools-Options-Advanced. Make sure youre default open mode is Shared, record level locking should be on, and adjust all the refresh intervals. MS Access delays writing updates to disk if it can, for speed.
Regards
Peter
August 20, 2004 at 11:59 am
If done properly linking an Access Database via a SQL Server Linked Server should allow you to read and update the Access data as if it were native SQL Server data. If your linked table is not reflecting accurate (current) data you may want to review the linked server definition (Properties) as well as Access security.
August 30, 2004 at 6:39 am
Note that Linked Server is like you have only shortcut to your Access database ..
and when you want to get data from it, you have to write code to pull data from your Access DB
if you use Linked Server, then make a files for Yes/No (Bit Field) that changed (set) when you update or add a record .. and clear it when you pull that data in SQL.
I hope this help u.
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply