PANIC!! Please asist

[James]

Hello,

I have a rather large database and it seems to have gone
and died on me... This is not good...

I click on a switchboard item and it does not do as it is
supposed to...

There is no way of getting to the back of the database as
the bypass key is disabled unless anyone knows another way
of doing this...

Basically I need to get into this part so I can unlock the
database... is tehre something I can do to revive my
database??? I have tried importing everything into another
database this is ok but the imported version does not work
everything I seem to do in it seems to ask me for a macro
which I never had or never created nor did anyone else...

What can I do?

Many Thanks

James

 

[Scott Shearer]

Try importing everything again into a new/clean .mdb file. This time, click on the options command button when you get to the "import object" form. At the bottom left corner of the form, make sure that you have selected "Menus and Toolbars" for import - it is not selected by default. Then go through each of the tabs and hit the "select all" button. If you still have problems, please post here.

Scott Shearer MCSD, MCDBA
(e-mail address removed)

----- James wrote: -----

Hello,

I have a rather large database and it seems to have gone
and died on me... This is not good...

I click on a switchboard item and it does not do as it is
supposed to...

There is no way of getting to the back of the database as
the bypass key is disabled unless anyone knows another way
of doing this...

Basically I need to get into this part so I can unlock the
database... is tehre something I can do to revive my
database??? I have tried importing everything into another
database this is ok but the imported version does not work
everything I seem to do in it seems to ask me for a macro
which I never had or never created nor did anyone else...

What can I do?

Many Thanks

James

 

[James]

Hello,

Thanks For that...

done that and still I am getting errors in my database...

I am getting a compile error:

User Defined - Type not defined...

Any ideas on that one?

Do you have any ideas why my old database will not word?

Cheers

James

-----Original Message-----
Try importing everything again into a new/clean .mdb

file. This time, click on the options command button when
you get to the "import object" form. At the bottom left
corner of the form, make sure that you have
selected "Menus and Toolbars" for import - it is not
selected by default. Then go through each of the tabs and
hit the "select all" button. If you still have problems,
please post here.

 

[Scott Shearer]

Try this next -
Go into the Visual Basic Editor. Select Tools from the menu, then references. See if you see anything that says "MISSING". Is so, provide the appropriate reference - either way, please post the results here.

Scott Shearer MCSD, MCDBA
(e-mail address removed)

----- James wrote: -----

Hello,

Thanks For that...

done that and still I am getting errors in my database...

I am getting a compile error:

User Defined - Type not defined...

Any ideas on that one?

Do you have any ideas why my old database will not word?

Cheers

James

-----Original Message-----
Try importing everything again into a new/clean .mdb

file. This time, click on the options command button when
you get to the "import object" form. At the bottom left
corner of the form, make sure that you have
selected "Menus and Toolbars" for import - it is not
selected by default. Then go through each of the tabs and
hit the "select all" button. If you still have problems,
please post here.

 

[tom]

Have you tried pressing the shift key as the database is starting up? When
you inserted code to bypass normal startup, did you not put the unlock code
somewhere? If not, you may not be able to get to the database window...

Tom.

 

[James]

Ok done that... seems happy until I try to compile...

I get the error variable not defined... on this bit of
code..

CurrentDb.Execute stSQL, dbFailOnError

It seems to highlight the dbFailOnError...

Any other suggestions?

Many Thanks

James

-----Original Message-----
Try this next -
Go into the Visual Basic Editor. Select Tools from the

menu, then references. See if you see anything that
says "MISSING". Is so, provide the appropriate reference -
either way, please post the results here.

 

[James]

When you say the unlock code what do you mean?

I have a database which enables or disables the bypass key
in any database and I have tried this and it doesnot seem
to work...

What can I do?

Many Thanks

James

-----Original Message-----
Have you tried pressing the shift key as the database is starting up? When
you inserted code to bypass normal startup, did you not put the unlock code
somewhere? If not, you may not be able to get to the database window...

Tom.

 

[Van T. Dinh]

Have you added the Microsoft DAO Object Library into the References
Collection?

In A97 & A2K3, DAO is added by default but you need to add it yourself in
A2K and A2K2.

 

[Van T. Dinh]

Didn't you build a back door to re-enable the Bypass Key?

(it still can be enabled even if you didn't except I haven't got the code
handy to post here).

 

[Scott Shearer]

This appears to be DAO related - please be sure that you have a reference to a DAO type library.

Scott Shearer MCSD, MCDBA
(e-mail address removed)

----- James wrote: -----

Ok done that... seems happy until I try to compile...

I get the error variable not defined... on this bit of
code..

CurrentDb.Execute stSQL, dbFailOnError

It seems to highlight the dbFailOnError...

Any other suggestions?

Many Thanks

James

-----Original Message-----
Try this next -
Go into the Visual Basic Editor. Select Tools from the

