Splitting database



Hi,
I have a database on the K drive, but whenever more than one person wants to
use the file, I am prompted with a message that states that I do not have
exclusive access rights to the database and I can't save my changes. So I
have gleaned from other user questions about this that I need to split my
database to back-end and front-end. I have done this and placed my back-end
file in a network folder called Database. However, my front-end file which I
have moved to my computer's hard drive still contains the tables as well as
the application tools (forms, reports, etc.). I guess my next move would be
to delete the table data from the front-end application and then "link" it to
the tables on my network drive? If so, can someone help me get started, or
point me to a good resource to do this?

Thanks,
Amin
.



Relevant Pages

  • What if the back-end "moves"?
    ... front-end and a back-end but here is my problem. ... flash memory keys. ... I want to do is split the database on each of the resident's own copies. ...
    (microsoft.public.access.setupconfig)
  • Re: Win 7 virtual store question (with Access 2003)
    ... The front-end (UI for the database application) and back-end ... application", they could be in the same folder, but if it is a multi-user ...
    (comp.databases.ms-access)
  • Re: Can i link to tables in an encrypted database?
    ... of tables and a front-end of forms/reports. ... I want to encrypt the back-end ... But when I encrypt it, I can't link to & connect ... How can I link to tables which exist in an encrypted database? ...
    (microsoft.public.access.gettingstarted)
  • Re: Exclusive use notification
    ... Is your application split into a front-end (containing the queries, forms, ... Only the back-end should be on the server: ... database, then you can set the Default Open Mode ...
    (microsoft.public.access.modulesdaovba)
  • Re: Dynamic listing in a form - Thanks
    ... tables in a separate database and include them in your main front-end as ... The database bloat that PCD mentioned. ... > "Alp Bekisoglu" wrote in message ... >> I do get everything I want and display it in a MsgBox. ...
    (microsoft.public.access.formscoding)