I already solved the problem.
The database was local, so I made a share to it and I used \\server\database.mdb as datasource in stead of c:\database.mdb
Is it possible to create a linked server in SQL Server 2000 to an Access Database?
I tried to make one with following options in enterprise manager:
Server type: Other data source
Provider name: test
Product name: test
Data source: c:\db\test.mdb
Provider string...
I checked it out and it inserts the default value indeed. The problem is that it's inserted to late, isn't there a possibility to insert it before the fields are entered?
If I use the same table in access with a default value, the default value is displayed when I insert a new empty row.
The...
But I realy need that default value in access, else the front-end program doesn't work, and I don't have the time to make a new front-end for it. So isn't there any possibility to use a default value?
When I set a default value in SQL Server (using Enterprise Manager), that value is not the default value in Access when I link the tables. Any suggestions?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.