[thelist] Multi-user Access db - not web front end
listman at hazard0us.org
listman at hazard0us.org
Tue Nov 5 08:33:01 CST 2002
>Here's the situation. I have a reasonably complex Access(2000) db which I
>need to share amongst the small team (total: about a dozen people) here.
remember to back up very regularly, access mdb is a bitch when it comes
to getting corrupted...(or upgrade to msde...)
>a) Can I (and if so how do I) change the pointer in the frontend to the
>location of the backend?
there are various ways to do this :
- manually => using the "linked table manager" in access tools->db
utils
- semi manually => prompt the user for a path to the backend db the
1st/every time the frontend app is launched
(i have used this method)
- programatically using ADOX you can change the ddl of the db.
(take a look at Q291264 on the support.microsoft KB )
>b) Can that backend be URL/IP address based? (we're on a mixed network of
i think url is a strict no-no, ip addressing should probably work with a NT
type UNC :
\\10.1.3.5\db\db.mdb.
>It'd be nice to have all this running with a Web front end,
i remember access2k came with something called data-access-pages to convert
forms to web forms - dont know how well it works though....
HTH
ashok
------
Ashok Hariharan
http://www.unganisha.org
------
More information about the thelist
mailing list