Do I need to close a recordset clone like a table recordset?
Thu, 31 Jul 2008 15:44:00 -0700
Hi,
If I do the following:
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
and then do some stuff with rst, do I need to (or should I) close it when
I'm done like I would any recordset?
--
Thanks,
Jeff ...
|
Access 03 Security
Thu, 31 Jul 2008 11:56:11 -0700
I have searched from head to toe and can't find an answer in this aor any
other forum.
I'm trying to secure an Access 03 database on a corporate wide network.
Some use the program in English, some use French. The DB is split into FE
and BE, both secured by the same Workgroup File. I have disabled the
...
|
prevent changes to database
Thu, 31 Jul 2008 08:18:05 -0700
I have created a database that allows inexpierenced Access users to search
for data using a switchboard and command buttons. This database will be
distributed to users by disk to be stored on their computers. I have
disabled the database window during start up but how can I make it so that
the shift key an ...
|
compact database
Tue, 29 Jul 2008 17:52:21 +0100
Hello,
What are the advantages or disadvantages to compact a database?
Thank's in advance,
Nuno Gomes
...
|
2003 Access Secured Database - how to allow other users to login
Tue, 29 Jul 2008 10:01:00 -0700
Hi All,
I know I am probably just having a bad case of "Stuck on Stupid" (SOS)..
However, I have created a secured database in 2003 that has myself(Admin
Rights/Owner), and 19 other users.. I had absolutely no problem setting up
the new workgroup, and the secured database .. what I can't seem to do is
giv ...
|
Trying to make a database fool - proof
Tue, 29 Jul 2008 06:14:04 -0700
Right, here is the situation. First of all my background, I am new to access,
having only used it for data input in the past, my background is television
production but i am currently in a temporary job for a finance company who
decided (somehow) my skills were best put to use creating a database for
their c ...
|
Workgroup Problem (i assume)
Tue, 29 Jul 2008 03:48:02 -0700
Hi,
I have set up a database and rolled it out. All users are connected to the
same work group. We all get asked to block expressions that may be unsafe,
apart from one user.
I have rejoined the workgroup that everyone else uses for that user, but
still nothing. This means that each line of my code ...
|
|
|
Spiltter wizard fails- "Subscript out of range"
Mon, 28 Jul 2008 15:18:08 -0700
Hi all - Where does this come from? This message is then followed by one
about an invalid call procedure or argument. This db has about a dozen
tables, with a few more via links to another db. If I open the new back end
to see where the wizard left off, it's about 8 tables in. The biggest one has
30k records ...
|
Access 2007 Network/Internet security
Mon, 28 Jul 2008 12:52:18 -0700
If my access accDB file is split into FE and BE, the back end being on a
server which is running MS Small buisness server 2003, and I only use the
inherent windows security and the password feature in Access 2007, how
vulnerable would the database be to hackers from the internet?
What I am trying to get at ...
|
Is an Access 2007 db Secure enough for a Corporate server?
Mon, 28 Jul 2008 08:45:06 -0700
I am concerned that an Access 2007 db is not secure enough and that you
should use MySQL or Oracle. Is this true and why? ...
|