/    Sign up×
Community /Pin to ProfileBookmark

Anyone happen to be familiar with Microsoft Access

Copy linkTweet thisAlerts:
Jun 24.2004

I have a simple database with 2 tables that are related. I am trying to make a “data access page” using fields from those 2 tables. It works fine (displaying the data), but I wanna be able to update the data live from the webpage. It allows me to do so but makes me choose between the 2 tables – making one of them the “unique table”. That makes it so that I can only update half the form from the webpage.

Can anyone help me with this issue?

I appreciate any help,
Thank You.

to post a comment
Full-stack Developer

4 Comments(s) ↴

Copy linkTweet thisAlerts:
@the_treeJun 24.2004 — So why do think we all hate M$?

I'd just advise adjusting the structure of the database to avoid the problem.
Copy linkTweet thisAlerts:
@iamlucky13Jun 25.2004 — I suppose consolidating the two tables is not an option?

What about two database calls, one to each table, and using your script to put the data together? I don't know if it's possible in access, but it's what I'd do in SQL.
Copy linkTweet thisAlerts:
@ai3rulesauthorJun 25.2004 — I am not familiar with scripting in access - I am creating the page simply with the access wizard (I suppose that is my main problem lol).
Copy linkTweet thisAlerts:
@PeOfEoJun 25.2004 — [i]Originally posted by ai3rules [/i]

[B]I have a simple database with 2 tables that are related. I am trying to make a "data access page" using fields from those 2 tables. It works fine (displaying the data), but I wanna be able to update the data live from the webpage. It allows me to do so but makes me choose between the 2 tables - making one of them the "unique table". That makes it so that I can only update half the form from the webpage.



Can anyone help me with this issue?



I appreciate any help,

Thank You. [/B][/QUOTE] Sounds more like a server issue then the access issue because idealy you would be controlling your data with a server side script... I am not a big user of stored procedures or anything like that. The tree why not post something meaning full instead of ms bashing? What are you using, asp, php, asp.net, what? Access data bases are very easy to handle and update with a server side language -- which is what you should be using, about as easy as anything else. I suggest popping over to the asp or the .net forum if you have asp or asp.net on your server. The downside to access is that it is a file based db so thats not as secure as a server db like sql server, and it will not run as fast as a server db either. But for small data projects access will work fine.
×

Success!

Help @ai3rules spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.4,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...