473,322 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Can't select Design or New in my Forms?

When I bring up my database (access 97) I can't select the "DESIGN" or "NEW"
in my Forms.
Table and Query seem to be ok.
Is there a way to fix it?

Thank
Steve
Nov 13 '05 #1
7 1342
Steve wrote:
When I bring up my database (access 97) I can't select the "DESIGN" or "NEW"
in my Forms.
Table and Query seem to be ok.
Is there a way to fix it?

Thank
Steve


Do you have user-level security applied to the app?
Nov 13 '05 #2
I don't know.... I will look into it.
I have a book on access but I just don't know where to start looking.
Everything was working ok, then it changed. I may have set something
on accident the last time I updated the program.
Thank
Steve

"Salad" <oi*@vinegar.com> wrote in message
news:%b****************@newsread3.news.pas.earthli nk.net...
Steve wrote:
When I bring up my database (access 97) I can't select the "DESIGN" or "NEW" in my Forms.
Table and Query seem to be ok.
Is there a way to fix it?

Thank
Steve


Do you have user-level security applied to the app?

Nov 13 '05 #3
Steve wrote:
When I bring up my database (access 97) I can't select the "DESIGN" or "NEW"
in my Forms.
Table and Query seem to be ok.
Is there a way to fix it?


Check to see if your database has an mdb or an mde extension, ie,
MyDatabase.mdb or MyDatabase.mde.

If it's mde, you are using a compiled application and by design can not
change (design and new are not available) forms, reports or modules.

There's no way to fix this unless you have access to the original
MyDatabase.mdb.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #4
Steve wrote:
I don't know.... I will look into it.
I have a book on access but I just don't know where to start looking.
Everything was working ok, then it changed. I may have set something
on accident the last time I updated the program.


It is unlikely you secured the database from the posts you've made,
Steve. I think you converted it into an mde - see my other post.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #5
It is saved as an mdb but it acts like an mde.

Steve

"Tim Marshall" <TI****@antarctic.flowerpots> wrote in message
news:cj**********@coranto.ucs.mun.ca...
Steve wrote:
When I bring up my database (access 97) I can't select the "DESIGN" or "NEW" in my Forms.
Table and Query seem to be ok.
Is there a way to fix it?


Check to see if your database has an mdb or an mde extension, ie,
MyDatabase.mdb or MyDatabase.mde.

If it's mde, you are using a compiled application and by design can not
change (design and new are not available) forms, reports or modules.

There's no way to fix this unless you have access to the original
MyDatabase.mdb.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Nov 13 '05 #6
On Thu, 30 Sep 2004 15:13:31 -0500, "Steve" <s-*****@physics.tamu.edu>
wrote:
When I bring up my database (access 97) I can't select the "DESIGN" or "NEW"
in my Forms.
Table and Query seem to be ok.
Is there a way to fix it?

Thank
Steve

Hi
Create a new db and import everything into it, see if that cures it
David

Nov 13 '05 #7
Steve wrote:
It is saved as an mdb but it acts like an mde.


Just because it has a mdb extension doesn't mean it isn't a mde (it could
have been renamed).

In another database create this function and see what it returns

Function IsMDE() As Boolean
On Error Resume Next
Dim strMDE As String
Dim db As Database
Set db =
DBEngine.Workspaces(0).OpenDatabase("fullpathtodat abase\whatever.mdb")
strMDE = db.Properties("MDE")
IsMDE = (Err.Number = 0 And strMDE = "T")
End Function

--
Joan Wild
Microsoft Access MVP
Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Pablo | last post by:
Friends! I need to show the dialog "select folder" and get the path selected, using vb.net. The OpenFileDialog control is useless as I want to select a folder and not a file. In vb6 I achieved...
2
by: Deborah V. Gardner | last post by:
I am using Access 97 and have had a problem joining a main form and a subform. I have a main form and a subform. The data source on the main form is a SELECT statement referring to three tables....
5
by: Jerry Hull | last post by:
I'm working with a database developed by an untrained person over several years - and on a network that has recently been upgraded with a new server installed and MS office upgraded from 2K (I...
9
by: AP | last post by:
I personally cannot stand the Allow Design Changes property set to anything other than design view. Is there a way to loop through all forms and set this property to design view only? There always...
0
by: rayone | last post by:
Hi folks. I need advice. 2 options, which do you think is the better option to display/retrieve/report on the data. Keep in mind reporting (Crystal), SQL Performance, VB Code, usability,...
5
by: Just Me | last post by:
Given a button name Btn_5 and Index=5 I want to do something like dim zz as string = Btn_??Index??.Text or given an array of buttons, do:
5
by: ThunderMusic | last post by:
Hi, I'd need to find (or develop) a control of a map (worldwide if possible) where a user can click and drag to select an area by distance from the click point or using a square area (user's...
4
by: etuncer | last post by:
Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is...
0
by: fiaolle | last post by:
Hi I have a combobox wich I set the Datasource,Displaymember and Valuemember at design time. I'm using a Dataset's table. But when I run the form the combobox isn't filled. Can't I set properties...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.