Quick question....I'm trying to open a database using DBEngine.Workspaces(0).OpenDatabase("mydb.mdb").
Fine when the MyDb is closed, but Can I open a table for read/write access? Wehn I try it with the database open in shared mode i get a 'file in use' error.
Any way round it other than using yet another linked table?
Fine when the MyDb is closed, but Can I open a table for read/write access? Wehn I try it with the database open in shared mode i get a 'file in use' error.
Any way round it other than using yet another linked table?