
Signature
Luiz Cl?udio C. V. Rocha
S?o Paulo - Brasil
http://br.thespoke.net/MyBlog/lccvr/MyBlog.aspx
> My live database is currently not secure. I have a copy of it that I have
> worked out all the security issues and I am ready to update the live data
[quoted text clipped - 16 lines]
> currently I am opening tables in code using currentdb.openrecordset...
> will this need to change?
I went ahead and implemented security first, because it was ready the *they*
were waiting... So the next step for this database is to split. Is there
any other code besides dbOpenTable or seek method that I need to be aware of
ahead of time?
Thanks
> Hi tw,
>
[quoted text clipped - 26 lines]
>> I.E. currently I am opening tables in code using
>> currentdb.openrecordset... will this need to change?
Immanuel Sibero - 13 Apr 2005 16:56 GMT
tw,
All you need to know about securing and splitting.. :-)
For information on splitting:
http://www.granite.ab.ca/access/splitapp/overview.htm
For information on Access User Level security:
http://www.jmwild.com/SplitSecure.htm
Based on the information on Joan Wild's website, to me it's much simpler to
secure first and then split.
Also, note the gotcha about using the builtin "splitter tool" wizard on
secured databases.
HTH,
Immanuel Sibero
> I went ahead and implemented security first, because it was ready the *they*
> were waiting... So the next step for this database is to split. Is there
[quoted text clipped - 33 lines]
> >> I.E. currently I am opening tables in code using
> >> currentdb.openrecordset... will this need to change?
tw - 19 Apr 2005 16:43 GMT
Thanks, I have the database fully secure and have been doing well with that
for the past couple of weeks. I followed presisly the instructions to
secure a database and the advice given from the newsgroups. I will check
out the information you provided to split a secure database and post back if
I have any problems. Thanks again.
> tw,
>
[quoted text clipped - 62 lines]
>> >> I.E. currently I am opening tables in code using
>> >> currentdb.openrecordset... will this need to change?
Luiz Cl?udio C. V. Rocha [MVP] - 13 Apr 2005 19:00 GMT
Hi tw,
"Seek" is most frequent problem with splitted DBs, but any code involving
table structures and indexes must be fixed.

Signature
Luiz Cl?udio C. V. Rocha
S?o Paulo - Brasil
http://br.thespoke.net/MyBlog/lccvr/MyBlog.aspx
>I went ahead and implemented security first, because it was ready the
>*they* were waiting... So the next step for this database is to split. Is
[quoted text clipped - 33 lines]
>>> tables? I.E. currently I am opening tables in code using
>>> currentdb.openrecordset... will this need to change?