joebickley
Programmer
Hi Peoples
I have a access database that connectes to a sql server using linked tables. I have a few modules to manipule code but i am now converting it to acess 2000 and some of it does not cross over
I have a access database that connectes to a sql server using linked tables. I have a few modules to manipule code but i am now converting it to acess 2000 and some of it does not cross over
Code:
dim db as database
Set db = CurrentDb
dim rec as recordset
set rec = d.openrecordset("linkedtablename", DB_OPEN_SNAPSHOT, dbSeeChanges)[code]
I know if i turn on one of the libraries in access 2k this will work ok but i dont want to have to do that for all users. Anyone know the code to for access 2000 all i know is it is something like adodb.whatever but im struggleing to get it to work.
Any help would be great
