I'd like to ask y'all about another conversion problem. I'm working with a File Server Access 2000 app - one file contains the data and the other the forms, reports, modules etc (front-end file). The front-end file has linked tables which reference the data file.
Now, both files are secured using the same Workgroup Information File and DAO allows me to reference the data file from code in the front end file without resubmitting mdw file, user name, or password information like this:
Dim wspCurrent as DAO.Workspace
Dim dbCurrent as DAO.Database
Set wspCurrent = DBEngine.Workspaces(0)
Set dbCurrent = wspCurrent.OpenDatabase("Data FilePath")
This is very useful for manipulating Data File objects.
I've tried do this in ADODB/ADOX without much success. Anybody got any ideas?