menu, then references. See if you see anything that
says "MISSING". Is so, provide the appropriate reference -
either way, please post the results here.

 

[James]

Hello,

I have added the follwoing refrence:

DAO 3.6 Object Libary now I am getting the follwoing error
when I compile:

Method or Data Member not found....

In this line of code...

rst.FindFirst "[SwitchboardID]=" & Me![SwitchboardID] & "
AND [ItemNumber]=" & intBtn

It seems to highlight the SwitchboardID field...

Any more suggestions?

Many Thanks

James

 

[James]

Hello,

Ah right is there anywhere I can get it and instructions
on what to do?

I have a database which can re enable the bypass key in
any database and I have tried that and it just cant seem
to gain access to the database to allow me to use the
bypass key...

Any other suggestions?

Many Thanks

James

 

[Marshall Barton]

I have added the follwoing refrence:

DAO 3.6 Object Libary now I am getting the follwoing error
when I compile:

Method or Data Member not found....

In this line of code...

rst.FindFirst "[SwitchboardID]=" & Me![SwitchboardID] & "
AND [ItemNumber]=" & intBtn

If you're not planning to use the ADO library, then you
shoud uncheck it in the references list so this type of
ambiguity doesn't arise.

If you really want to use bot DAO and ADO, then you have to
disambiguate the various objects in both libraies that have
the same name. E.g.

Dim rst As DAO.Recordset

 

[Van T. Dinh]

Post your code to enable BypassKey (of another database) and the usage
example.

 

[James]

Here is the code that I have used within my database for
disableing the bypass key...

ChangeProperty "AllowBypassKey", dbBoolean, False

Many Thanks

James

 

[James]

I have now added teh ADO library to the refrences I have
added :

Microsoft ADO Ext. 2.6 for DDL and Security

And I get a type mismath error at this line:

Set rst = dbs.OpenRecordset(strSQL)

What can I possibly do now?

Many Thanks

James

-----Original Message-----

I have added the follwoing refrence:

DAO 3.6 Object Libary now I am getting the follwoing error
when I compile:

Method or Data Member not found....

In this line of code...

rst.FindFirst "[SwitchboardID]=" & Me![SwitchboardID] & "
AND [ItemNumber]=" & intBtn

If you're not planning to use the ADO library, then you
shoud uncheck it in the references list so this type of
ambiguity doesn't arise.

If you really want to use bot DAO and ADO, then you have to
disambiguate the various objects in both libraies that have
the same name. E.g.

Dim rst As DAO.Recordset

 

[Marshall Barton]

I have now added teh ADO library to the refrences I have
added :

Microsoft ADO Ext. 2.6 for DDL and Security

And I get a type mismath error at this line:

Set rst = dbs.OpenRecordset(strSQL)

What can I possibly do now?

I think you might have misinterpreted what I said earlier.

Are you sure you want a reference to ADO?

If so, make sure you qualify the objects with the library,
either:
Dim rst As ADODB.Recordset
or
Dim rst As DAO.Recordset

depending on the type of recordset you need to use.

From what you've posted so far, I'm pretty sure that you
have no use for ADO and that you'd be best served by
checking DAO and unchecking ADO in the references.
--
Marsh
MVP [MS Access]

James

-----Original Message-----

I have added the follwoing refrence:

DAO 3.6 Object Libary now I am getting the follwoing error
when I compile:

Method or Data Member not found....

In this line of code...

rst.FindFirst "[SwitchboardID]=" & Me![SwitchboardID] & "
AND [ItemNumber]=" & intBtn

If you're not planning to use the ADO library, then you
shoud uncheck it in the references list so this type of
ambiguity doesn't arise.

If you really want to use bot DAO and ADO, then you have to
disambiguate the various objects in both libraies that have
the same name. E.g.

Dim rst As DAO.Recordset

 

[Douglas J. Steele]

Microsoft ADO Ext 2.6 for DDL and Security is not the ADO library: it's the
ADOX library. The ADO library is Microsoft ActiveX Data Objects 2.6 Library

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have now added teh ADO library to the refrences I have
added :

Microsoft ADO Ext. 2.6 for DDL and Security

And I get a type mismath error at this line:

Set rst = dbs.OpenRecordset(strSQL)

What can I possibly do now?

Many Thanks

James

-----Original Message-----

I have added the follwoing refrence:

DAO 3.6 Object Libary now I am getting the follwoing error
when I compile:

Method or Data Member not found....

In this line of code...

rst.FindFirst "[SwitchboardID]=" & Me![SwitchboardID] & "
AND [ItemNumber]=" & intBtn

If you're not planning to use the ADO library, then you
shoud uncheck it in the references list so this type of
ambiguity doesn't arise.

If you really want to use bot DAO and ADO, then you have to
disambiguate the various objects in both libraies that have
the same name. E.g.

Dim rst As DAO.Recordset