473,387 Members | 1,548 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,387 software developers and data experts.

MDE database shift bypass disabled

hi we have an mde database that was written by an ex-employee. Some update our company made is requiring us to re-link all our database tables, however, I'm assuming that the shift bypass key was disabled because when I hold down the shift key the database does not display the tables/queries etc. I'm wondering if there is a way to enable this functionality so we can update our table links.
Thank you for your assistance.
Nov 15 '10 #1
4 2070
colintis
255 100+
mde database is a locked version of the original .mdb database. Find that original .mdb database, do all the necessary upgrades to .accdb or whatever Access version you're using, including update link tables. Then go to [Database Tool] make mde/accdb in the toolbar/ribbon.
Nov 16 '10 #2
If I follow these directions, what will happen to the tables that are in the mde.
Nov 16 '10 #3
colintis
255 100+
Normally we would split the database into front-end and back-end. Where all tables are stored in the back-end (remains in .mdb), and the rest of the thing are in front-end (.mde). It is much more secure to prevent database crashes or data lost.
Nov 18 '10 #4
NeoPa
32,556 Expert Mod 16PB
Ziccardi:
Some update our company made is requiring us to re-link all our database tables
From your earlier comment I would guess that your setup is already FE/BE, and therefore the data is already stored away from the FE that you're updating (reproducing). It's always good practice though, to keep backups of everything until you are sure that you will never again need it. If you find you are missing anything vital after the new database has been put in place, then simply revert to your backup copy.
Nov 19 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: PerryC | last post by:
I have search googles and there are hundreds of tips about AllowByPassKey... however, none works for me... well, perhaps I am too new to such high level functionality that it just does not make...
1
by: Ghulam | last post by:
I am using an Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group...
3
by: Barry | last post by:
Hi, I've a database with toolbars and usual startup views disabled with startup options. As I'd now like to revert to default for futher design I would now like to change back. How do I get into...
3
by: tdmailbox | last post by:
I set up my code to disable the shift bypass however for certain users I want to allow them through a button no a form to be able open up the list of tablies and queries. Is there a vb command...
5
by: trynittee | last post by:
Hello, It's been a while since I've posted. I am an intermediate user of Access. I can read simple VB code, have done complex queries, comfortable with event procedures, designing forms and...
11
by: flynjack | last post by:
I'm sure i'm not the only one who has done this, but please HELP!!!! I have devised a new Access Database and saw online I could disable the Shift Key bypass. So, trying to advance my Access...
12
by: Steve | last post by:
I have a database that raises an error when you try to open it and it doesn't open. Trying to open the database with the OpenDatabase method raises the same error. Trying to import any objects...
3
by: CanuckChuck | last post by:
I have a code for enabling a command button to password protect the enabling/disabling of the Shift bypass. For some reason though I keep recieving a syntax error when I try to use it. I copied the...
3
by: Pietro | last post by:
Hi all, First of all I'd like to thank you very very much ,as finally after many years of searching,I could find a code to disable/enable the shift key,but actually i cannot use the code as I'm...
4
by: sarabonn | last post by:
hallo everyone, Iam using access database and visual c# 2008. Iam tried to insert data into table with lot of method but nothing works, i dont know what is wrong. here...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

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.